eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_CSH_FCST_POP dependencies on CE_FORECAST_TRX_CELLS

Line 362: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

358: -- 5609517: Remove ORDERED hint as suggested by apps perf team
359: -- select_clause := '
360: -- SELECT /*+ ORDERED USE_MERGE(src)*/
361: select_clause := '
362: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
363: '||CE_CASH_FCST.G_forecast_id||',
364: '||CE_CASH_FCST.G_rp_forecast_header_id||',
365: '||CE_CASH_FCST.G_forecast_row_id||',
366: ''Y'',

Line 784: | This procedure inserts a row into the CE_FORECAST_TRX_CELLS |

780: | PUBLIC PROCEDURE |
781: | Insert_Fcast_Cell |
782: | |
783: | DESCRIPTION |
784: | This procedure inserts a row into the CE_FORECAST_TRX_CELLS |
785: | CALLED BY |
786: | Build_Remote_Query |
787: | REQUIRES |
788: | forecast_amount, column_id, reference_id, currency_code, |

Line 814: CE_FORECAST_TRX_CELLS_PKG.insert_row(

810: and bau.org_id = p_org_id
811: and ccid.bank_acct_use_id = bau.bank_acct_use_id;
812: END IF;
813:
814: CE_FORECAST_TRX_CELLS_PKG.insert_row(
815: X_rowid =>forecast_rowid,
816: X_FORECAST_CELL_ID =>forecast_cell_id,
817: X_FORECAST_ID =>CE_CASH_FCST.G_forecast_id,
818: X_FORECAST_HEADER_ID =>CE_CASH_FCST.G_rp_forecast_header_id,

Line 846: | This procedure inserts a row into the CE_FORECAST_TRX_CELLS table |

842: | PUBLIC PROCEDURE |
843: | Zero_Fill_Cells |
844: | |
845: | DESCRIPTION |
846: | This procedure inserts a row into the CE_FORECAST_TRX_CELLS table |
847: | for those columns for which the view produces a null row |
848: | CALLED BY |
849: | Execute_Main_Query, |
850: | REQUIRES |

Line 890: | executed - directly inserts into ce_forecast_trx_cells |

886: | |
887: | DESCRIPTION |
888: | This procedure takes in the query string and executes it using |
889: | dynamic sql functionality. The query string is parsed and then |
890: | executed - directly inserts into ce_forecast_trx_cells |
891: | from select statement |
892: | CALLED BY |
893: | Build_XX_Query |
894: | REQUIRES |

Line 927: final_query := 'INSERT INTO CE_FORECAST_TRX_CELLS(

923: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||
924: to_char(cursor_id));
925:
926: cep_standard.debug('Parsing ....');
927: final_query := 'INSERT INTO CE_FORECAST_TRX_CELLS(
928: FORECAST_CELL_ID,
929: FORECAST_ID,
930: FORECAST_HEADER_ID,
931: FORECAST_ROW_ID,

Line 959: DELETE from ce_forecast_trx_cells

955:
956: DBMS_SQL.CLOSE_CURSOR(cursor_id);
957:
958: IF(CE_CASH_FCST.G_trx_type IN ('GLB', 'GLE', 'GLA', 'PAY')) THEN
959: DELETE from ce_forecast_trx_cells
960: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
961: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id
962: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
963: END IF;

Line 967: DELETE from ce_forecast_trx_cells

963: END IF;
964:
965: IF(CE_CASH_FCST.G_trx_type IN ('APP', 'ARR') AND
966: CE_CASH_FCST.G_forecast_method = 'P') THEN
967: DELETE from ce_forecast_trx_cells
968: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
969: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id
970: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
971: END IF;

Line 974: DELETE from ce_forecast_trx_cells

970: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
971: END IF;
972:
973: IF(CE_CASH_FCST.G_invalid_overdue_row) THEN
974: DELETE from ce_forecast_trx_cells
975: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
976: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id
977: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
978: END IF;

Line 1290: FROM ce_forecast_trx_cells

1286: --------------------------------------------------------------------- */
1287: PROCEDURE Populate_Opening_Bal IS
1288:
1289: CURSOR C_bank is SELECT DISTINCT bank_account_id
1290: FROM ce_forecast_trx_cells
1291: WHERE bank_account_id is not null
1292: AND forecast_id = CE_CASH_FCST.G_forecast_id
1293: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id;
1294:

Line 1296: FROM ce_forecast_trx_cells

1292: AND forecast_id = CE_CASH_FCST.G_forecast_id
1293: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id;
1294:
1295: CURSOR C_glcp is SELECT DISTINCT code_combination_id
1296: FROM ce_forecast_trx_cells
1297: WHERE code_combination_id is not null
1298: AND forecast_id = CE_CASH_FCST.G_forecast_id
1299: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id;
1300:

Line 1846: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1842: END;
1843: IF (CE_CASH_FCST.G_order_date_type = 'V') THEN
1844: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
1845: select_clause := '
1846: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1847: '||CE_CASH_FCST.G_forecast_id||',
1848: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1849: '||CE_CASH_FCST.G_forecast_row_id||',
1850: ''Y'',

Line 1869: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1865: ||','||CE_CASH_FCST.G_precision||'),
1866: -src.amount';
1867: ELSE
1868: select_clause := '
1869: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1870: '||CE_CASH_FCST.G_forecast_id||',
1871: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1872: '||CE_CASH_FCST.G_forecast_row_id||',
1873: ''Y'',

Line 1898: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1894: AND src.status <> ''NEGOTIABLE'' ';
1895: ELSE
1896: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
1897: select_clause := '
1898: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1899: '||CE_CASH_FCST.G_forecast_id||',
1900: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1901: '||CE_CASH_FCST.G_forecast_row_id||',
1902: ''Y'',

Line 1921: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1917: ||','||CE_CASH_FCST.G_precision||'),
1918: -src.amount';
1919: ELSE
1920: select_clause := '
1921: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1922: '||CE_CASH_FCST.G_forecast_id||',
1923: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1924: '||CE_CASH_FCST.G_forecast_row_id||',
1925: ''Y'',

Line 1951: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1947: END IF;
1948: ELSE
1949: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
1950: select_clause := '
1951: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1952: '||CE_CASH_FCST.G_forecast_id||',
1953: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1954: '||CE_CASH_FCST.G_forecast_row_id||',
1955: ''Y'',

Line 1974: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1970: ||','||CE_CASH_FCST.G_precision||'),
1971: -src.amount';
1972: ELSE
1973: select_clause := '
1974: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1975: '||CE_CASH_FCST.G_forecast_id||',
1976: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1977: '||CE_CASH_FCST.G_forecast_row_id||',
1978: ''Y'',

Line 2176: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2172: CE_CASH_FCST.G_app_short_name := 'PA';
2173:
2174: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
2175: select_clause := '
2176: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2177: '||CE_CASH_FCST.G_forecast_id||',
2178: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2179: '||CE_CASH_FCST.G_forecast_row_id||',
2180: ''Y'',

Line 2200: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2196: ||','||CE_CASH_FCST.G_precision||'),
2197: src.amount';
2198: ELSE
2199: select_clause := '
2200: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2201: '||CE_CASH_FCST.G_forecast_id||',
2202: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2203: '||CE_CASH_FCST.G_forecast_row_id||',
2204: ''Y'',

Line 2269: select_clause := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2265: cep_standard.debug('>>Build_AR_Invoice_Query');
2266:
2267: IF (CE_CASH_FCST.G_include_dispute_flag = 'N') THEN
2268: IF( CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
2269: select_clause := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2270: '||CE_CASH_FCST.G_forecast_id||',
2271: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2272: '||CE_CASH_FCST.G_forecast_row_id||',
2273: ''Y'',

Line 2292: select_clause := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2288: ||CE_CASH_FCST.G_rp_exchange_rate
2289: ||','||CE_CASH_FCST.G_precision||'),
2290: src.amount-src.dispute_amount';
2291: ELSE
2292: select_clause := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2293: '||CE_CASH_FCST.G_forecast_id||',
2294: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2295: '||CE_CASH_FCST.G_forecast_row_id||',
2296: ''Y'',

Line 2456: select_clause := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2452:
2453: cep_standard.debug('Built Where Clause');
2454:
2455: IF(CE_CASH_FCST.G_rp_exchange_type = 'User') THEN
2456: select_clause := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2457: '||CE_CASH_FCST.G_forecast_id||',
2458: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2459: '||CE_CASH_FCST.G_forecast_row_id||',
2460: ''Y'',

Line 2480: select_clause := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2476: ||','
2477: ||CE_CASH_FCST.G_precision||'),
2478: src.amount';
2479: ELSE
2480: select_clause := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2481: '||CE_CASH_FCST.G_forecast_id||',
2482: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2483: '||CE_CASH_FCST.G_forecast_row_id||',
2484: ''Y'',

Line 2535: main_query := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2531: main_query varchar2(2000) := null;
2532: BEGIN
2533: cep_standard.debug('>>Get_GL_General_Query');
2534: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
2535: main_query := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2536: '||CE_CASH_FCST.G_forecast_id||',
2537: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2538: '||CE_CASH_FCST.G_forecast_row_id||',
2539: ''Y'',

Line 2556: main_query := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2552: round((nvl(src.period_net_dr,0)-nvl(src.period_net_cr,0))*'||CE_CASH_FCST.G_rp_exchange_rate
2553: ||','||CE_CASH_FCST.G_precision||'),
2554: (nvl(src.period_net_dr,0)-nvl(src.period_net_cr,0))'; --bug4495616
2555: ELSE
2556: main_query := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2557: '||CE_CASH_FCST.G_forecast_id||',
2558: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2559: '||CE_CASH_FCST.G_forecast_row_id||',
2560: ''Y'',

Line 3012: -- select_clause_2 := 'SELECT /+ ORDERED USE_MERGE(src)/ CE_FORECAST_TRX_CELLS_S.nextval,

3008:
3009: IF (CE_CASH_FCST.G_use_payment_terms = 'Y') THEN
3010: IF (CE_CASH_FCST.G_rp_exchange_type = 'User') THEN
3011: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3012: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,
3013: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
3014: '||CE_CASH_FCST.G_forecast_id||',
3015: '||CE_CASH_FCST.G_rp_forecast_header_id||',
3016: '||CE_CASH_FCST.G_forecast_row_id||',

Line 3013: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,

3009: IF (CE_CASH_FCST.G_use_payment_terms = 'Y') THEN
3010: IF (CE_CASH_FCST.G_rp_exchange_type = 'User') THEN
3011: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3012: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,
3013: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
3014: '||CE_CASH_FCST.G_forecast_id||',
3015: '||CE_CASH_FCST.G_rp_forecast_header_id||',
3016: '||CE_CASH_FCST.G_forecast_row_id||',
3017: ''Y'',

Line 3047: -- select_clause_2 := 'SELECT /+ ORDERED USE_MERGE(src)/ CE_FORECAST_TRX_CELLS_S.nextval,

3043: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3044: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))';
3045: ELSE
3046: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3047: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,
3048: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
3049: '||CE_CASH_FCST.G_forecast_id||',
3050: '||CE_CASH_FCST.G_rp_forecast_header_id||',
3051: '||CE_CASH_FCST.G_forecast_row_id||',

Line 3048: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,

3044: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))';
3045: ELSE
3046: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3047: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,
3048: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
3049: '||CE_CASH_FCST.G_forecast_id||',
3050: '||CE_CASH_FCST.G_rp_forecast_header_id||',
3051: '||CE_CASH_FCST.G_forecast_row_id||',
3052: ''Y'',

Line 4255: SELECT /+ USE_MERGE(o3,hr_ou) +/ CE_FORECAST_TRX_CELLS_S.nextval,

4251: IF (CE_CASH_FCST.G_use_payment_terms = 'Y') THEN
4252: IF(CE_CASH_FCST.G_order_date_type = 'R')THEN
4253: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4254: select_clause_2 := '
4255: SELECT /*+ USE_MERGE(o3,hr_ou) +*/ CE_FORECAST_TRX_CELLS_S.nextval,
4256: '||CE_CASH_FCST.G_forecast_id||',
4257: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4258: '||CE_CASH_FCST.G_forecast_row_id||',
4259: ''Y'',

Line 4285: SELECT /+ USE_MERGE(o3,hr_ou) +/ CE_FORECAST_TRX_CELLS_S.nextval,

4281: ||','||CE_CASH_FCST.G_precision||'),
4282: nvl(src.amount,0) * (nvl(src.relative_amount,100)/100)';
4283: ELSE
4284: select_clause_2 := '
4285: SELECT /*+ USE_MERGE(o3,hr_ou) +*/ CE_FORECAST_TRX_CELLS_S.nextval,
4286: '||CE_CASH_FCST.G_forecast_id||',
4287: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4288: '||CE_CASH_FCST.G_forecast_row_id||',
4289: ''Y'',

Line 4328: SELECT /+ USE_MERGE(o3,hr_ou) +/ CE_FORECAST_TRX_CELLS_S.nextval,

4324: ||to_char(CE_CASH_FCST.G_lead_time);
4325: ELSE
4326: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4327: select_clause_2 := '
4328: SELECT /*+ USE_MERGE(o3,hr_ou) +*/ CE_FORECAST_TRX_CELLS_S.nextval,
4329: '||CE_CASH_FCST.G_forecast_id||',
4330: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4331: '||CE_CASH_FCST.G_forecast_row_id||',
4332: ''Y'',

Line 4358: SELECT /+ USE_MERGE(o3,hr_ou) +/ CE_FORECAST_TRX_CELLS_S.nextval,

4354: ||','||CE_CASH_FCST.G_precision||'),
4355: nvl(src.amount,0) * (nvl(src.relative_amount,100)/100)';
4356: ELSE
4357: select_clause_2 := '
4358: SELECT /*+ USE_MERGE(o3,hr_ou) +*/ CE_FORECAST_TRX_CELLS_S.nextval,
4359: '||CE_CASH_FCST.G_forecast_id||',
4360: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4361: '||CE_CASH_FCST.G_forecast_row_id||',
4362: ''Y'',

Line 4402: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4398: ELSE -- payment_term = 'N'
4399: IF(CE_CASH_FCST.G_order_date_type = 'R')THEN
4400: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4401: select_clause_1 := '
4402: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4403: '||CE_CASH_FCST.G_forecast_id||',
4404: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4405: '||CE_CASH_FCST.G_forecast_row_id||',
4406: ''Y'',

Line 4425: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4421: ||','||CE_CASH_FCST.G_precision||'),
4422: src.amount';
4423: ELSE
4424: select_clause_1 := '
4425: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4426: '||CE_CASH_FCST.G_forecast_id||',
4427: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4428: '||CE_CASH_FCST.G_forecast_row_id||',
4429: ''Y'',

Line 4455: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4451: ||to_char(CE_CASH_FCST.G_lead_time);
4452: ELSE
4453: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4454: select_clause_1 := '
4455: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4456: '||CE_CASH_FCST.G_forecast_id||',
4457: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4458: '||CE_CASH_FCST.G_forecast_row_id||',
4459: ''Y'',

Line 4478: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4474: ||','||CE_CASH_FCST.G_precision||'),
4475: src.amount';
4476: ELSE
4477: select_clause_1 := '
4478: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4479: '||CE_CASH_FCST.G_forecast_id||',
4480: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4481: '||CE_CASH_FCST.G_forecast_row_id||',
4482: ''Y'',

Line 4511: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4507:
4508: IF(CE_CASH_FCST.G_order_date_type = 'R')THEN
4509: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4510: select_clause_3 := '
4511: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4512: '||CE_CASH_FCST.G_forecast_id||',
4513: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4514: '||CE_CASH_FCST.G_forecast_row_id||',
4515: ''Y'',

Line 4534: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4530: ||','||CE_CASH_FCST.G_precision||'),
4531: src.amount';
4532: ELSE
4533: select_clause_3 := '
4534: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4535: '||CE_CASH_FCST.G_forecast_id||',
4536: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4537: '||CE_CASH_FCST.G_forecast_row_id||',
4538: ''Y'',

Line 4564: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4560: ||to_char(CE_CASH_FCST.G_lead_time);
4561: ELSE
4562: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4563: select_clause_3 := '
4564: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4565: '||CE_CASH_FCST.G_forecast_id||',
4566: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4567: '||CE_CASH_FCST.G_forecast_row_id||',
4568: ''Y'',

Line 4587: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4583: ||','||CE_CASH_FCST.G_precision||'),
4584: src.amount';
4585: ELSE
4586: select_clause_3 := '
4587: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4588: '||CE_CASH_FCST.G_forecast_id||',
4589: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4590: '||CE_CASH_FCST.G_forecast_row_id||',
4591: ''Y'',

Line 4665: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4661: CE_CASH_FCST.G_app_short_name := 'PA';
4662:
4663: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4664: select_clause := '
4665: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4666: '||CE_CASH_FCST.G_forecast_id||',
4667: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4668: '||CE_CASH_FCST.G_forecast_row_id||',
4669: ''Y'',

Line 4688: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4684: ||','||CE_CASH_FCST.G_precision||'),
4685: -src.amount';
4686: ELSE
4687: select_clause := '
4688: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4689: '||CE_CASH_FCST.G_forecast_id||',
4690: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4691: '||CE_CASH_FCST.G_forecast_row_id||',
4692: ''Y'',

Line 4836: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4832: BEGIN
4833:
4834: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4835: select_clause := '
4836: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4837: '||CE_CASH_FCST.G_forecast_id||',
4838: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4839: '||CE_CASH_FCST.G_forecast_row_id||',
4840: ''Y'',

Line 4859: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4855: ||','||CE_CASH_FCST.G_precision||'),
4856: src.amount';
4857: ELSE
4858: select_clause := '
4859: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4860: '||CE_CASH_FCST.G_forecast_id||',
4861: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4862: '||CE_CASH_FCST.G_forecast_row_id||',
4863: ''Y'',

Line 5102: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

5098: main_query varchar2(3500) := null;
5099: BEGIN
5100: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
5101: select_clause := '
5102: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
5103: '||CE_CASH_FCST.G_forecast_id||',
5104: '||CE_CASH_FCST.G_rp_forecast_header_id||',
5105: '||CE_CASH_FCST.G_forecast_row_id||',
5106: ''Y'',

Line 5125: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

5121: ||','||CE_CASH_FCST.G_precision||'),
5122: src.amount';
5123: ELSE
5124: select_clause := '
5125: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
5126: '||CE_CASH_FCST.G_forecast_id||',
5127: '||CE_CASH_FCST.G_rp_forecast_header_id||',
5128: '||CE_CASH_FCST.G_forecast_row_id||',
5129: ''Y'',