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 423: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

419: -- 5609517: Remove ORDERED hint as suggested by apps perf team
420: -- select_clause := '
421: -- SELECT /*+ ORDERED USE_MERGE(src)*/
422: select_clause := '
423: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
424: '||CE_CASH_FCST.G_forecast_id||',
425: '||CE_CASH_FCST.G_rp_forecast_header_id||',
426: '||CE_CASH_FCST.G_forecast_row_id||',
427: ''Y'',

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

841: | PUBLIC PROCEDURE |
842: | Insert_Fcast_Cell |
843: | |
844: | DESCRIPTION |
845: | This procedure inserts a row into the CE_FORECAST_TRX_CELLS |
846: | CALLED BY |
847: | Build_Remote_Query |
848: | REQUIRES |
849: | forecast_amount, column_id, reference_id, currency_code, |

Line 882: CE_FORECAST_TRX_CELLS_PKG.insert_row(

878: where bau.bank_account_id = p_bank_account_id ;
879: End if ;
880: END IF; -- Bug 13601973
881:
882: CE_FORECAST_TRX_CELLS_PKG.insert_row(
883: X_rowid =>forecast_rowid,
884: X_FORECAST_CELL_ID =>forecast_cell_id,
885: X_FORECAST_ID =>CE_CASH_FCST.G_forecast_id,
886: X_FORECAST_HEADER_ID =>CE_CASH_FCST.G_rp_forecast_header_id,

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

910: | PUBLIC PROCEDURE |
911: | Zero_Fill_Cells |
912: | |
913: | DESCRIPTION |
914: | This procedure inserts a row into the CE_FORECAST_TRX_CELLS table |
915: | for those columns for which the view produces a null row |
916: | CALLED BY |
917: | Execute_Main_Query, |
918: | REQUIRES |

Line 958: | executed - directly inserts into ce_forecast_trx_cells |

954: | |
955: | DESCRIPTION |
956: | This procedure takes in the query string and executes it using |
957: | dynamic sql functionality. The query string is parsed and then |
958: | executed - directly inserts into ce_forecast_trx_cells |
959: | from select statement |
960: | CALLED BY |
961: | Build_XX_Query |
962: | REQUIRES |

Line 995: final_query := 'INSERT INTO CE_FORECAST_TRX_CELLS(

991: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||
992: to_char(cursor_id));
993:
994: cep_standard.debug('Parsing ....');
995: final_query := 'INSERT INTO CE_FORECAST_TRX_CELLS(
996: FORECAST_CELL_ID,
997: FORECAST_ID,
998: FORECAST_HEADER_ID,
999: FORECAST_ROW_ID,

Line 1027: DELETE from ce_forecast_trx_cells

1023:
1024: DBMS_SQL.CLOSE_CURSOR(cursor_id);
1025:
1026: IF(CE_CASH_FCST.G_trx_type IN ('GLB', 'GLE', 'GLA', 'PAY')) THEN
1027: DELETE from ce_forecast_trx_cells
1028: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
1029: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id
1030: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
1031: END IF;

Line 1035: DELETE from ce_forecast_trx_cells

1031: END IF;
1032:
1033: IF(CE_CASH_FCST.G_trx_type IN ('APP', 'ARR') AND
1034: CE_CASH_FCST.G_forecast_method = 'P') THEN
1035: DELETE from ce_forecast_trx_cells
1036: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
1037: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id
1038: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
1039: END IF;

Line 1042: DELETE from ce_forecast_trx_cells

1038: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
1039: END IF;
1040:
1041: IF(CE_CASH_FCST.G_invalid_overdue_row) THEN
1042: DELETE from ce_forecast_trx_cells
1043: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
1044: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id
1045: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
1046: END IF;

Line 1359: FROM ce_forecast_trx_cells

1355: --------------------------------------------------------------------- */
1356: PROCEDURE Populate_Opening_Bal IS
1357:
1358: CURSOR C_bank is SELECT DISTINCT bank_account_id
1359: FROM ce_forecast_trx_cells
1360: WHERE bank_account_id is not null
1361: AND forecast_id = CE_CASH_FCST.G_forecast_id
1362: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id;
1363:

Line 1365: FROM ce_forecast_trx_cells

1361: AND forecast_id = CE_CASH_FCST.G_forecast_id
1362: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id;
1363:
1364: CURSOR C_glcp is SELECT DISTINCT code_combination_id
1365: FROM ce_forecast_trx_cells
1366: WHERE code_combination_id is not null
1367: AND forecast_id = CE_CASH_FCST.G_forecast_id
1368: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id;
1369:

Line 1915: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1911: END;
1912: IF (CE_CASH_FCST.G_order_date_type = 'V') THEN
1913: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
1914: select_clause := '
1915: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1916: '||CE_CASH_FCST.G_forecast_id||',
1917: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1918: '||CE_CASH_FCST.G_forecast_row_id||',
1919: ''Y'',

Line 1938: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1934: ||','||CE_CASH_FCST.G_precision||'),
1935: -src.amount';
1936: ELSE
1937: select_clause := '
1938: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1939: '||CE_CASH_FCST.G_forecast_id||',
1940: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1941: '||CE_CASH_FCST.G_forecast_row_id||',
1942: ''Y'',

Line 1967: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1963: AND src.status <> ''NEGOTIABLE'' ';
1964: ELSE
1965: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
1966: select_clause := '
1967: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1968: '||CE_CASH_FCST.G_forecast_id||',
1969: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1970: '||CE_CASH_FCST.G_forecast_row_id||',
1971: ''Y'',

Line 1990: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

1986: ||','||CE_CASH_FCST.G_precision||'),
1987: -src.amount';
1988: ELSE
1989: select_clause := '
1990: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
1991: '||CE_CASH_FCST.G_forecast_id||',
1992: '||CE_CASH_FCST.G_rp_forecast_header_id||',
1993: '||CE_CASH_FCST.G_forecast_row_id||',
1994: ''Y'',

Line 2020: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2016: END IF;
2017: ELSE
2018: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
2019: select_clause := '
2020: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2021: '||CE_CASH_FCST.G_forecast_id||',
2022: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2023: '||CE_CASH_FCST.G_forecast_row_id||',
2024: ''Y'',

Line 2043: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2039: ||','||CE_CASH_FCST.G_precision||'),
2040: -src.amount';
2041: ELSE
2042: select_clause := '
2043: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2044: '||CE_CASH_FCST.G_forecast_id||',
2045: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2046: '||CE_CASH_FCST.G_forecast_row_id||',
2047: ''Y'',

Line 2249: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2245: CE_CASH_FCST.G_app_short_name := 'PA';
2246:
2247: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
2248: select_clause := '
2249: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2250: '||CE_CASH_FCST.G_forecast_id||',
2251: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2252: '||CE_CASH_FCST.G_forecast_row_id||',
2253: ''Y'',

Line 2273: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2269: ||','||CE_CASH_FCST.G_precision||'),
2270: src.amount';
2271: ELSE
2272: select_clause := '
2273: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2274: '||CE_CASH_FCST.G_forecast_id||',
2275: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2276: '||CE_CASH_FCST.G_forecast_row_id||',
2277: ''Y'',

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

2338: cep_standard.debug('>>Build_AR_Invoice_Query');
2339:
2340: IF (CE_CASH_FCST.G_include_dispute_flag = 'N') THEN
2341: IF( CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
2342: select_clause := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2343: '||CE_CASH_FCST.G_forecast_id||',
2344: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2345: '||CE_CASH_FCST.G_forecast_row_id||',
2346: ''Y'',

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

2361: ||CE_CASH_FCST.G_rp_exchange_rate
2362: ||','||CE_CASH_FCST.G_precision||'),
2363: src.amount-src.dispute_amount';
2364: ELSE
2365: select_clause := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2366: '||CE_CASH_FCST.G_forecast_id||',
2367: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2368: '||CE_CASH_FCST.G_forecast_row_id||',
2369: ''Y'',

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

2528:
2529: cep_standard.debug('Built Where Clause');
2530:
2531: IF(CE_CASH_FCST.G_rp_exchange_type = 'User') THEN
2532: select_clause := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2533: '||CE_CASH_FCST.G_forecast_id||',
2534: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2535: '||CE_CASH_FCST.G_forecast_row_id||',
2536: ''Y'',

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

2552: ||','
2553: ||CE_CASH_FCST.G_precision||'),
2554: src.amount';
2555: ELSE
2556: select_clause := '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 2611: main_query := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,

2607: main_query varchar2(2000) := null;
2608: BEGIN
2609: cep_standard.debug('>>Get_GL_General_Query');
2610: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
2611: main_query := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2612: '||CE_CASH_FCST.G_forecast_id||',
2613: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2614: '||CE_CASH_FCST.G_forecast_row_id||',
2615: ''Y'',

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

2628: round((nvl(src.period_net_dr,0)-nvl(src.period_net_cr,0))*'||CE_CASH_FCST.G_rp_exchange_rate
2629: ||','||CE_CASH_FCST.G_precision||'),
2630: (nvl(src.period_net_dr,0)-nvl(src.period_net_cr,0))'; --bug4495616
2631: ELSE
2632: main_query := ' SELECT CE_FORECAST_TRX_CELLS_S.nextval,
2633: '||CE_CASH_FCST.G_forecast_id||',
2634: '||CE_CASH_FCST.G_rp_forecast_header_id||',
2635: '||CE_CASH_FCST.G_forecast_row_id||',
2636: ''Y'',

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

3084:
3085: IF (CE_CASH_FCST.G_use_payment_terms = 'Y') THEN
3086: IF (CE_CASH_FCST.G_rp_exchange_type = 'User') THEN
3087: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3088: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,
3089: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
3090: '||CE_CASH_FCST.G_forecast_id||',
3091: '||CE_CASH_FCST.G_rp_forecast_header_id||',
3092: '||CE_CASH_FCST.G_forecast_row_id||',

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

3085: IF (CE_CASH_FCST.G_use_payment_terms = 'Y') THEN
3086: IF (CE_CASH_FCST.G_rp_exchange_type = 'User') THEN
3087: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3088: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,
3089: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
3090: '||CE_CASH_FCST.G_forecast_id||',
3091: '||CE_CASH_FCST.G_rp_forecast_header_id||',
3092: '||CE_CASH_FCST.G_forecast_row_id||',
3093: ''Y'',

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

3119: (select nvl(src.amount,0) - sum(t.due_amount) from ap_terms_lines t where t.term_id = src.term_id),
3120: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))';
3121: ELSE
3122: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3123: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,
3124: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
3125: '||CE_CASH_FCST.G_forecast_id||',
3126: '||CE_CASH_FCST.G_rp_forecast_header_id||',
3127: '||CE_CASH_FCST.G_forecast_row_id||',

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

3120: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))';
3121: ELSE
3122: -- 5609517: Remove ORDERED hint as suggested by apps perf team
3123: -- select_clause_2 := 'SELECT /*+ ORDERED USE_MERGE(src)*/ CE_FORECAST_TRX_CELLS_S.nextval,
3124: select_clause_2 := 'SELECT CE_FORECAST_TRX_CELLS_S.nextval,
3125: '||CE_CASH_FCST.G_forecast_id||',
3126: '||CE_CASH_FCST.G_rp_forecast_header_id||',
3127: '||CE_CASH_FCST.G_forecast_row_id||',
3128: ''Y'',

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

4327: IF (CE_CASH_FCST.G_use_payment_terms = 'Y') THEN
4328: IF(CE_CASH_FCST.G_order_date_type = 'R')THEN
4329: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4330: select_clause_2 := '
4331: SELECT /*+ USE_MERGE(o3,hr_ou) +*/ CE_FORECAST_TRX_CELLS_S.nextval,
4332: '||CE_CASH_FCST.G_forecast_id||',
4333: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4334: '||CE_CASH_FCST.G_forecast_row_id||',
4335: ''Y'',

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

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

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

4400: ||to_char(CE_CASH_FCST.G_lead_time);
4401: ELSE
4402: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4403: select_clause_2 := '
4404: SELECT /*+ USE_MERGE(o3,hr_ou) +*/ CE_FORECAST_TRX_CELLS_S.nextval,
4405: '||CE_CASH_FCST.G_forecast_id||',
4406: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4407: '||CE_CASH_FCST.G_forecast_row_id||',
4408: ''Y'',

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

4430: ||','||CE_CASH_FCST.G_precision||'),
4431: nvl(src.amount,0) * (nvl(src.relative_amount,100)/100)';
4432: ELSE
4433: select_clause_2 := '
4434: SELECT /*+ USE_MERGE(o3,hr_ou) +*/ CE_FORECAST_TRX_CELLS_S.nextval,
4435: '||CE_CASH_FCST.G_forecast_id||',
4436: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4437: '||CE_CASH_FCST.G_forecast_row_id||',
4438: ''Y'',

Line 4478: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4474: ELSE -- payment_term = 'N'
4475: IF(CE_CASH_FCST.G_order_date_type = 'R')THEN
4476: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
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 4501: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4497: ||','||CE_CASH_FCST.G_precision||'),
4498: src.amount';
4499: ELSE
4500: select_clause_1 := '
4501: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4502: '||CE_CASH_FCST.G_forecast_id||',
4503: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4504: '||CE_CASH_FCST.G_forecast_row_id||',
4505: ''Y'',

Line 4531: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4527: ||to_char(CE_CASH_FCST.G_lead_time);
4528: ELSE
4529: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4530: select_clause_1 := '
4531: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4532: '||CE_CASH_FCST.G_forecast_id||',
4533: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4534: '||CE_CASH_FCST.G_forecast_row_id||',
4535: ''Y'',

Line 4554: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4550: ||','||CE_CASH_FCST.G_precision||'),
4551: src.amount';
4552: ELSE
4553: select_clause_1 := '
4554: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4555: '||CE_CASH_FCST.G_forecast_id||',
4556: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4557: '||CE_CASH_FCST.G_forecast_row_id||',
4558: ''Y'',

Line 4587: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4583:
4584: IF(CE_CASH_FCST.G_order_date_type = 'R')THEN
4585: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
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 4610: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4606: ||','||CE_CASH_FCST.G_precision||'),
4607: src.amount';
4608: ELSE
4609: select_clause_3 := '
4610: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4611: '||CE_CASH_FCST.G_forecast_id||',
4612: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4613: '||CE_CASH_FCST.G_forecast_row_id||',
4614: ''Y'',

Line 4640: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4636: ||to_char(CE_CASH_FCST.G_lead_time);
4637: ELSE
4638: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4639: select_clause_3 := '
4640: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4641: '||CE_CASH_FCST.G_forecast_id||',
4642: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4643: '||CE_CASH_FCST.G_forecast_row_id||',
4644: ''Y'',

Line 4663: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4659: ||','||CE_CASH_FCST.G_precision||'),
4660: src.amount';
4661: ELSE
4662: select_clause_3 := '
4663: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4664: '||CE_CASH_FCST.G_forecast_id||',
4665: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4666: '||CE_CASH_FCST.G_forecast_row_id||',
4667: ''Y'',

Line 4741: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4737: CE_CASH_FCST.G_app_short_name := 'PA';
4738:
4739: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4740: select_clause := '
4741: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4742: '||CE_CASH_FCST.G_forecast_id||',
4743: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4744: '||CE_CASH_FCST.G_forecast_row_id||',
4745: ''Y'',

Line 4764: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4760: ||','||CE_CASH_FCST.G_precision||'),
4761: -src.amount';
4762: ELSE
4763: select_clause := '
4764: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4765: '||CE_CASH_FCST.G_forecast_id||',
4766: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4767: '||CE_CASH_FCST.G_forecast_row_id||',
4768: ''Y'',

Line 4912: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4908: BEGIN
4909:
4910: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
4911: select_clause := '
4912: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4913: '||CE_CASH_FCST.G_forecast_id||',
4914: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4915: '||CE_CASH_FCST.G_forecast_row_id||',
4916: ''Y'',

Line 4935: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

4931: ||','||CE_CASH_FCST.G_precision||'),
4932: src.amount';
4933: ELSE
4934: select_clause := '
4935: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
4936: '||CE_CASH_FCST.G_forecast_id||',
4937: '||CE_CASH_FCST.G_rp_forecast_header_id||',
4938: '||CE_CASH_FCST.G_forecast_row_id||',
4939: ''Y'',

Line 5253: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

5249: main_query varchar2(3500) := null;
5250: BEGIN
5251: IF(CE_CASH_FCST.G_rp_exchange_type = 'User')THEN
5252: select_clause := '
5253: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
5254: '||CE_CASH_FCST.G_forecast_id||',
5255: '||CE_CASH_FCST.G_rp_forecast_header_id||',
5256: '||CE_CASH_FCST.G_forecast_row_id||',
5257: ''Y'',

Line 5276: SELECT CE_FORECAST_TRX_CELLS_S.nextval,

5272: ||','||CE_CASH_FCST.G_precision||'),
5273: src.amount';
5274: ELSE
5275: select_clause := '
5276: SELECT CE_FORECAST_TRX_CELLS_S.nextval,
5277: '||CE_CASH_FCST.G_forecast_id||',
5278: '||CE_CASH_FCST.G_rp_forecast_header_id||',
5279: '||CE_CASH_FCST.G_forecast_row_id||',
5280: ''Y'',