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.GCS_RP_UTIL_BUILD_PKG dependencies on AD_DDL

Line 14: ad_ddl.build_statement(' ' || p_prefix || p_column_name || ', ', p_rownum); p_rownum:=p_rownum+1;

10: p_column_name IN VARCHAR2)
11: IS
12: BEGIN
13: IF (p_dimension_required = 'Y') THEN
14: ad_ddl.build_statement(' ' || p_prefix || p_column_name || ', ', p_rownum); p_rownum:=p_rownum+1;
15: END IF;
16: END add_insert_clause_to_list;
17:
18: PROCEDURE build_insert_clause_list (p_rownum IN OUT NOCOPY NUMBER,

Line 143: ad_ddl.build_statement(' , ' || p_table_alias || p_column_name, p_rownum); p_rownum := p_rownum +1;

139: p_column_name IN VARCHAR2)
140: IS
141: BEGIN
142: IF (p_dimension_required = 'Y') THEN
143: ad_ddl.build_statement(' , ' || p_table_alias || p_column_name, p_rownum); p_rownum := p_rownum +1;
144: END IF;
145: END add_select_clause_to_list;
146:
147: PROCEDURE build_select_clause_list (p_rownum IN OUT NOCOPY NUMBER,

Line 274: ad_ddl.build_statement(' ,' || p_table_alias || '.' || p_column_name , p_rownum); p_rownum := p_rownum + 1;

270: IS
271: BEGIN
272: IF (p_dimension_required = 'Y') THEN
273: if (p_assign_type = 'variableassignment') then
274: ad_ddl.build_statement(' ,' || p_table_alias || '.' || p_column_name , p_rownum); p_rownum := p_rownum + 1;
275: else
276: if (p_column_name <> 'line_item_id') then
277: ad_ddl.build_statement(' ,' || p_table_alias || p_column_name, p_rownum); p_rownum := p_rownum + 1;
278: end if;

Line 277: ad_ddl.build_statement(' ,' || p_table_alias || p_column_name, p_rownum); p_rownum := p_rownum + 1;

273: if (p_assign_type = 'variableassignment') then
274: ad_ddl.build_statement(' ,' || p_table_alias || '.' || p_column_name , p_rownum); p_rownum := p_rownum + 1;
275: else
276: if (p_column_name <> 'line_item_id') then
277: ad_ddl.build_statement(' ,' || p_table_alias || p_column_name, p_rownum); p_rownum := p_rownum + 1;
278: end if;
279: end if;
280: END IF;
281: END add_column_to_group;

Line 429: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE GCS_RP_UTILITY_PKG AS', r); r := r+1;

425: comp_err VARCHAR2(200) := NULL;
426: BEGIN
427:
428: --Create Package Specification for RP Utility Package
429: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE GCS_RP_UTILITY_PKG AS', r); r := r+1;
430: ad_ddl.build_statement(' ', r); r := r+1;
431: ad_ddl.build_statement('--API Name', r); r := r+1;
432: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_RP_UTILITY_PKG'';', r); r := r+1;
433: ad_ddl.build_statement(' ', r); r := r+1;

Line 430: ad_ddl.build_statement(' ', r); r := r+1;

426: BEGIN
427:
428: --Create Package Specification for RP Utility Package
429: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE GCS_RP_UTILITY_PKG AS', r); r := r+1;
430: ad_ddl.build_statement(' ', r); r := r+1;
431: ad_ddl.build_statement('--API Name', r); r := r+1;
432: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_RP_UTILITY_PKG'';', r); r := r+1;
433: ad_ddl.build_statement(' ', r); r := r+1;
434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;

Line 431: ad_ddl.build_statement('--API Name', r); r := r+1;

427:
428: --Create Package Specification for RP Utility Package
429: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE GCS_RP_UTILITY_PKG AS', r); r := r+1;
430: ad_ddl.build_statement(' ', r); r := r+1;
431: ad_ddl.build_statement('--API Name', r); r := r+1;
432: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_RP_UTILITY_PKG'';', r); r := r+1;
433: ad_ddl.build_statement(' ', r); r := r+1;
434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;
435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;

Line 432: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_RP_UTILITY_PKG'';', r); r := r+1;

428: --Create Package Specification for RP Utility Package
429: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE GCS_RP_UTILITY_PKG AS', r); r := r+1;
430: ad_ddl.build_statement(' ', r); r := r+1;
431: ad_ddl.build_statement('--API Name', r); r := r+1;
432: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_RP_UTILITY_PKG'';', r); r := r+1;
433: ad_ddl.build_statement(' ', r); r := r+1;
434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;
435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;
436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;

Line 433: ad_ddl.build_statement(' ', r); r := r+1;

429: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE GCS_RP_UTILITY_PKG AS', r); r := r+1;
430: ad_ddl.build_statement(' ', r); r := r+1;
431: ad_ddl.build_statement('--API Name', r); r := r+1;
432: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_RP_UTILITY_PKG'';', r); r := r+1;
433: ad_ddl.build_statement(' ', r); r := r+1;
434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;
435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;
436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;
437: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r); r:=r+1;

Line 434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;

430: ad_ddl.build_statement(' ', r); r := r+1;
431: ad_ddl.build_statement('--API Name', r); r := r+1;
432: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_RP_UTILITY_PKG'';', r); r := r+1;
433: ad_ddl.build_statement(' ', r); r := r+1;
434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;
435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;
436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;
437: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r); r:=r+1;
438: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := ''

Line 435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;

431: ad_ddl.build_statement('--API Name', r); r := r+1;
432: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_RP_UTILITY_PKG'';', r); r := r+1;
433: ad_ddl.build_statement(' ', r); r := r+1;
434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;
435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;
436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;
437: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r); r:=r+1;
438: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 439: ad_ddl.build_statement(' ', r); r:=r+1;

Line 436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;

432: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_RP_UTILITY_PKG'';', r); r := r+1;
433: ad_ddl.build_statement(' ', r); r := r+1;
434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;
435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;
436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;
437: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r); r:=r+1;
438: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 439: ad_ddl.build_statement(' ', r); r:=r+1;
440: ad_ddl.build_statement(' g_rp_selColumnList VARCHAR2(10000) := ''', r); r:=r+1;

Line 437: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r); r:=r+1;

433: ad_ddl.build_statement(' ', r); r := r+1;
434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;
435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;
436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;
437: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r); r:=r+1;
438: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 439: ad_ddl.build_statement(' ', r); r:=r+1;
440: ad_ddl.build_statement(' g_rp_selColumnList VARCHAR2(10000) := ''', r); r:=r+1;
441: build_select_clause_list(r,'b.');

Line 438: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := ''

434: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for', r); r:=r+1;
435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;
436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;
437: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r); r:=r+1;
438: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 439: ad_ddl.build_statement(' ', r); r:=r+1;
440: ad_ddl.build_statement(' g_rp_selColumnList VARCHAR2(10000) := ''', r); r:=r+1;
441: build_select_clause_list(r,'b.');
442: ad_ddl.build_statement(' ''; ', r); r:=r+1;

Line 439: ad_ddl.build_statement(' ', r); r:=r+1;

435: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r); r:=r+1;
436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;
437: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r); r:=r+1;
438: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 439: ad_ddl.build_statement(' ', r); r:=r+1;
440: ad_ddl.build_statement(' g_rp_selColumnList VARCHAR2(10000) := ''', r); r:=r+1;
441: build_select_clause_list(r,'b.');
442: ad_ddl.build_statement(' ''; ', r); r:=r+1;
443: ad_ddl.build_statement(' ', r); r:=r+1;

Line 440: ad_ddl.build_statement(' g_rp_selColumnList VARCHAR2(10000) := ''', r); r:=r+1;

436: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r); r:=r+1;
437: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r); r:=r+1;
438: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 439: ad_ddl.build_statement(' ', r); r:=r+1;
440: ad_ddl.build_statement(' g_rp_selColumnList VARCHAR2(10000) := ''', r); r:=r+1;
441: build_select_clause_list(r,'b.');
442: ad_ddl.build_statement(' ''; ', r); r:=r+1;
443: ad_ddl.build_statement(' ', r); r:=r+1;
444: ad_ddl.build_statement(' g_rp_srcColumnList VARCHAR2(10000) := ''', r); r:=r+1;

Line 442: ad_ddl.build_statement(' ''; ', r); r:=r+1;

438: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 439: ad_ddl.build_statement(' ', r); r:=r+1;
440: ad_ddl.build_statement(' g_rp_selColumnList VARCHAR2(10000) := ''', r); r:=r+1;
441: build_select_clause_list(r,'b.');
442: ad_ddl.build_statement(' ''; ', r); r:=r+1;
443: ad_ddl.build_statement(' ', r); r:=r+1;
444: ad_ddl.build_statement(' g_rp_srcColumnList VARCHAR2(10000) := ''', r); r:=r+1;
445: build_select_clause_list(r,'src_');
446: ad_ddl.build_statement(' ''; ', r); r:=r+1;

Line 443: ad_ddl.build_statement(' ', r); r:=r+1;

439: ad_ddl.build_statement(' ', r); r:=r+1;
440: ad_ddl.build_statement(' g_rp_selColumnList VARCHAR2(10000) := ''', r); r:=r+1;
441: build_select_clause_list(r,'b.');
442: ad_ddl.build_statement(' ''; ', r); r:=r+1;
443: ad_ddl.build_statement(' ', r); r:=r+1;
444: ad_ddl.build_statement(' g_rp_srcColumnList VARCHAR2(10000) := ''', r); r:=r+1;
445: build_select_clause_list(r,'src_');
446: ad_ddl.build_statement(' ''; ', r); r:=r+1;
447: ad_ddl.build_statement(' ', r); r:=r+1;

Line 444: ad_ddl.build_statement(' g_rp_srcColumnList VARCHAR2(10000) := ''', r); r:=r+1;

440: ad_ddl.build_statement(' g_rp_selColumnList VARCHAR2(10000) := ''', r); r:=r+1;
441: build_select_clause_list(r,'b.');
442: ad_ddl.build_statement(' ''; ', r); r:=r+1;
443: ad_ddl.build_statement(' ', r); r:=r+1;
444: ad_ddl.build_statement(' g_rp_srcColumnList VARCHAR2(10000) := ''', r); r:=r+1;
445: build_select_clause_list(r,'src_');
446: ad_ddl.build_statement(' ''; ', r); r:=r+1;
447: ad_ddl.build_statement(' ', r); r:=r+1;
448: ad_ddl.build_statement(' g_rp_tgtColumnList VARCHAR2(10000) := ''', r); r:=r+1;

Line 446: ad_ddl.build_statement(' ''; ', r); r:=r+1;

442: ad_ddl.build_statement(' ''; ', r); r:=r+1;
443: ad_ddl.build_statement(' ', r); r:=r+1;
444: ad_ddl.build_statement(' g_rp_srcColumnList VARCHAR2(10000) := ''', r); r:=r+1;
445: build_select_clause_list(r,'src_');
446: ad_ddl.build_statement(' ''; ', r); r:=r+1;
447: ad_ddl.build_statement(' ', r); r:=r+1;
448: ad_ddl.build_statement(' g_rp_tgtColumnList VARCHAR2(10000) := ''', r); r:=r+1;
449: build_select_clause_list(r,'tgt_');
450: ad_ddl.build_statement(' ''; ', r); r:=r+1;

Line 447: ad_ddl.build_statement(' ', r); r:=r+1;

443: ad_ddl.build_statement(' ', r); r:=r+1;
444: ad_ddl.build_statement(' g_rp_srcColumnList VARCHAR2(10000) := ''', r); r:=r+1;
445: build_select_clause_list(r,'src_');
446: ad_ddl.build_statement(' ''; ', r); r:=r+1;
447: ad_ddl.build_statement(' ', r); r:=r+1;
448: ad_ddl.build_statement(' g_rp_tgtColumnList VARCHAR2(10000) := ''', r); r:=r+1;
449: build_select_clause_list(r,'tgt_');
450: ad_ddl.build_statement(' ''; ', r); r:=r+1;
451: ad_ddl.build_statement(' ', r); r:=r+1;

Line 448: ad_ddl.build_statement(' g_rp_tgtColumnList VARCHAR2(10000) := ''', r); r:=r+1;

444: ad_ddl.build_statement(' g_rp_srcColumnList VARCHAR2(10000) := ''', r); r:=r+1;
445: build_select_clause_list(r,'src_');
446: ad_ddl.build_statement(' ''; ', r); r:=r+1;
447: ad_ddl.build_statement(' ', r); r:=r+1;
448: ad_ddl.build_statement(' g_rp_tgtColumnList VARCHAR2(10000) := ''', r); r:=r+1;
449: build_select_clause_list(r,'tgt_');
450: ad_ddl.build_statement(' ''; ', r); r:=r+1;
451: ad_ddl.build_statement(' ', r); r:=r+1;
452: ad_ddl.build_statement(' g_rp_offColumnList VARCHAR2(10000) := ''', r); r:=r+1;

Line 450: ad_ddl.build_statement(' ''; ', r); r:=r+1;

446: ad_ddl.build_statement(' ''; ', r); r:=r+1;
447: ad_ddl.build_statement(' ', r); r:=r+1;
448: ad_ddl.build_statement(' g_rp_tgtColumnList VARCHAR2(10000) := ''', r); r:=r+1;
449: build_select_clause_list(r,'tgt_');
450: ad_ddl.build_statement(' ''; ', r); r:=r+1;
451: ad_ddl.build_statement(' ', r); r:=r+1;
452: ad_ddl.build_statement(' g_rp_offColumnList VARCHAR2(10000) := ''', r); r:=r+1;
453: build_select_clause_list(r, 'off_');
454: ad_ddl.build_statement(' ) ''; ', r); r:=r+1;

Line 451: ad_ddl.build_statement(' ', r); r:=r+1;

447: ad_ddl.build_statement(' ', r); r:=r+1;
448: ad_ddl.build_statement(' g_rp_tgtColumnList VARCHAR2(10000) := ''', r); r:=r+1;
449: build_select_clause_list(r,'tgt_');
450: ad_ddl.build_statement(' ''; ', r); r:=r+1;
451: ad_ddl.build_statement(' ', r); r:=r+1;
452: ad_ddl.build_statement(' g_rp_offColumnList VARCHAR2(10000) := ''', r); r:=r+1;
453: build_select_clause_list(r, 'off_');
454: ad_ddl.build_statement(' ) ''; ', r); r:=r+1;
455: ad_ddl.build_statement(' ', r); r:=r+1;

Line 452: ad_ddl.build_statement(' g_rp_offColumnList VARCHAR2(10000) := ''', r); r:=r+1;

448: ad_ddl.build_statement(' g_rp_tgtColumnList VARCHAR2(10000) := ''', r); r:=r+1;
449: build_select_clause_list(r,'tgt_');
450: ad_ddl.build_statement(' ''; ', r); r:=r+1;
451: ad_ddl.build_statement(' ', r); r:=r+1;
452: ad_ddl.build_statement(' g_rp_offColumnList VARCHAR2(10000) := ''', r); r:=r+1;
453: build_select_clause_list(r, 'off_');
454: ad_ddl.build_statement(' ) ''; ', r); r:=r+1;
455: ad_ddl.build_statement(' ', r); r:=r+1;
456: ad_ddl.build_statement(' g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;

Line 454: ad_ddl.build_statement(' ) ''; ', r); r:=r+1;

450: ad_ddl.build_statement(' ''; ', r); r:=r+1;
451: ad_ddl.build_statement(' ', r); r:=r+1;
452: ad_ddl.build_statement(' g_rp_offColumnList VARCHAR2(10000) := ''', r); r:=r+1;
453: build_select_clause_list(r, 'off_');
454: ad_ddl.build_statement(' ) ''; ', r); r:=r+1;
455: ad_ddl.build_statement(' ', r); r:=r+1;
456: ad_ddl.build_statement(' g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;
457: ad_ddl.build_statement(' ''INSERT INTO gcs_entries_gt( ', r); r:=r+1;
458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;

Line 455: ad_ddl.build_statement(' ', r); r:=r+1;

451: ad_ddl.build_statement(' ', r); r:=r+1;
452: ad_ddl.build_statement(' g_rp_offColumnList VARCHAR2(10000) := ''', r); r:=r+1;
453: build_select_clause_list(r, 'off_');
454: ad_ddl.build_statement(' ) ''; ', r); r:=r+1;
455: ad_ddl.build_statement(' ', r); r:=r+1;
456: ad_ddl.build_statement(' g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;
457: ad_ddl.build_statement(' ''INSERT INTO gcs_entries_gt( ', r); r:=r+1;
458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;
459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;

Line 456: ad_ddl.build_statement(' g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;

452: ad_ddl.build_statement(' g_rp_offColumnList VARCHAR2(10000) := ''', r); r:=r+1;
453: build_select_clause_list(r, 'off_');
454: ad_ddl.build_statement(' ) ''; ', r); r:=r+1;
455: ad_ddl.build_statement(' ', r); r:=r+1;
456: ad_ddl.build_statement(' g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;
457: ad_ddl.build_statement(' ''INSERT INTO gcs_entries_gt( ', r); r:=r+1;
458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;
459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;
460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;

Line 457: ad_ddl.build_statement(' ''INSERT INTO gcs_entries_gt( ', r); r:=r+1;

453: build_select_clause_list(r, 'off_');
454: ad_ddl.build_statement(' ) ''; ', r); r:=r+1;
455: ad_ddl.build_statement(' ', r); r:=r+1;
456: ad_ddl.build_statement(' g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;
457: ad_ddl.build_statement(' ''INSERT INTO gcs_entries_gt( ', r); r:=r+1;
458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;
459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;
460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;
461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;

Line 458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;

454: ad_ddl.build_statement(' ) ''; ', r); r:=r+1;
455: ad_ddl.build_statement(' ', r); r:=r+1;
456: ad_ddl.build_statement(' g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;
457: ad_ddl.build_statement(' ''INSERT INTO gcs_entries_gt( ', r); r:=r+1;
458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;
459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;
460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;
461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;
462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;

Line 459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;

455: ad_ddl.build_statement(' ', r); r:=r+1;
456: ad_ddl.build_statement(' g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;
457: ad_ddl.build_statement(' ''INSERT INTO gcs_entries_gt( ', r); r:=r+1;
458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;
459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;
460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;
461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;
462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;
463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;

Line 460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;

456: ad_ddl.build_statement(' g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;
457: ad_ddl.build_statement(' ''INSERT INTO gcs_entries_gt( ', r); r:=r+1;
458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;
459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;
460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;
461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;
462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;
463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;
464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;

Line 461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;

457: ad_ddl.build_statement(' ''INSERT INTO gcs_entries_gt( ', r); r:=r+1;
458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;
459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;
460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;
461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;
462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;
463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;
464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;
465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;

Line 462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;

458: ad_ddl.build_statement(' rule_id , ', r); r:=r+1;
459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;
460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;
461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;
462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;
463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;
464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;
465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;
466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;

Line 463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;

459: ad_ddl.build_statement(' step_seq , ', r); r:=r+1;
460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;
461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;
462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;
463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;
464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;
465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;
466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;
467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;

Line 464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;

460: ad_ddl.build_statement(' step_name , ', r); r:=r+1;
461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;
462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;
463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;
464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;
465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;
466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;
467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;
468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;

Line 465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;

461: ad_ddl.build_statement(' formula_text , ', r); r:=r+1;
462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;
463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;
464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;
465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;
466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;
467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;
468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;
469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;

Line 466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;

462: ad_ddl.build_statement(' rule_step_id , ', r); r:=r+1;
463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;
464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;
465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;
466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;
467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;
468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;
469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;
470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;

Line 467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;

463: ad_ddl.build_statement(' offset_flag , ', r); r:=r+1;
464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;
465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;
466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;
467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;
468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;
469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;
470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;
471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;

Line 468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;

464: ad_ddl.build_statement(' sql_statement_num , ', r); r:=r+1;
465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;
466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;
467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;
468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;
469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;
470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;
471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;
472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;

Line 469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;

465: ad_ddl.build_statement(' currency_code , ', r); r:=r+1;
466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;
467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;
468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;
469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;
470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;
471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;
472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;
473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;

Line 470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;

466: ad_ddl.build_statement(' ad_input_amount , ', r); r:=r+1;
467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;
468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;
469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;
470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;
471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;
472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;
473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;
474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;

Line 471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;

467: ad_ddl.build_statement(' pe_input_amount , ', r); r:=r+1;
468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;
469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;
470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;
471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;
472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;
473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;
474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;
475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;

Line 472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;

468: ad_ddl.build_statement(' ce_input_amount , ', r); r:=r+1;
469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;
470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;
471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;
472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;
473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;
474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;
475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;
476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;

Line 473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;

469: ad_ddl.build_statement(' ee_input_amount , ', r); r:=r+1;
470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;
471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;
472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;
473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;
474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;
475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;
476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;
477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;

Line 474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;

470: ad_ddl.build_statement(' output_amount , ', r); r:=r+1;
471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;
472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;
473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;
474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;
475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;
476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;
477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;
478: ad_ddl.build_statement(' ', r); r:=r+1;

Line 475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;

471: ad_ddl.build_statement(' entity_id , ', r); r:=r+1;
472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;
473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;
474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;
475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;
476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;
477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;
478: ad_ddl.build_statement(' ', r); r:=r+1;
479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;

Line 476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;

472: ad_ddl.build_statement(' ytd_credit_balance_e , ', r); r:=r+1;
473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;
474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;
475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;
476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;
477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;
478: ad_ddl.build_statement(' ', r); r:=r+1;
479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;
480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;

Line 477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;

473: ad_ddl.build_statement(' ytd_debit_balance_e , ', r); r:=r+1;
474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;
475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;
476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;
477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;
478: ad_ddl.build_statement(' ', r); r:=r+1;
479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;
480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;
481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;

Line 478: ad_ddl.build_statement(' ', r); r:=r+1;

474: ad_ddl.build_statement(' src_company_cost_center_org_id , ', r); r:=r+1;
475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;
476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;
477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;
478: ad_ddl.build_statement(' ', r); r:=r+1;
479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;
480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;
481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;
482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;

Line 479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;

475: ad_ddl.build_statement(' src_intercompany_id , ', r); r:=r+1;
476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;
477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;
478: ad_ddl.build_statement(' ', r); r:=r+1;
479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;
480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;
481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;
482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;
483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;

Line 480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;

476: ad_ddl.build_statement(' tgt_company_cost_center_org_id , ', r); r:=r+1;
477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;
478: ad_ddl.build_statement(' ', r); r:=r+1;
479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;
480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;
481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;
482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;
483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;
484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;

Line 481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;

477: ad_ddl.build_statement(' tgt_intercompany_id ''; ', r); r:=r+1;
478: ad_ddl.build_statement(' ', r); r:=r+1;
479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;
480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;
481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;
482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;
483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;
484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;
485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;

Line 482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;

478: ad_ddl.build_statement(' ', r); r:=r+1;
479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;
480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;
481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;
482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;
483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;
484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;
485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;
486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;

Line 483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;

479: ad_ddl.build_statement(' g_core_sel_stmt VARCHAR2(2000) := ', r); r:=r+1;
480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;
481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;
482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;
483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;
484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;
485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;
486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;
487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;

Line 484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;

480: ad_ddl.build_statement(' ''SELECT :rid , ', r); r:=r+1;
481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;
482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;
483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;
484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;
485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;
486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;
487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;
488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

Line 485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;

481: ad_ddl.build_statement(' :seq , ', r); r:=r+1;
482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;
483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;
484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;
485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;
486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;
487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;
488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;

Line 486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;

482: ad_ddl.build_statement(' :sna , ', r); r:=r+1;
483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;
484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;
485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;
486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;
487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;
488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;

Line 487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;

483: ad_ddl.build_statement(' :ftx , ', r); r:=r+1;
484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;
485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;
486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;
487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;
488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;
491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;

Line 488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

484: ad_ddl.build_statement(' :rsi , ', r); r:=r+1;
485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;
486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;
487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;
488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;
491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;

Line 489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;

485: ad_ddl.build_statement(' :osf , ', r); r:=r+1;
486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;
487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;
488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;
491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;

Line 490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;

486: ad_ddl.build_statement(' :stn , ', r); r:=r+1;
487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;
488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;
491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;
494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;

Line 491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;

487: ad_ddl.build_statement(' :ccy , ', r); r:=r+1;
488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;
491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;
494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;

Line 492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;

488: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;
491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;
494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;

Line 493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;

489: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;
491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;
494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;
497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;

Line 494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;

490: ad_ddl.build_statement(' DECODE(b.entity_id, :pid, ', r); r:=r+1;
491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;
494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;
497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

Line 495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;

491: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;
494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;
497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

Line 496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;

492: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;
494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;
497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

Line 497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;

493: ad_ddl.build_statement(' DECODE(b.entity_id, :cid, ', r); r:=r+1;
494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;
497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

Line 498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

494: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;
497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;

Line 499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

495: ad_ddl.build_statement(' SUM( ', r); r:=r+1;
496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;
497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;
503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;

Line 500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

496: ad_ddl.build_statement(' DECODE(b.entity_id, :eid, ', r); r:=r+1;
497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;
503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;
504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;

Line 501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;

497: ad_ddl.build_statement(' b.ytd_balance_e, 0)) , ', r); r:=r+1;
498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;
503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;
504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;
505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;

Line 502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;

498: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;
503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;
504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;
505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;
506: ad_ddl.build_statement(' ', r); r:=r+1;

Line 503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;

499: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;
503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;
504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;
505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;
506: ad_ddl.build_statement(' ', r); r:=r+1;
507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;

Line 504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;

500: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;
503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;
504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;
505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;
506: ad_ddl.build_statement(' ', r); r:=r+1;
507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;

Line 505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;

501: ad_ddl.build_statement(' 0 , ', r); r:=r+1;
502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;
503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;
504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;
505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;
506: ad_ddl.build_statement(' ', r); r:=r+1;
507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;
509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;

Line 506: ad_ddl.build_statement(' ', r); r:=r+1;

502: ad_ddl.build_statement(' b.company_cost_center_org_id , ', r); r:=r+1;
503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;
504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;
505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;
506: ad_ddl.build_statement(' ', r); r:=r+1;
507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;
509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;
510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;

Line 507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;

503: ad_ddl.build_statement(' b.intercompany_id , ', r); r:=r+1;
504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;
505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;
506: ad_ddl.build_statement(' ', r); r:=r+1;
507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;
509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;
510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;
511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;

Line 508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;

504: ad_ddl.build_statement(' :tgt_cctr_org_id , ', r); r:=r+1;
505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;
506: ad_ddl.build_statement(' ', r); r:=r+1;
507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;
509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;
510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;
511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;
512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;

Line 509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;

505: ad_ddl.build_statement(' :tgt_intercompany_id '';', r); r:=r+1;
506: ad_ddl.build_statement(' ', r); r:=r+1;
507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;
509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;
510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;
511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;
512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;
513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;

Line 510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;

506: ad_ddl.build_statement(' ', r); r:=r+1;
507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;
509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;
510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;
511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;
512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;
513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;
514: ad_ddl.build_statement(' AND b.currency_code = :ccy ''; ', r); r:=r+1;

Line 511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;

507: ad_ddl.build_statement(' g_core_frm_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;
509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;
510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;
511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;
512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;
513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;
514: ad_ddl.build_statement(' AND b.currency_code = :ccy ''; ', r); r:=r+1;
515: ad_ddl.build_statement(' ', r); r:=r+1;

Line 512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;

508: ad_ddl.build_statement(' FROM fem_balances b '';', r); r:=r+1;
509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;
510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;
511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;
512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;
513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;
514: ad_ddl.build_statement(' AND b.currency_code = :ccy ''; ', r); r:=r+1;
515: ad_ddl.build_statement(' ', r); r:=r+1;
516: ad_ddl.build_statement(' g_core_grp_stmt VARCHAR2(2000) := '' ', r); r:=r+1;

Line 513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;

509: ad_ddl.build_statement(' g_core_whr_stmt VARCHAR2(2000) := ''', r); r:=r+1;
510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;
511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;
512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;
513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;
514: ad_ddl.build_statement(' AND b.currency_code = :ccy ''; ', r); r:=r+1;
515: ad_ddl.build_statement(' ', r); r:=r+1;
516: ad_ddl.build_statement(' g_core_grp_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
517: ad_ddl.build_statement(' group by b.company_cost_center_org_id ', r); r:=r+1;

Line 514: ad_ddl.build_statement(' AND b.currency_code = :ccy ''; ', r); r:=r+1;

510: ad_ddl.build_statement(' WHERE b.dataset_code = :dci ', r); r:=r+1;
511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;
512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;
513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;
514: ad_ddl.build_statement(' AND b.currency_code = :ccy ''; ', r); r:=r+1;
515: ad_ddl.build_statement(' ', r); r:=r+1;
516: ad_ddl.build_statement(' g_core_grp_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
517: ad_ddl.build_statement(' group by b.company_cost_center_org_id ', r); r:=r+1;
518: build_group_by_clause(r,'b', 'variableassignment');

Line 515: ad_ddl.build_statement(' ', r); r:=r+1;

511: ad_ddl.build_statement(' AND b.cal_period_id = :cpi ', r); r:=r+1;
512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;
513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;
514: ad_ddl.build_statement(' AND b.currency_code = :ccy ''; ', r); r:=r+1;
515: ad_ddl.build_statement(' ', r); r:=r+1;
516: ad_ddl.build_statement(' g_core_grp_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
517: ad_ddl.build_statement(' group by b.company_cost_center_org_id ', r); r:=r+1;
518: build_group_by_clause(r,'b', 'variableassignment');
519: ad_ddl.build_statement(' ,b.intercompany_id''; ', r); r:=r+1;

Line 516: ad_ddl.build_statement(' g_core_grp_stmt VARCHAR2(2000) := '' ', r); r:=r+1;

512: ad_ddl.build_statement(' AND b.source_system_code = 70 ', r); r:=r+1;
513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;
514: ad_ddl.build_statement(' AND b.currency_code = :ccy ''; ', r); r:=r+1;
515: ad_ddl.build_statement(' ', r); r:=r+1;
516: ad_ddl.build_statement(' g_core_grp_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
517: ad_ddl.build_statement(' group by b.company_cost_center_org_id ', r); r:=r+1;
518: build_group_by_clause(r,'b', 'variableassignment');
519: ad_ddl.build_statement(' ,b.intercompany_id''; ', r); r:=r+1;
520: ad_ddl.build_statement(' ', r); r:=r+1;

Line 517: ad_ddl.build_statement(' group by b.company_cost_center_org_id ', r); r:=r+1;

513: ad_ddl.build_statement(' AND b.ledger_id = :ledger ', r); r:=r+1;
514: ad_ddl.build_statement(' AND b.currency_code = :ccy ''; ', r); r:=r+1;
515: ad_ddl.build_statement(' ', r); r:=r+1;
516: ad_ddl.build_statement(' g_core_grp_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
517: ad_ddl.build_statement(' group by b.company_cost_center_org_id ', r); r:=r+1;
518: build_group_by_clause(r,'b', 'variableassignment');
519: ad_ddl.build_statement(' ,b.intercompany_id''; ', r); r:=r+1;
520: ad_ddl.build_statement(' ', r); r:=r+1;
521: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;

Line 519: ad_ddl.build_statement(' ,b.intercompany_id''; ', r); r:=r+1;

515: ad_ddl.build_statement(' ', r); r:=r+1;
516: ad_ddl.build_statement(' g_core_grp_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
517: ad_ddl.build_statement(' group by b.company_cost_center_org_id ', r); r:=r+1;
518: build_group_by_clause(r,'b', 'variableassignment');
519: ad_ddl.build_statement(' ,b.intercompany_id''; ', r); r:=r+1;
520: ad_ddl.build_statement(' ', r); r:=r+1;
521: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
522: ad_ddl.build_statement(' ', r); r:=r+1;
523: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 520: ad_ddl.build_statement(' ', r); r:=r+1;

516: ad_ddl.build_statement(' g_core_grp_stmt VARCHAR2(2000) := '' ', r); r:=r+1;
517: ad_ddl.build_statement(' group by b.company_cost_center_org_id ', r); r:=r+1;
518: build_group_by_clause(r,'b', 'variableassignment');
519: ad_ddl.build_statement(' ,b.intercompany_id''; ', r); r:=r+1;
520: ad_ddl.build_statement(' ', r); r:=r+1;
521: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
522: ad_ddl.build_statement(' ', r); r:=r+1;
523: ad_ddl.build_statement(' -- ', r); r:=r+1;
524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;

Line 521: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;

517: ad_ddl.build_statement(' group by b.company_cost_center_org_id ', r); r:=r+1;
518: build_group_by_clause(r,'b', 'variableassignment');
519: ad_ddl.build_statement(' ,b.intercompany_id''; ', r); r:=r+1;
520: ad_ddl.build_statement(' ', r); r:=r+1;
521: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
522: ad_ddl.build_statement(' ', r); r:=r+1;
523: ad_ddl.build_statement(' -- ', r); r:=r+1;
524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;

Line 522: ad_ddl.build_statement(' ', r); r:=r+1;

518: build_group_by_clause(r,'b', 'variableassignment');
519: ad_ddl.build_statement(' ,b.intercompany_id''; ', r); r:=r+1;
520: ad_ddl.build_statement(' ', r); r:=r+1;
521: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
522: ad_ddl.build_statement(' ', r); r:=r+1;
523: ad_ddl.build_statement(' -- ', r); r:=r+1;
524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;

Line 523: ad_ddl.build_statement(' -- ', r); r:=r+1;

519: ad_ddl.build_statement(' ,b.intercompany_id''; ', r); r:=r+1;
520: ad_ddl.build_statement(' ', r); r:=r+1;
521: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
522: ad_ddl.build_statement(' ', r); r:=r+1;
523: ad_ddl.build_statement(' -- ', r); r:=r+1;
524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;

Line 524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;

520: ad_ddl.build_statement(' ', r); r:=r+1;
521: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
522: ad_ddl.build_statement(' ', r); r:=r+1;
523: ad_ddl.build_statement(' -- ', r); r:=r+1;
524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
528: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;

521: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
522: ad_ddl.build_statement(' ', r); r:=r+1;
523: ad_ddl.build_statement(' -- ', r); r:=r+1;
524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
528: ad_ddl.build_statement(' -- ', r); r:=r+1;
529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;

Line 526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;

522: ad_ddl.build_statement(' ', r); r:=r+1;
523: ad_ddl.build_statement(' -- ', r); r:=r+1;
524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
528: ad_ddl.build_statement(' -- ', r); r:=r+1;
529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;

Line 527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;

523: ad_ddl.build_statement(' -- ', r); r:=r+1;
524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
528: ad_ddl.build_statement(' -- ', r); r:=r+1;
529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;

Line 528: ad_ddl.build_statement(' -- ', r); r:=r+1;

524: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
528: ad_ddl.build_statement(' -- ', r); r:=r+1;
529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
532: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;

525: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
528: ad_ddl.build_statement(' -- ', r); r:=r+1;
529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
532: ad_ddl.build_statement(' -- ', r); r:=r+1;
533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;

Line 530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;

526: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
528: ad_ddl.build_statement(' -- ', r); r:=r+1;
529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
532: ad_ddl.build_statement(' -- ', r); r:=r+1;
533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;

Line 531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;

527: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
528: ad_ddl.build_statement(' -- ', r); r:=r+1;
529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
532: ad_ddl.build_statement(' -- ', r); r:=r+1;
533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;

Line 532: ad_ddl.build_statement(' -- ', r); r:=r+1;

528: ad_ddl.build_statement(' -- ', r); r:=r+1;
529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
532: ad_ddl.build_statement(' -- ', r); r:=r+1;
533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
536: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;

529: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
532: ad_ddl.build_statement(' -- ', r); r:=r+1;
533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
536: ad_ddl.build_statement(' -- ', r); r:=r+1;
537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;

Line 534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;

530: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
532: ad_ddl.build_statement(' -- ', r); r:=r+1;
533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
536: ad_ddl.build_statement(' -- ', r); r:=r+1;
537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;

Line 535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;

531: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
532: ad_ddl.build_statement(' -- ', r); r:=r+1;
533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
536: ad_ddl.build_statement(' -- ', r); r:=r+1;
537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;
539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;

Line 536: ad_ddl.build_statement(' -- ', r); r:=r+1;

532: ad_ddl.build_statement(' -- ', r); r:=r+1;
533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
536: ad_ddl.build_statement(' -- ', r); r:=r+1;
537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;
539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;

Line 537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;

533: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
536: ad_ddl.build_statement(' -- ', r); r:=r+1;
537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;
539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;
541: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;

534: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
536: ad_ddl.build_statement(' -- ', r); r:=r+1;
537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;
539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;
541: ad_ddl.build_statement(' -- ', r); r:=r+1;
542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;

Line 539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;

535: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
536: ad_ddl.build_statement(' -- ', r); r:=r+1;
537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;
539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;
541: ad_ddl.build_statement(' -- ', r); r:=r+1;
542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;

Line 540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;

536: ad_ddl.build_statement(' -- ', r); r:=r+1;
537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;
539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;
541: ad_ddl.build_statement(' -- ', r); r:=r+1;
542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;
544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;

Line 541: ad_ddl.build_statement(' -- ', r); r:=r+1;

537: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;
539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;
541: ad_ddl.build_statement(' -- ', r); r:=r+1;
542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;
544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;
545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;

Line 542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;

538: ad_ddl.build_statement(' -- create_off_gt_lines ', r); r:=r+1;
539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;
541: ad_ddl.build_statement(' -- ', r); r:=r+1;
542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;
544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;
545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;
546: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;

539: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;
541: ad_ddl.build_statement(' -- ', r); r:=r+1;
542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;
544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;
545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;
546: ad_ddl.build_statement(' -- ', r); r:=r+1;
547: ad_ddl.build_statement(' --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER, ', r); r:=r+1;

Line 544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;

540: ad_ddl.build_statement(' -- creates offset lines in gcs_entries_gt for performance ', r); r:=r+1;
541: ad_ddl.build_statement(' -- ', r); r:=r+1;
542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;
544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;
545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;
546: ad_ddl.build_statement(' -- ', r); r:=r+1;
547: ad_ddl.build_statement(' --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER, ', r); r:=r+1;
548: ad_ddl.build_statement(' -- p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;

Line 545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;

541: ad_ddl.build_statement(' -- ', r); r:=r+1;
542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;
544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;
545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;
546: ad_ddl.build_statement(' -- ', r); r:=r+1;
547: ad_ddl.build_statement(' --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER, ', r); r:=r+1;
548: ad_ddl.build_statement(' -- p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
549: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 546: ad_ddl.build_statement(' -- ', r); r:=r+1;

542: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;
544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;
545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;
546: ad_ddl.build_statement(' -- ', r); r:=r+1;
547: ad_ddl.build_statement(' --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER, ', r); r:=r+1;
548: ad_ddl.build_statement(' -- p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
549: ad_ddl.build_statement(' -- ', r); r:=r+1;
550:

Line 547: ad_ddl.build_statement(' --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER, ', r); r:=r+1;

543: ad_ddl.build_statement(' -- p_rule_id: rule identifier ', r); r:=r+1;
544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;
545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;
546: ad_ddl.build_statement(' -- ', r); r:=r+1;
547: ad_ddl.build_statement(' --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER, ', r); r:=r+1;
548: ad_ddl.build_statement(' -- p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
549: ad_ddl.build_statement(' -- ', r); r:=r+1;
550:
551: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);

Line 548: ad_ddl.build_statement(' -- p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;

544: ad_ddl.build_statement(' -- p_step_seq: step seq identifier ', r); r:=r+1;
545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;
546: ad_ddl.build_statement(' -- ', r); r:=r+1;
547: ad_ddl.build_statement(' --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER, ', r); r:=r+1;
548: ad_ddl.build_statement(' -- p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
549: ad_ddl.build_statement(' -- ', r); r:=r+1;
550:
551: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);
552: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

Line 549: ad_ddl.build_statement(' -- ', r); r:=r+1;

545: ad_ddl.build_statement(' -- p_offset_members: offset member object ', r); r:=r+1;
546: ad_ddl.build_statement(' -- ', r); r:=r+1;
547: ad_ddl.build_statement(' --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER, ', r); r:=r+1;
548: ad_ddl.build_statement(' -- p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
549: ad_ddl.build_statement(' -- ', r); r:=r+1;
550:
551: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);
552: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
553: 'GCS', 'GCS_RP_UTILITY_PKG',

Line 551: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);

547: ad_ddl.build_statement(' --PROCEDURE create_off_gt_lines(p_entry_id IN NUMBER, ', r); r:=r+1;
548: ad_ddl.build_statement(' -- p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
549: ad_ddl.build_statement(' -- ', r); r:=r+1;
550:
551: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);
552: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
553: 'GCS', 'GCS_RP_UTILITY_PKG',
554: 1, r , 'TRUE', comp_err);
555:

Line 552: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

548: ad_ddl.build_statement(' -- p_row_count IN OUT NOCOPY NUMBER); ', r); r:=r+1;
549: ad_ddl.build_statement(' -- ', r); r:=r+1;
550:
551: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);
552: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
553: 'GCS', 'GCS_RP_UTILITY_PKG',
554: 1, r , 'TRUE', comp_err);
555:
556: -- Create Package Body for GCS_RP_UTILITY_PKG

Line 558: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE BODY GCS_RP_UTILITY_PKG AS ', r); r := r+1;

554: 1, r , 'TRUE', comp_err);
555:
556: -- Create Package Body for GCS_RP_UTILITY_PKG
557: r := 1;
558: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE BODY GCS_RP_UTILITY_PKG AS ', r); r := r+1;
559: ad_ddl.build_statement(' ', r); r := r+1;
560: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
561: ad_ddl.build_statement(' ', r); r:=r+1;
562: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 559: ad_ddl.build_statement(' ', r); r := r+1;

555:
556: -- Create Package Body for GCS_RP_UTILITY_PKG
557: r := 1;
558: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE BODY GCS_RP_UTILITY_PKG AS ', r); r := r+1;
559: ad_ddl.build_statement(' ', r); r := r+1;
560: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
561: ad_ddl.build_statement(' ', r); r:=r+1;
562: ad_ddl.build_statement(' -- ', r); r:=r+1;
563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;

Line 560: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;

556: -- Create Package Body for GCS_RP_UTILITY_PKG
557: r := 1;
558: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE BODY GCS_RP_UTILITY_PKG AS ', r); r := r+1;
559: ad_ddl.build_statement(' ', r); r := r+1;
560: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
561: ad_ddl.build_statement(' ', r); r:=r+1;
562: ad_ddl.build_statement(' -- ', r); r:=r+1;
563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;

Line 561: ad_ddl.build_statement(' ', r); r:=r+1;

557: r := 1;
558: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE BODY GCS_RP_UTILITY_PKG AS ', r); r := r+1;
559: ad_ddl.build_statement(' ', r); r := r+1;
560: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
561: ad_ddl.build_statement(' ', r); r:=r+1;
562: ad_ddl.build_statement(' -- ', r); r:=r+1;
563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;

Line 562: ad_ddl.build_statement(' -- ', r); r:=r+1;

558: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE BODY GCS_RP_UTILITY_PKG AS ', r); r := r+1;
559: ad_ddl.build_statement(' ', r); r := r+1;
560: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
561: ad_ddl.build_statement(' ', r); r:=r+1;
562: ad_ddl.build_statement(' -- ', r); r:=r+1;
563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;

Line 563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;

559: ad_ddl.build_statement(' ', r); r := r+1;
560: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
561: ad_ddl.build_statement(' ', r); r:=r+1;
562: ad_ddl.build_statement(' -- ', r); r:=r+1;
563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
567: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;

560: ad_ddl.build_statement(' --Public Procedure and Function Definitions ', r); r:=r+1;
561: ad_ddl.build_statement(' ', r); r:=r+1;
562: ad_ddl.build_statement(' -- ', r); r:=r+1;
563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
567: ad_ddl.build_statement(' -- ', r); r:=r+1;
568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;

Line 565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;

561: ad_ddl.build_statement(' ', r); r:=r+1;
562: ad_ddl.build_statement(' -- ', r); r:=r+1;
563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
567: ad_ddl.build_statement(' -- ', r); r:=r+1;
568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;

Line 566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;

562: ad_ddl.build_statement(' -- ', r); r:=r+1;
563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
567: ad_ddl.build_statement(' -- ', r); r:=r+1;
568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;

Line 567: ad_ddl.build_statement(' -- ', r); r:=r+1;

563: ad_ddl.build_statement(' -- Procedure ', r); r:=r+1;
564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
567: ad_ddl.build_statement(' -- ', r); r:=r+1;
568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
571: ad_ddl.build_statement(' -- ', r); r:=r+1;

Line 568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;

564: ad_ddl.build_statement(' -- create_entry_lines ', r); r:=r+1;
565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
567: ad_ddl.build_statement(' -- ', r); r:=r+1;
568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
571: ad_ddl.build_statement(' -- ', r); r:=r+1;
572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;

Line 569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;

565: ad_ddl.build_statement(' -- Purpose ', r); r:=r+1;
566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
567: ad_ddl.build_statement(' -- ', r); r:=r+1;
568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
571: ad_ddl.build_statement(' -- ', r); r:=r+1;
572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;

Line 570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;

566: ad_ddl.build_statement(' -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt ', r); r:=r+1;
567: ad_ddl.build_statement(' -- ', r); r:=r+1;
568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
571: ad_ddl.build_statement(' -- ', r); r:=r+1;
572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;

Line 571: ad_ddl.build_statement(' -- ', r); r:=r+1;

567: ad_ddl.build_statement(' -- ', r); r:=r+1;
568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
571: ad_ddl.build_statement(' -- ', r); r:=r+1;
572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;
575: ad_ddl.build_statement(' IS ', r); r:=r+1;

Line 572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;

568: ad_ddl.build_statement(' -- Arguments ', r); r:=r+1;
569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
571: ad_ddl.build_statement(' -- ', r); r:=r+1;
572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;
575: ad_ddl.build_statement(' IS ', r); r:=r+1;
576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;

Line 573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;

569: ad_ddl.build_statement(' -- p_entry_id: entry identifier ', r); r:=r+1;
570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
571: ad_ddl.build_statement(' -- ', r); r:=r+1;
572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;
575: ad_ddl.build_statement(' IS ', r); r:=r+1;
576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;
577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;

Line 574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;

570: ad_ddl.build_statement(' -- p_row_count: #of rows inserted ', r); r:=r+1;
571: ad_ddl.build_statement(' -- ', r); r:=r+1;
572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;
575: ad_ddl.build_statement(' IS ', r); r:=r+1;
576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;
577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
578: ad_ddl.build_statement(' ', r); r:=r+1;

Line 575: ad_ddl.build_statement(' IS ', r); r:=r+1;

571: ad_ddl.build_statement(' -- ', r); r:=r+1;
572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;
575: ad_ddl.build_statement(' IS ', r); r:=r+1;
576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;
577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
578: ad_ddl.build_statement(' ', r); r:=r+1;
579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;

Line 576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;

572: ad_ddl.build_statement(' PROCEDURE create_entry_lines (p_entry_id IN NUMBER, ', r); r:=r+1;
573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;
575: ad_ddl.build_statement(' IS ', r); r:=r+1;
576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;
577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
578: ad_ddl.build_statement(' ', r); r:=r+1;
579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;

Line 577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;

573: ad_ddl.build_statement(' p_offset_flag IN VARCHAR2, ', r); r:=r+1;
574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;
575: ad_ddl.build_statement(' IS ', r); r:=r+1;
576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;
577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
578: ad_ddl.build_statement(' ', r); r:=r+1;
579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;
581: ad_ddl.build_statement(' end if; ', r); r:=r+1;

Line 578: ad_ddl.build_statement(' ', r); r:=r+1;

574: ad_ddl.build_statement(' p_row_count IN OUT NOCOPY NUMBER) ', r); r:=r+1;
575: ad_ddl.build_statement(' IS ', r); r:=r+1;
576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;
577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
578: ad_ddl.build_statement(' ', r); r:=r+1;
579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;
581: ad_ddl.build_statement(' end if; ', r); r:=r+1;
582: ad_ddl.build_statement(' ', r); r:=r+1;

Line 579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;

575: ad_ddl.build_statement(' IS ', r); r:=r+1;
576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;
577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
578: ad_ddl.build_statement(' ', r); r:=r+1;
579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;
581: ad_ddl.build_statement(' end if; ', r); r:=r+1;
582: ad_ddl.build_statement(' ', r); r:=r+1;
583: ad_ddl.build_statement(' begin ', r); r:=r+1;

Line 580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;

576: ad_ddl.build_statement(' l_elimtb_y_n VARCHAR2(1) := ''Y''; ', r); r:=r+1;
577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
578: ad_ddl.build_statement(' ', r); r:=r+1;
579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;
581: ad_ddl.build_statement(' end if; ', r); r:=r+1;
582: ad_ddl.build_statement(' ', r); r:=r+1;
583: ad_ddl.build_statement(' begin ', r); r:=r+1;
584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;

Line 581: ad_ddl.build_statement(' end if; ', r); r:=r+1;

577: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
578: ad_ddl.build_statement(' ', r); r:=r+1;
579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;
581: ad_ddl.build_statement(' end if; ', r); r:=r+1;
582: ad_ddl.build_statement(' ', r); r:=r+1;
583: ad_ddl.build_statement(' begin ', r); r:=r+1;
584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;
585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;

Line 582: ad_ddl.build_statement(' ', r); r:=r+1;

578: ad_ddl.build_statement(' ', r); r:=r+1;
579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;
581: ad_ddl.build_statement(' end if; ', r); r:=r+1;
582: ad_ddl.build_statement(' ', r); r:=r+1;
583: ad_ddl.build_statement(' begin ', r); r:=r+1;
584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;
585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;
586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;

Line 583: ad_ddl.build_statement(' begin ', r); r:=r+1;

579: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;
581: ad_ddl.build_statement(' end if; ', r); r:=r+1;
582: ad_ddl.build_statement(' ', r); r:=r+1;
583: ad_ddl.build_statement(' begin ', r); r:=r+1;
584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;
585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;
586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;
587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;

Line 584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;

580: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.begin'', null); ', r); r:=r+1;
581: ad_ddl.build_statement(' end if; ', r); r:=r+1;
582: ad_ddl.build_statement(' ', r); r:=r+1;
583: ad_ddl.build_statement(' begin ', r); r:=r+1;
584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;
585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;
586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;
587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;
588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;

Line 585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;

581: ad_ddl.build_statement(' end if; ', r); r:=r+1;
582: ad_ddl.build_statement(' ', r); r:=r+1;
583: ad_ddl.build_statement(' begin ', r); r:=r+1;
584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;
585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;
586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;
587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;
588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;
589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;

Line 586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;

582: ad_ddl.build_statement(' ', r); r:=r+1;
583: ad_ddl.build_statement(' begin ', r); r:=r+1;
584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;
585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;
586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;
587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;
588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;
589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;
590: ad_ddl.build_statement(' end; ', r); r:=r+1;

Line 587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;

583: ad_ddl.build_statement(' begin ', r); r:=r+1;
584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;
585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;
586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;
587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;
588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;
589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;
590: ad_ddl.build_statement(' end; ', r); r:=r+1;
591: ad_ddl.build_statement(' ', r); r:=r+1;

Line 588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;

584: ad_ddl.build_statement(' select ''N'' ', r); r:=r+1;
585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;
586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;
587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;
588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;
589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;
590: ad_ddl.build_statement(' end; ', r); r:=r+1;
591: ad_ddl.build_statement(' ', r); r:=r+1;
592: ad_ddl.build_statement(' if (l_elimtb_y_n = ''N'') then ', r); r:=r+1;

Line 589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;

585: ad_ddl.build_statement(' into l_elimtb_y_n ', r); r:=r+1;
586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;
587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;
588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;
589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;
590: ad_ddl.build_statement(' end; ', r); r:=r+1;
591: ad_ddl.build_statement(' ', r); r:=r+1;
592: ad_ddl.build_statement(' if (l_elimtb_y_n = ''N'') then ', r); r:=r+1;
593: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;

Line 590: ad_ddl.build_statement(' end; ', r); r:=r+1;

586: ad_ddl.build_statement(' from gcs_entries_gt geg ', r); r:=r+1;
587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;
588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;
589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;
590: ad_ddl.build_statement(' end; ', r); r:=r+1;
591: ad_ddl.build_statement(' ', r); r:=r+1;
592: ad_ddl.build_statement(' if (l_elimtb_y_n = ''N'') then ', r); r:=r+1;
593: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
594: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;

Line 591: ad_ddl.build_statement(' ', r); r:=r+1;

587: ad_ddl.build_statement(' where formula_text NOT LIKE ''%ELIMTB%'' ', r); r:=r+1;
588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;
589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;
590: ad_ddl.build_statement(' end; ', r); r:=r+1;
591: ad_ddl.build_statement(' ', r); r:=r+1;
592: ad_ddl.build_statement(' if (l_elimtb_y_n = ''N'') then ', r); r:=r+1;
593: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
594: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
595: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;

Line 592: ad_ddl.build_statement(' if (l_elimtb_y_n = ''N'') then ', r); r:=r+1;

588: ad_ddl.build_statement(' and rownum < 2; ', r); r:=r+1;
589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;
590: ad_ddl.build_statement(' end; ', r); r:=r+1;
591: ad_ddl.build_statement(' ', r); r:=r+1;
592: ad_ddl.build_statement(' if (l_elimtb_y_n = ''N'') then ', r); r:=r+1;
593: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
594: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
595: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
596: build_insert_clause_list(p_rownum => r,

Line 593: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;

589: ad_ddl.build_statement(' exception when others then l_elimtb_y_n := ''Y''; ', r); r:=r+1;
590: ad_ddl.build_statement(' end; ', r); r:=r+1;
591: ad_ddl.build_statement(' ', r); r:=r+1;
592: ad_ddl.build_statement(' if (l_elimtb_y_n = ''N'') then ', r); r:=r+1;
593: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
594: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
595: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
596: build_insert_clause_list(p_rownum => r,
597: p_prefix => null);

Line 594: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;

590: ad_ddl.build_statement(' end; ', r); r:=r+1;
591: ad_ddl.build_statement(' ', r); r:=r+1;
592: ad_ddl.build_statement(' if (l_elimtb_y_n = ''N'') then ', r); r:=r+1;
593: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
594: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
595: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
596: build_insert_clause_list(p_rownum => r,
597: p_prefix => null);
598: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;

Line 595: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;

591: ad_ddl.build_statement(' ', r); r:=r+1;
592: ad_ddl.build_statement(' if (l_elimtb_y_n = ''N'') then ', r); r:=r+1;
593: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
594: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
595: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
596: build_insert_clause_list(p_rownum => r,
597: p_prefix => null);
598: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
599: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;

Line 598: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;

594: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
595: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
596: build_insert_clause_list(p_rownum => r,
597: p_prefix => null);
598: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
599: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
600: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
601: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;

Line 599: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;

595: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
596: build_insert_clause_list(p_rownum => r,
597: p_prefix => null);
598: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
599: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
600: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
601: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;

Line 600: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;

596: build_insert_clause_list(p_rownum => r,
597: p_prefix => null);
598: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
599: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
600: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
601: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;

Line 601: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;

597: p_prefix => null);
598: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
599: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
600: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
601: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;

Line 602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;

598: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
599: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
600: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
601: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
606: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;

Line 603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;

599: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
600: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
601: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
606: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
607: ad_ddl.build_statement(' ) ', r); r:=r+1;

Line 604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;

600: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
601: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
606: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
607: ad_ddl.build_statement(' ) ', r); r:=r+1;
608: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;

Line 605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;

601: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
606: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
607: ad_ddl.build_statement(' ) ', r); r:=r+1;
608: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
609: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;

Line 606: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;

602: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
606: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
607: ad_ddl.build_statement(' ) ', r); r:=r+1;
608: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
609: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
610: build_insert_clause_list(p_rownum => r,

Line 607: ad_ddl.build_statement(' ) ', r); r:=r+1;

603: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
606: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
607: ad_ddl.build_statement(' ) ', r); r:=r+1;
608: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
609: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
610: build_insert_clause_list(p_rownum => r,
611: p_prefix => 'geg.tgt_');

Line 608: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;

604: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
606: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
607: ad_ddl.build_statement(' ) ', r); r:=r+1;
608: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
609: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
610: build_insert_clause_list(p_rownum => r,
611: p_prefix => 'geg.tgt_');
612: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;

Line 609: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;

605: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
606: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
607: ad_ddl.build_statement(' ) ', r); r:=r+1;
608: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
609: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
610: build_insert_clause_list(p_rownum => r,
611: p_prefix => 'geg.tgt_');
612: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
613: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;

Line 612: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;

608: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
609: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
610: build_insert_clause_list(p_rownum => r,
611: p_prefix => 'geg.tgt_');
612: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
613: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
614: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
615: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;

Line 613: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;

609: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
610: build_insert_clause_list(p_rownum => r,
611: p_prefix => 'geg.tgt_');
612: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
613: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
614: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
615: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;

Line 614: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;

610: build_insert_clause_list(p_rownum => r,
611: p_prefix => 'geg.tgt_');
612: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
613: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
614: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
615: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

Line 615: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;

611: p_prefix => 'geg.tgt_');
612: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
613: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
614: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
615: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

Line 616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;

612: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
613: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
614: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
615: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

Line 617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;

613: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
614: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
615: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
621: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

Line 618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

614: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
615: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
621: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
622: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;

Line 619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

615: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
621: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
622: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
623: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;

Line 620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

616: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
621: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
622: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
623: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
624: ad_ddl.build_statement(' GROUP BY geg.tgt_line_item_id ', r); r:=r+1;

Line 621: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

617: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
621: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
622: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
623: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
624: ad_ddl.build_statement(' GROUP BY geg.tgt_line_item_id ', r); r:=r+1;
625: build_group_by_clause(r,'geg.tgt_', 'insertassignment');

Line 622: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;

618: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
621: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
622: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
623: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
624: ad_ddl.build_statement(' GROUP BY geg.tgt_line_item_id ', r); r:=r+1;
625: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
626: ad_ddl.build_statement(' ; ', r); r:=r+1;

Line 623: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;

619: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
621: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
622: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
623: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
624: ad_ddl.build_statement(' GROUP BY geg.tgt_line_item_id ', r); r:=r+1;
625: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
626: ad_ddl.build_statement(' ; ', r); r:=r+1;
627: ad_ddl.build_statement(' ', r); r:=r+1;

Line 624: ad_ddl.build_statement(' GROUP BY geg.tgt_line_item_id ', r); r:=r+1;

620: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
621: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
622: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
623: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
624: ad_ddl.build_statement(' GROUP BY geg.tgt_line_item_id ', r); r:=r+1;
625: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
626: ad_ddl.build_statement(' ; ', r); r:=r+1;
627: ad_ddl.build_statement(' ', r); r:=r+1;
628: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;

Line 626: ad_ddl.build_statement(' ; ', r); r:=r+1;

622: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
623: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
624: ad_ddl.build_statement(' GROUP BY geg.tgt_line_item_id ', r); r:=r+1;
625: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
626: ad_ddl.build_statement(' ; ', r); r:=r+1;
627: ad_ddl.build_statement(' ', r); r:=r+1;
628: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
629: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
630: ad_ddl.build_statement(' ', r); r:=r+1;

Line 627: ad_ddl.build_statement(' ', r); r:=r+1;

623: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
624: ad_ddl.build_statement(' GROUP BY geg.tgt_line_item_id ', r); r:=r+1;
625: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
626: ad_ddl.build_statement(' ; ', r); r:=r+1;
627: ad_ddl.build_statement(' ', r); r:=r+1;
628: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
629: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
630: ad_ddl.build_statement(' ', r); r:=r+1;
631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;

Line 628: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;

624: ad_ddl.build_statement(' GROUP BY geg.tgt_line_item_id ', r); r:=r+1;
625: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
626: ad_ddl.build_statement(' ; ', r); r:=r+1;
627: ad_ddl.build_statement(' ', r); r:=r+1;
628: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
629: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
630: ad_ddl.build_statement(' ', r); r:=r+1;
631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
632: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;

Line 629: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;

625: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
626: ad_ddl.build_statement(' ; ', r); r:=r+1;
627: ad_ddl.build_statement(' ', r); r:=r+1;
628: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
629: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
630: ad_ddl.build_statement(' ', r); r:=r+1;
631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
632: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
633: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;

Line 630: ad_ddl.build_statement(' ', r); r:=r+1;

626: ad_ddl.build_statement(' ; ', r); r:=r+1;
627: ad_ddl.build_statement(' ', r); r:=r+1;
628: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
629: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
630: ad_ddl.build_statement(' ', r); r:=r+1;
631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
632: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
633: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
634: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;

Line 631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;

627: ad_ddl.build_statement(' ', r); r:=r+1;
628: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
629: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
630: ad_ddl.build_statement(' ', r); r:=r+1;
631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
632: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
633: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
634: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
635: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;

Line 632: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;

628: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
629: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
630: ad_ddl.build_statement(' ', r); r:=r+1;
631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
632: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
633: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
634: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
635: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
636: build_insert_clause_list(p_rownum => r,

Line 633: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;

629: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
630: ad_ddl.build_statement(' ', r); r:=r+1;
631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
632: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
633: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
634: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
635: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
636: build_insert_clause_list(p_rownum => r,
637: p_prefix => null);

Line 634: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;

630: ad_ddl.build_statement(' ', r); r:=r+1;
631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
632: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
633: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
634: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
635: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
636: build_insert_clause_list(p_rownum => r,
637: p_prefix => null);
638: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;

Line 635: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;

631: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
632: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
633: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
634: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
635: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
636: build_insert_clause_list(p_rownum => r,
637: p_prefix => null);
638: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
639: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;

Line 638: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;

634: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
635: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
636: build_insert_clause_list(p_rownum => r,
637: p_prefix => null);
638: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
639: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
640: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
641: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;

Line 639: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;

635: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
636: build_insert_clause_list(p_rownum => r,
637: p_prefix => null);
638: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
639: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
640: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
641: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;

Line 640: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;

636: build_insert_clause_list(p_rownum => r,
637: p_prefix => null);
638: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
639: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
640: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
641: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;

Line 641: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;

637: p_prefix => null);
638: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
639: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
640: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
641: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;

Line 642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;

638: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
639: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
640: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
641: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
646: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;

Line 643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;

639: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
640: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
641: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
646: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
647: ad_ddl.build_statement(' ) ', r); r:=r+1;

Line 644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;

640: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
641: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
646: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
647: ad_ddl.build_statement(' ) ', r); r:=r+1;
648: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;

Line 645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;

641: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
646: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
647: ad_ddl.build_statement(' ) ', r); r:=r+1;
648: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
649: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;

Line 646: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;

642: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
646: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
647: ad_ddl.build_statement(' ) ', r); r:=r+1;
648: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
649: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
650: build_insert_clause_list(p_rownum => r,

Line 647: ad_ddl.build_statement(' ) ', r); r:=r+1;

643: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
646: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
647: ad_ddl.build_statement(' ) ', r); r:=r+1;
648: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
649: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
650: build_insert_clause_list(p_rownum => r,
651: p_prefix => 'geg.off_');

Line 648: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;

644: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
646: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
647: ad_ddl.build_statement(' ) ', r); r:=r+1;
648: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
649: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
650: build_insert_clause_list(p_rownum => r,
651: p_prefix => 'geg.off_');
652: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;

Line 649: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;

645: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
646: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
647: ad_ddl.build_statement(' ) ', r); r:=r+1;
648: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
649: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
650: build_insert_clause_list(p_rownum => r,
651: p_prefix => 'geg.off_');
652: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
653: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;

Line 652: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;

648: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
649: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
650: build_insert_clause_list(p_rownum => r,
651: p_prefix => 'geg.off_');
652: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
653: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
654: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
655: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;

Line 653: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;

649: ad_ddl.build_statement(' min(geg.tgt_company_cost_center_org_id), ', r); r:=r+1;
650: build_insert_clause_list(p_rownum => r,
651: p_prefix => 'geg.off_');
652: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
653: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
654: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
655: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;

Line 654: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;

650: build_insert_clause_list(p_rownum => r,
651: p_prefix => 'geg.off_');
652: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
653: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
654: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
655: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

Line 655: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;

651: p_prefix => 'geg.off_');
652: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
653: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
654: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
655: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

Line 656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;

652: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
653: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
654: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
655: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

Line 657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;

653: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
654: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
655: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
661: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

Line 658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

654: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
655: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
661: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
662: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;

Line 659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

655: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
661: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
662: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
663: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;

Line 660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

656: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
661: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
662: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
663: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
664: ad_ddl.build_statement(' GROUP BY geg.off_line_item_id ', r); r:=r+1;

Line 661: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

657: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
661: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
662: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
663: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
664: ad_ddl.build_statement(' GROUP BY geg.off_line_item_id ', r); r:=r+1;
665: build_group_by_clause(r,'geg.off_', 'insertassignment');

Line 662: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;

658: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
661: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
662: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
663: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
664: ad_ddl.build_statement(' GROUP BY geg.off_line_item_id ', r); r:=r+1;
665: build_group_by_clause(r,'geg.off_', 'insertassignment');
666: ad_ddl.build_statement(' ; ', r); r:=r+1;

Line 663: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;

659: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
661: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
662: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
663: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
664: ad_ddl.build_statement(' GROUP BY geg.off_line_item_id ', r); r:=r+1;
665: build_group_by_clause(r,'geg.off_', 'insertassignment');
666: ad_ddl.build_statement(' ; ', r); r:=r+1;
667: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;

Line 664: ad_ddl.build_statement(' GROUP BY geg.off_line_item_id ', r); r:=r+1;

660: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
661: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
662: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
663: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
664: ad_ddl.build_statement(' GROUP BY geg.off_line_item_id ', r); r:=r+1;
665: build_group_by_clause(r,'geg.off_', 'insertassignment');
666: ad_ddl.build_statement(' ; ', r); r:=r+1;
667: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
668: ad_ddl.build_statement(' else ', r); r:=r+1;

Line 666: ad_ddl.build_statement(' ; ', r); r:=r+1;

662: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
663: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
664: ad_ddl.build_statement(' GROUP BY geg.off_line_item_id ', r); r:=r+1;
665: build_group_by_clause(r,'geg.off_', 'insertassignment');
666: ad_ddl.build_statement(' ; ', r); r:=r+1;
667: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
668: ad_ddl.build_statement(' else ', r); r:=r+1;
669: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
670: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;

Line 667: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;

663: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
664: ad_ddl.build_statement(' GROUP BY geg.off_line_item_id ', r); r:=r+1;
665: build_group_by_clause(r,'geg.off_', 'insertassignment');
666: ad_ddl.build_statement(' ; ', r); r:=r+1;
667: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
668: ad_ddl.build_statement(' else ', r); r:=r+1;
669: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
670: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
671: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;

Line 668: ad_ddl.build_statement(' else ', r); r:=r+1;

664: ad_ddl.build_statement(' GROUP BY geg.off_line_item_id ', r); r:=r+1;
665: build_group_by_clause(r,'geg.off_', 'insertassignment');
666: ad_ddl.build_statement(' ; ', r); r:=r+1;
667: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
668: ad_ddl.build_statement(' else ', r); r:=r+1;
669: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
670: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
671: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
672: build_insert_clause_list(p_rownum => r,

Line 669: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;

665: build_group_by_clause(r,'geg.off_', 'insertassignment');
666: ad_ddl.build_statement(' ; ', r); r:=r+1;
667: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
668: ad_ddl.build_statement(' else ', r); r:=r+1;
669: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
670: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
671: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
672: build_insert_clause_list(p_rownum => r,
673: p_prefix => null);

Line 670: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;

666: ad_ddl.build_statement(' ; ', r); r:=r+1;
667: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
668: ad_ddl.build_statement(' else ', r); r:=r+1;
669: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
670: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
671: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
672: build_insert_clause_list(p_rownum => r,
673: p_prefix => null);
674: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;

Line 671: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;

667: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
668: ad_ddl.build_statement(' else ', r); r:=r+1;
669: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
670: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
671: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
672: build_insert_clause_list(p_rownum => r,
673: p_prefix => null);
674: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
675: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;

Line 674: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;

670: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
671: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
672: build_insert_clause_list(p_rownum => r,
673: p_prefix => null);
674: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
675: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
676: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
677: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;

Line 675: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;

671: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
672: build_insert_clause_list(p_rownum => r,
673: p_prefix => null);
674: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
675: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
676: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
677: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;

Line 676: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;

672: build_insert_clause_list(p_rownum => r,
673: p_prefix => null);
674: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
675: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
676: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
677: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;

Line 677: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;

673: p_prefix => null);
674: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
675: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
676: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
677: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;

Line 678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;

674: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
675: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
676: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
677: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
682: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;

Line 679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;

675: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
676: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
677: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
682: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
683: ad_ddl.build_statement(' ) ', r); r:=r+1;

Line 680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;

676: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
677: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
682: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
683: ad_ddl.build_statement(' ) ', r); r:=r+1;
684: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;

Line 681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;

677: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
682: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
683: ad_ddl.build_statement(' ) ', r); r:=r+1;
684: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
685: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;

Line 682: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;

678: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
682: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
683: ad_ddl.build_statement(' ) ', r); r:=r+1;
684: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
685: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
686: build_insert_clause_list(p_rownum => r,

Line 683: ad_ddl.build_statement(' ) ', r); r:=r+1;

679: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
682: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
683: ad_ddl.build_statement(' ) ', r); r:=r+1;
684: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
685: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
686: build_insert_clause_list(p_rownum => r,
687: p_prefix => 'geg.tgt_');

Line 684: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;

680: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
682: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
683: ad_ddl.build_statement(' ) ', r); r:=r+1;
684: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
685: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
686: build_insert_clause_list(p_rownum => r,
687: p_prefix => 'geg.tgt_');
688: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;

Line 685: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;

681: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
682: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
683: ad_ddl.build_statement(' ) ', r); r:=r+1;
684: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
685: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
686: build_insert_clause_list(p_rownum => r,
687: p_prefix => 'geg.tgt_');
688: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
689: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;

Line 688: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;

684: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
685: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
686: build_insert_clause_list(p_rownum => r,
687: p_prefix => 'geg.tgt_');
688: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
689: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
690: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
691: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;

Line 689: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;

685: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
686: build_insert_clause_list(p_rownum => r,
687: p_prefix => 'geg.tgt_');
688: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
689: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
690: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
691: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;

Line 690: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;

686: build_insert_clause_list(p_rownum => r,
687: p_prefix => 'geg.tgt_');
688: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
689: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
690: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
691: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

Line 691: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;

687: p_prefix => 'geg.tgt_');
688: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
689: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
690: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
691: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

Line 692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;

688: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
689: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
690: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
691: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

Line 693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;

689: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
690: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
691: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
697: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

Line 694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

690: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
691: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
697: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
698: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;

Line 695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

691: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
697: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
698: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
699: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;

Line 696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

692: ad_ddl.build_statement(' -1 *geg.output_amount, 0)), ', r); r:=r+1;
693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
697: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
698: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
699: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
700: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id ', r); r:=r+1;

Line 697: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

693: ad_ddl.build_statement(' sum(geg.output_amount), ', r); r:=r+1;
694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
697: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
698: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
699: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
700: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id ', r); r:=r+1;
701: build_group_by_clause(r,'geg.tgt_', 'insertassignment');

Line 698: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;

694: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
697: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
698: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
699: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
700: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id ', r); r:=r+1;
701: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
702: ad_ddl.build_statement(' ; ', r); r:=r+1;

Line 699: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;

695: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
697: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
698: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
699: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
700: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id ', r); r:=r+1;
701: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
702: ad_ddl.build_statement(' ; ', r); r:=r+1;
703: ad_ddl.build_statement(' ', r); r:=r+1;

Line 700: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id ', r); r:=r+1;

696: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
697: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
698: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
699: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
700: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id ', r); r:=r+1;
701: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
702: ad_ddl.build_statement(' ; ', r); r:=r+1;
703: ad_ddl.build_statement(' ', r); r:=r+1;
704: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;

Line 702: ad_ddl.build_statement(' ; ', r); r:=r+1;

698: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
699: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
700: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id ', r); r:=r+1;
701: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
702: ad_ddl.build_statement(' ; ', r); r:=r+1;
703: ad_ddl.build_statement(' ', r); r:=r+1;
704: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
705: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
706: ad_ddl.build_statement(' ', r); r:=r+1;

Line 703: ad_ddl.build_statement(' ', r); r:=r+1;

699: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
700: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id ', r); r:=r+1;
701: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
702: ad_ddl.build_statement(' ; ', r); r:=r+1;
703: ad_ddl.build_statement(' ', r); r:=r+1;
704: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
705: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
706: ad_ddl.build_statement(' ', r); r:=r+1;
707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;

Line 704: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;

700: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id ', r); r:=r+1;
701: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
702: ad_ddl.build_statement(' ; ', r); r:=r+1;
703: ad_ddl.build_statement(' ', r); r:=r+1;
704: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
705: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
706: ad_ddl.build_statement(' ', r); r:=r+1;
707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
708: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;

Line 705: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;

701: build_group_by_clause(r,'geg.tgt_', 'insertassignment');
702: ad_ddl.build_statement(' ; ', r); r:=r+1;
703: ad_ddl.build_statement(' ', r); r:=r+1;
704: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
705: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
706: ad_ddl.build_statement(' ', r); r:=r+1;
707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
708: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
709: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;

Line 706: ad_ddl.build_statement(' ', r); r:=r+1;

702: ad_ddl.build_statement(' ; ', r); r:=r+1;
703: ad_ddl.build_statement(' ', r); r:=r+1;
704: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
705: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
706: ad_ddl.build_statement(' ', r); r:=r+1;
707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
708: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
709: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
710: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;

Line 707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;

703: ad_ddl.build_statement(' ', r); r:=r+1;
704: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
705: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
706: ad_ddl.build_statement(' ', r); r:=r+1;
707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
708: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
709: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
710: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
711: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;

Line 708: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;

704: ad_ddl.build_statement(' --check number of rows inserted ', r); r:=r+1;
705: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
706: ad_ddl.build_statement(' ', r); r:=r+1;
707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
708: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
709: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
710: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
711: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
712: build_insert_clause_list(p_rownum => r,

Line 709: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;

705: ad_ddl.build_statement(' p_row_count := SQL%ROWCOUNT; ', r); r:=r+1;
706: ad_ddl.build_statement(' ', r); r:=r+1;
707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
708: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
709: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
710: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
711: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
712: build_insert_clause_list(p_rownum => r,
713: p_prefix => null);

Line 710: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;

706: ad_ddl.build_statement(' ', r); r:=r+1;
707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
708: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
709: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
710: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
711: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
712: build_insert_clause_list(p_rownum => r,
713: p_prefix => null);
714: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;

Line 711: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;

707: ad_ddl.build_statement(' --insert rows if the offset flag was used ', r); r:=r+1;
708: ad_ddl.build_statement(' if (p_offset_flag = ''Y'') then ', r); r:=r+1;
709: ad_ddl.build_statement(' insert into gcs_entry_lines ', r); r:=r+1;
710: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
711: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
712: build_insert_clause_list(p_rownum => r,
713: p_prefix => null);
714: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
715: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;

Line 714: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;

710: ad_ddl.build_statement(' ( entry_id, ', r); r:=r+1;
711: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
712: build_insert_clause_list(p_rownum => r,
713: p_prefix => null);
714: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
715: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
716: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
717: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;

Line 715: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;

711: ad_ddl.build_statement(' company_cost_center_org_id, ', r); r:=r+1;
712: build_insert_clause_list(p_rownum => r,
713: p_prefix => null);
714: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
715: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
716: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
717: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;

Line 716: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;

712: build_insert_clause_list(p_rownum => r,
713: p_prefix => null);
714: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
715: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
716: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
717: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;

Line 717: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;

713: p_prefix => null);
714: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
715: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
716: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
717: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;

Line 718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;

714: ad_ddl.build_statement(' intercompany_id, ', r); r:=r+1;
715: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
716: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
717: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
722: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;

Line 719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;

715: ad_ddl.build_statement(' ytd_debit_balance_e, ', r); r:=r+1;
716: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
717: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
722: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
723: ad_ddl.build_statement(' ) ', r); r:=r+1;

Line 720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;

716: ad_ddl.build_statement(' ytd_credit_balance_e, ', r); r:=r+1;
717: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
722: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
723: ad_ddl.build_statement(' ) ', r); r:=r+1;
724: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;

Line 721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;

717: ad_ddl.build_statement(' ytd_balance_e, ', r); r:=r+1;
718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
722: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
723: ad_ddl.build_statement(' ) ', r); r:=r+1;
724: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
725: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;

Line 722: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;

718: ad_ddl.build_statement(' creation_date, ', r); r:=r+1;
719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
722: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
723: ad_ddl.build_statement(' ) ', r); r:=r+1;
724: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
725: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
726: build_insert_clause_list(p_rownum => r,

Line 723: ad_ddl.build_statement(' ) ', r); r:=r+1;

719: ad_ddl.build_statement(' created_by, ', r); r:=r+1;
720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
722: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
723: ad_ddl.build_statement(' ) ', r); r:=r+1;
724: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
725: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
726: build_insert_clause_list(p_rownum => r,
727: p_prefix => 'geg.off_');

Line 724: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;

720: ad_ddl.build_statement(' last_updated_by, ', r); r:=r+1;
721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
722: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
723: ad_ddl.build_statement(' ) ', r); r:=r+1;
724: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
725: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
726: build_insert_clause_list(p_rownum => r,
727: p_prefix => 'geg.off_');
728: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;

Line 725: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;

721: ad_ddl.build_statement(' last_update_date, ', r); r:=r+1;
722: ad_ddl.build_statement(' last_update_login ', r); r:=r+1;
723: ad_ddl.build_statement(' ) ', r); r:=r+1;
724: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
725: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
726: build_insert_clause_list(p_rownum => r,
727: p_prefix => 'geg.off_');
728: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
729: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;

Line 728: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;

724: ad_ddl.build_statement(' SELECT p_entry_id, ', r); r:=r+1;
725: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
726: build_insert_clause_list(p_rownum => r,
727: p_prefix => 'geg.off_');
728: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
729: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
730: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
731: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;

Line 729: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;

725: ad_ddl.build_statement(' geg.src_company_cost_center_org_id, ', r); r:=r+1;
726: build_insert_clause_list(p_rownum => r,
727: p_prefix => 'geg.off_');
728: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
729: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
730: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
731: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;

Line 730: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;

726: build_insert_clause_list(p_rownum => r,
727: p_prefix => 'geg.off_');
728: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
729: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
730: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
731: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

Line 731: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;

727: p_prefix => 'geg.off_');
728: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
729: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
730: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
731: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

Line 732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;

728: ad_ddl.build_statement(' min(geg.tgt_intercompany_id), ', r); r:=r+1;
729: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
730: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
731: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

Line 733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;

729: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), -1, ', r); r:=r+1;
730: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
731: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
737: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

Line 734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

730: ad_ddl.build_statement(' -1 * geg.output_amount, 0)), ', r); r:=r+1;
731: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
737: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
738: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;

Line 735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

731: ad_ddl.build_statement(' sum(decode(sign(geg.output_amount), 1, ', r); r:=r+1;
732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
737: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
738: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
739: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;

Line 736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;

732: ad_ddl.build_statement(' geg.output_amount, 0)), ', r); r:=r+1;
733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
737: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
738: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
739: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
740: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id ', r); r:=r+1;

Line 737: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;

733: ad_ddl.build_statement(' -1 * sum(geg.output_amount), ', r); r:=r+1;
734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
737: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
738: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
739: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
740: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id ', r); r:=r+1;
741: build_group_by_clause(r,'geg.off_', 'insertassignment');

Line 738: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;

734: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
737: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
738: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
739: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
740: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id ', r); r:=r+1;
741: build_group_by_clause(r,'geg.off_', 'insertassignment');
742: ad_ddl.build_statement(' ; ', r); r:=r+1;

Line 739: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;

735: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
737: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
738: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
739: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
740: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id ', r); r:=r+1;
741: build_group_by_clause(r,'geg.off_', 'insertassignment');
742: ad_ddl.build_statement(' ; ', r); r:=r+1;
743: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;

Line 740: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id ', r); r:=r+1;

736: ad_ddl.build_statement(' fnd_global.user_id, ', r); r:=r+1;
737: ad_ddl.build_statement(' sysdate, ', r); r:=r+1;
738: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
739: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
740: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id ', r); r:=r+1;
741: build_group_by_clause(r,'geg.off_', 'insertassignment');
742: ad_ddl.build_statement(' ; ', r); r:=r+1;
743: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
744: ad_ddl.build_statement(' end if; ', r); r:=r+1;

Line 742: ad_ddl.build_statement(' ; ', r); r:=r+1;

738: ad_ddl.build_statement(' fnd_global.login_id ', r); r:=r+1;
739: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
740: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id ', r); r:=r+1;
741: build_group_by_clause(r,'geg.off_', 'insertassignment');
742: ad_ddl.build_statement(' ; ', r); r:=r+1;
743: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
744: ad_ddl.build_statement(' end if; ', r); r:=r+1;
745: ad_ddl.build_statement(' ', r); r:=r+1;
746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;

Line 743: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;

739: ad_ddl.build_statement(' FROM gcs_entries_gt geg ', r); r:=r+1;
740: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id ', r); r:=r+1;
741: build_group_by_clause(r,'geg.off_', 'insertassignment');
742: ad_ddl.build_statement(' ; ', r); r:=r+1;
743: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
744: ad_ddl.build_statement(' end if; ', r); r:=r+1;
745: ad_ddl.build_statement(' ', r); r:=r+1;
746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;

Line 744: ad_ddl.build_statement(' end if; ', r); r:=r+1;

740: ad_ddl.build_statement(' GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id ', r); r:=r+1;
741: build_group_by_clause(r,'geg.off_', 'insertassignment');
742: ad_ddl.build_statement(' ; ', r); r:=r+1;
743: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
744: ad_ddl.build_statement(' end if; ', r); r:=r+1;
745: ad_ddl.build_statement(' ', r); r:=r+1;
746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;
748: ad_ddl.build_statement(' end if; ', r); r:=r+1;

Line 745: ad_ddl.build_statement(' ', r); r:=r+1;

741: build_group_by_clause(r,'geg.off_', 'insertassignment');
742: ad_ddl.build_statement(' ; ', r); r:=r+1;
743: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
744: ad_ddl.build_statement(' end if; ', r); r:=r+1;
745: ad_ddl.build_statement(' ', r); r:=r+1;
746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;
748: ad_ddl.build_statement(' end if; ', r); r:=r+1;
749: ad_ddl.build_statement(' ', r); r:=r+1;

Line 746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;

742: ad_ddl.build_statement(' ; ', r); r:=r+1;
743: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
744: ad_ddl.build_statement(' end if; ', r); r:=r+1;
745: ad_ddl.build_statement(' ', r); r:=r+1;
746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;
748: ad_ddl.build_statement(' end if; ', r); r:=r+1;
749: ad_ddl.build_statement(' ', r); r:=r+1;
750: ad_ddl.build_statement(' end create_entry_lines; ', r); r:=r+1;

Line 747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;

743: ad_ddl.build_statement(' end if; --p_offset_flag = Y ', r); r:=r+1;
744: ad_ddl.build_statement(' end if; ', r); r:=r+1;
745: ad_ddl.build_statement(' ', r); r:=r+1;
746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;
748: ad_ddl.build_statement(' end if; ', r); r:=r+1;
749: ad_ddl.build_statement(' ', r); r:=r+1;
750: ad_ddl.build_statement(' end create_entry_lines; ', r); r:=r+1;
751: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);

Line 748: ad_ddl.build_statement(' end if; ', r); r:=r+1;

744: ad_ddl.build_statement(' end if; ', r); r:=r+1;
745: ad_ddl.build_statement(' ', r); r:=r+1;
746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;
748: ad_ddl.build_statement(' end if; ', r); r:=r+1;
749: ad_ddl.build_statement(' ', r); r:=r+1;
750: ad_ddl.build_statement(' end create_entry_lines; ', r); r:=r+1;
751: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);
752: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

Line 749: ad_ddl.build_statement(' ', r); r:=r+1;

745: ad_ddl.build_statement(' ', r); r:=r+1;
746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;
748: ad_ddl.build_statement(' end if; ', r); r:=r+1;
749: ad_ddl.build_statement(' ', r); r:=r+1;
750: ad_ddl.build_statement(' end create_entry_lines; ', r); r:=r+1;
751: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);
752: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
753: 'GCS', 'GCS_RP_UTILITY_PKG',

Line 750: ad_ddl.build_statement(' end create_entry_lines; ', r); r:=r+1;

746: ad_ddl.build_statement(' if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then ', r); r:=r+1;
747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;
748: ad_ddl.build_statement(' end if; ', r); r:=r+1;
749: ad_ddl.build_statement(' ', r); r:=r+1;
750: ad_ddl.build_statement(' end create_entry_lines; ', r); r:=r+1;
751: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);
752: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
753: 'GCS', 'GCS_RP_UTILITY_PKG',
754: 1, r , 'TRUE', comp_err);

Line 751: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);

747: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, ''gcs_rp_utility_pkg.end'', null); ', r); r:=r+1;
748: ad_ddl.build_statement(' end if; ', r); r:=r+1;
749: ad_ddl.build_statement(' ', r); r:=r+1;
750: ad_ddl.build_statement(' end create_entry_lines; ', r); r:=r+1;
751: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);
752: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
753: 'GCS', 'GCS_RP_UTILITY_PKG',
754: 1, r , 'TRUE', comp_err);
755:

Line 752: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

748: ad_ddl.build_statement(' end if; ', r); r:=r+1;
749: ad_ddl.build_statement(' ', r); r:=r+1;
750: ad_ddl.build_statement(' end create_entry_lines; ', r); r:=r+1;
751: ad_ddl.build_statement('END GCS_RP_UTILITY_PKG;', r);
752: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
753: 'GCS', 'GCS_RP_UTILITY_PKG',
754: 1, r , 'TRUE', comp_err);
755:
756: END create_rp_utility_pkg;