DBA Data[Home] [Help]

APPS.IGI_IAC_EXTRACT_PKG dependencies on IGI_IAC_XLA_LINES_GT

Line 167: insert into igi_iac_xla_lines_gt (

163: k.amount,
164: k.currency_code);
165:
166: --Extract IAC reference lines object
167: insert into igi_iac_xla_lines_gt (
168: IAC_EVENT_ID,
169: IAC_LINE_NUMBER,
170: IAC_BOOK_TYPE_CODE,
171: IAC_CATEGORY_ID,

Line 252: /*delete from igi_iac_xla_lines_gt_tmp;

248: end loop; --k
249: end loop; --i
250:
251: --Debug
252: /*delete from igi_iac_xla_lines_gt_tmp;
253: insert into igi_iac_xla_lines_gt_tmp
254: select * from igi_iac_xla_lines_gt;
255:
256: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;

Line 253: insert into igi_iac_xla_lines_gt_tmp

249: end loop; --i
250:
251: --Debug
252: /*delete from igi_iac_xla_lines_gt_tmp;
253: insert into igi_iac_xla_lines_gt_tmp
254: select * from igi_iac_xla_lines_gt;
255:
256: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
257: insert into FA_XLA_EXT_HEADERS_B_GT_tmp

Line 254: select * from igi_iac_xla_lines_gt;

250:
251: --Debug
252: /*delete from igi_iac_xla_lines_gt_tmp;
253: insert into igi_iac_xla_lines_gt_tmp
254: select * from igi_iac_xla_lines_gt;
255:
256: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
257: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
258: select * from FA_XLA_EXT_HEADERS_B_GT;

Line 436: insert into igi_iac_xla_lines_gt (

432: from fa_xla_ext_lines_b_gt
433: where event_id = i.event_id
434: and rownum = 1;
435:
436: insert into igi_iac_xla_lines_gt (
437: IAC_EVENT_ID,
438: IAC_LINE_NUMBER,
439: IAC_BOOK_TYPE_CODE,
440: IAC_CATEGORY_ID,

Line 522: /* delete from igi_iac_xla_lines_gt_tmp;

518: end loop; --i
519:
520:
521: --Debug
522: /* delete from igi_iac_xla_lines_gt_tmp;
523: insert into igi_iac_xla_lines_gt_tmp
524: select * from igi_iac_xla_lines_gt;
525:
526: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;

Line 523: insert into igi_iac_xla_lines_gt_tmp

519:
520:
521: --Debug
522: /* delete from igi_iac_xla_lines_gt_tmp;
523: insert into igi_iac_xla_lines_gt_tmp
524: select * from igi_iac_xla_lines_gt;
525:
526: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
527: insert into FA_XLA_EXT_HEADERS_B_GT_tmp

Line 524: select * from igi_iac_xla_lines_gt;

520:
521: --Debug
522: /* delete from igi_iac_xla_lines_gt_tmp;
523: insert into igi_iac_xla_lines_gt_tmp
524: select * from igi_iac_xla_lines_gt;
525:
526: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
527: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
528: select * from FA_XLA_EXT_HEADERS_B_GT;

Line 549: select * from igi_iac_xla_lines_gt;

545: l_procedure_name varchar2(80) := 'extract_transactions';
546: l_path_name varchar2(2000);
547:
548: cursor debug_ref_lines is
549: select * from igi_iac_xla_lines_gt;
550:
551: BEGIN
552: l_path_name := g_path || l_procedure_name;
553: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 557: insert into igi_iac_xla_lines_gt (

553: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
554: p_full_path => l_path_name,
555: p_string => 'extract_transactions....Welcome... ');
556: --Extract IAC reference lines object
557: insert into igi_iac_xla_lines_gt (
558: IAC_EVENT_ID,
559: IAC_LINE_NUMBER,
560: IAC_BOOK_TYPE_CODE,
561: IAC_CATEGORY_ID,

Line 655: /* delete from igi_iac_xla_lines_gt_tmp;

651: and ctlgd.event_type_code ='DEPRECIATION'
652: and adj.transfer_to_gl_flag = 'Y';
653:
654: --Debug
655: /* delete from igi_iac_xla_lines_gt_tmp;
656: insert into igi_iac_xla_lines_gt_tmp
657: select * from igi_iac_xla_lines_gt;
658:
659: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;

Line 656: insert into igi_iac_xla_lines_gt_tmp

652: and adj.transfer_to_gl_flag = 'Y';
653:
654: --Debug
655: /* delete from igi_iac_xla_lines_gt_tmp;
656: insert into igi_iac_xla_lines_gt_tmp
657: select * from igi_iac_xla_lines_gt;
658:
659: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
660: insert into FA_XLA_EXT_HEADERS_B_GT_tmp

Line 657: select * from igi_iac_xla_lines_gt;

653:
654: --Debug
655: /* delete from igi_iac_xla_lines_gt_tmp;
656: insert into igi_iac_xla_lines_gt_tmp
657: select * from igi_iac_xla_lines_gt;
658:
659: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
660: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
661: select * from FA_XLA_EXT_HEADERS_B_GT;