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.XLA_THIRD_PARTY_MERGE dependencies on XLA_ENVIRONMENT_PKG

Line 533: XLA_ENVIRONMENT_PKG.g_usr_id,

529: v_ledger_id,
530: 'THIRD_PARTY_MERGE',
531: NVL(p_source_application_id, p_application_id),
532: sysdate,
533: XLA_ENVIRONMENT_PKG.g_usr_id,
534: sysdate,
535: XLA_ENVIRONMENT_PKG.g_usr_id,
536: XLA_ENVIRONMENT_PKG.g_login_id)
537: RETURNING ENTITY_ID INTO v_entity_id;

Line 535: XLA_ENVIRONMENT_PKG.g_usr_id,

531: NVL(p_source_application_id, p_application_id),
532: sysdate,
533: XLA_ENVIRONMENT_PKG.g_usr_id,
534: sysdate,
535: XLA_ENVIRONMENT_PKG.g_usr_id,
536: XLA_ENVIRONMENT_PKG.g_login_id)
537: RETURNING ENTITY_ID INTO v_entity_id;
538: -- It's a new transaciton entity, so the maximum event number must be 0
539: v_max_event_number := 0;

Line 536: XLA_ENVIRONMENT_PKG.g_login_id)

532: sysdate,
533: XLA_ENVIRONMENT_PKG.g_usr_id,
534: sysdate,
535: XLA_ENVIRONMENT_PKG.g_usr_id,
536: XLA_ENVIRONMENT_PKG.g_login_id)
537: RETURNING ENTITY_ID INTO v_entity_id;
538: -- It's a new transaciton entity, so the maximum event number must be 0
539: v_max_event_number := 0;
540:

Line 635: XLA_ENVIRONMENT_PKG.g_usr_id,

631: p_third_party_merge_date,
632: 'U',
633: 'U',
634: sysdate,
635: XLA_ENVIRONMENT_PKG.g_usr_id,
636: sysdate,
637: XLA_ENVIRONMENT_PKG.g_usr_id,
638: XLA_ENVIRONMENT_PKG.g_login_id,
639: sysdate,

Line 637: XLA_ENVIRONMENT_PKG.g_usr_id,

633: 'U',
634: sysdate,
635: XLA_ENVIRONMENT_PKG.g_usr_id,
636: sysdate,
637: XLA_ENVIRONMENT_PKG.g_usr_id,
638: XLA_ENVIRONMENT_PKG.g_login_id,
639: sysdate,
640: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
641: XLA_ENVIRONMENT_PKG.g_prog_id,

Line 638: XLA_ENVIRONMENT_PKG.g_login_id,

634: sysdate,
635: XLA_ENVIRONMENT_PKG.g_usr_id,
636: sysdate,
637: XLA_ENVIRONMENT_PKG.g_usr_id,
638: XLA_ENVIRONMENT_PKG.g_login_id,
639: sysdate,
640: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
641: XLA_ENVIRONMENT_PKG.g_prog_id,
642: XLA_ENVIRONMENT_PKG.g_req_id,

Line 640: XLA_ENVIRONMENT_PKG.g_prog_appl_id,

636: sysdate,
637: XLA_ENVIRONMENT_PKG.g_usr_id,
638: XLA_ENVIRONMENT_PKG.g_login_id,
639: sysdate,
640: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
641: XLA_ENVIRONMENT_PKG.g_prog_id,
642: XLA_ENVIRONMENT_PKG.g_req_id,
643: p_original_third_party_id,
644: p_original_site_id,

Line 641: XLA_ENVIRONMENT_PKG.g_prog_id,

637: XLA_ENVIRONMENT_PKG.g_usr_id,
638: XLA_ENVIRONMENT_PKG.g_login_id,
639: sysdate,
640: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
641: XLA_ENVIRONMENT_PKG.g_prog_id,
642: XLA_ENVIRONMENT_PKG.g_req_id,
643: p_original_third_party_id,
644: p_original_site_id,
645: p_new_third_party_id,

Line 642: XLA_ENVIRONMENT_PKG.g_req_id,

638: XLA_ENVIRONMENT_PKG.g_login_id,
639: sysdate,
640: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
641: XLA_ENVIRONMENT_PKG.g_prog_id,
642: XLA_ENVIRONMENT_PKG.g_req_id,
643: p_original_third_party_id,
644: p_original_site_id,
645: p_new_third_party_id,
646: p_new_site_id,

Line 681: XLA_ENVIRONMENT_PKG.g_usr_id,

677: gt.TO_VALUE,
678: v_event_id,
679: gt.CHART_OF_ACCOUNTS_ID,
680: sysdate,
681: XLA_ENVIRONMENT_PKG.g_usr_id,
682: sysdate,
683: XLA_ENVIRONMENT_PKG.g_usr_id,
684: XLA_ENVIRONMENT_PKG.g_login_id,
685: sysdate,

Line 683: XLA_ENVIRONMENT_PKG.g_usr_id,

679: gt.CHART_OF_ACCOUNTS_ID,
680: sysdate,
681: XLA_ENVIRONMENT_PKG.g_usr_id,
682: sysdate,
683: XLA_ENVIRONMENT_PKG.g_usr_id,
684: XLA_ENVIRONMENT_PKG.g_login_id,
685: sysdate,
686: XLA_ENVIRONMENT_PKG.g_prog_appl_id
687: FROM XLA_LEDGER_RELATIONSHIPS_V rs,

Line 684: XLA_ENVIRONMENT_PKG.g_login_id,

680: sysdate,
681: XLA_ENVIRONMENT_PKG.g_usr_id,
682: sysdate,
683: XLA_ENVIRONMENT_PKG.g_usr_id,
684: XLA_ENVIRONMENT_PKG.g_login_id,
685: sysdate,
686: XLA_ENVIRONMENT_PKG.g_prog_appl_id
687: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
688: XLA_MERGE_SEG_MAPS_GT gt,

Line 686: XLA_ENVIRONMENT_PKG.g_prog_appl_id

682: sysdate,
683: XLA_ENVIRONMENT_PKG.g_usr_id,
684: XLA_ENVIRONMENT_PKG.g_login_id,
685: sysdate,
686: XLA_ENVIRONMENT_PKG.g_prog_appl_id
687: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
688: XLA_MERGE_SEG_MAPS_GT gt,
689: GL_LEDGERS gl
690: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'

Line 739: XLA_ENVIRONMENT_PKG.g_usr_id,

735: gt.SOURCE_ID_CHAR_3,
736: gt.SOURCE_ID_CHAR_4,
737: gt.VALUATION_METHOD,
738: sysdate,
739: XLA_ENVIRONMENT_PKG.g_usr_id,
740: sysdate,
741: XLA_ENVIRONMENT_PKG.g_usr_id,
742: XLA_ENVIRONMENT_PKG.g_login_id,
743: sysdate,

Line 741: XLA_ENVIRONMENT_PKG.g_usr_id,

737: gt.VALUATION_METHOD,
738: sysdate,
739: XLA_ENVIRONMENT_PKG.g_usr_id,
740: sysdate,
741: XLA_ENVIRONMENT_PKG.g_usr_id,
742: XLA_ENVIRONMENT_PKG.g_login_id,
743: sysdate,
744: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
745: XLA_ENVIRONMENT_PKG.g_prog_id,

Line 742: XLA_ENVIRONMENT_PKG.g_login_id,

738: sysdate,
739: XLA_ENVIRONMENT_PKG.g_usr_id,
740: sysdate,
741: XLA_ENVIRONMENT_PKG.g_usr_id,
742: XLA_ENVIRONMENT_PKG.g_login_id,
743: sysdate,
744: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
745: XLA_ENVIRONMENT_PKG.g_prog_id,
746: XLA_ENVIRONMENT_PKG.g_req_id

Line 744: XLA_ENVIRONMENT_PKG.g_prog_appl_id,

740: sysdate,
741: XLA_ENVIRONMENT_PKG.g_usr_id,
742: XLA_ENVIRONMENT_PKG.g_login_id,
743: sysdate,
744: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
745: XLA_ENVIRONMENT_PKG.g_prog_id,
746: XLA_ENVIRONMENT_PKG.g_req_id
747: FROM XLA_EVENTS_GT gt,
748: XLA_TRANSACTION_ENTITIES ent

Line 745: XLA_ENVIRONMENT_PKG.g_prog_id,

741: XLA_ENVIRONMENT_PKG.g_usr_id,
742: XLA_ENVIRONMENT_PKG.g_login_id,
743: sysdate,
744: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
745: XLA_ENVIRONMENT_PKG.g_prog_id,
746: XLA_ENVIRONMENT_PKG.g_req_id
747: FROM XLA_EVENTS_GT gt,
748: XLA_TRANSACTION_ENTITIES ent
749: WHERE gt.APPLICATION_ID = p_application_id

Line 746: XLA_ENVIRONMENT_PKG.g_req_id

742: XLA_ENVIRONMENT_PKG.g_login_id,
743: sysdate,
744: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
745: XLA_ENVIRONMENT_PKG.g_prog_id,
746: XLA_ENVIRONMENT_PKG.g_req_id
747: FROM XLA_EVENTS_GT gt,
748: XLA_TRANSACTION_ENTITIES ent
749: WHERE gt.APPLICATION_ID = p_application_id
750: AND gt.LEDGER_ID = v_ledger_id

Line 1566: , xla_environment_pkg.g_Usr_Id

1562: , hed.product_rule_code
1563: , hed.product_rule_version
1564: , hed.description
1565: , TRUNC(SYSDATE)
1566: , xla_environment_pkg.g_Usr_Id
1567: , TRUNC(SYSDATE)
1568: , xla_environment_pkg.g_Usr_Id
1569: , xla_environment_pkg.g_Login_Id
1570: , hed.doc_sequence_id

Line 1568: , xla_environment_pkg.g_Usr_Id

1564: , hed.description
1565: , TRUNC(SYSDATE)
1566: , xla_environment_pkg.g_Usr_Id
1567: , TRUNC(SYSDATE)
1568: , xla_environment_pkg.g_Usr_Id
1569: , xla_environment_pkg.g_Login_Id
1570: , hed.doc_sequence_id
1571: , hed.doc_sequence_value
1572: , hed.doc_category_code

Line 1569: , xla_environment_pkg.g_Login_Id

1565: , TRUNC(SYSDATE)
1566: , xla_environment_pkg.g_Usr_Id
1567: , TRUNC(SYSDATE)
1568: , xla_environment_pkg.g_Usr_Id
1569: , xla_environment_pkg.g_Login_Id
1570: , hed.doc_sequence_id
1571: , hed.doc_sequence_value
1572: , hed.doc_category_code
1573: , TRUNC(SYSDATE)

Line 1574: , xla_environment_pkg.g_Prog_Appl_Id

1570: , hed.doc_sequence_id
1571: , hed.doc_sequence_value
1572: , hed.doc_category_code
1573: , TRUNC(SYSDATE)
1574: , xla_environment_pkg.g_Prog_Appl_Id
1575: , xla_environment_pkg.g_Prog_Id
1576: , xla_environment_pkg.g_req_Id
1577: , CASE hed.balance_type_code
1578: WHEN 'B' THEN hed.budget_version_id

Line 1575: , xla_environment_pkg.g_Prog_Id

1571: , hed.doc_sequence_value
1572: , hed.doc_category_code
1573: , TRUNC(SYSDATE)
1574: , xla_environment_pkg.g_Prog_Appl_Id
1575: , xla_environment_pkg.g_Prog_Id
1576: , xla_environment_pkg.g_req_Id
1577: , CASE hed.balance_type_code
1578: WHEN 'B' THEN hed.budget_version_id
1579: ELSE NULL

Line 1576: , xla_environment_pkg.g_req_Id

1572: , hed.doc_category_code
1573: , TRUNC(SYSDATE)
1574: , xla_environment_pkg.g_Prog_Appl_Id
1575: , xla_environment_pkg.g_Prog_Id
1576: , xla_environment_pkg.g_req_Id
1577: , CASE hed.balance_type_code
1578: WHEN 'B' THEN hed.budget_version_id
1579: ELSE NULL
1580: END

Line 2200: , XLA_ENVIRONMENT_PKG.g_login_id last_update_login

2196: END
2197: END
2198: END unrounded_entered_dr
2199: , sysdate last_update_date
2200: , XLA_ENVIRONMENT_PKG.g_login_id last_update_login
2201: , party_id
2202: , party_site_id
2203: , party_type_code
2204: , sum(statistical_amount) statistical_amount

Line 2206: , XLA_ENVIRONMENT_PKG.g_login_id created_by

2202: , party_site_id
2203: , party_type_code
2204: , sum(statistical_amount) statistical_amount
2205: , ussgl_transaction_code
2206: , XLA_ENVIRONMENT_PKG.g_login_id created_by
2207: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by
2208: , jgzz_recon_ref
2209: , sysdate program_update_date
2210: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id

Line 2207: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by

2203: , party_type_code
2204: , sum(statistical_amount) statistical_amount
2205: , ussgl_transaction_code
2206: , XLA_ENVIRONMENT_PKG.g_login_id created_by
2207: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by
2208: , jgzz_recon_ref
2209: , sysdate program_update_date
2210: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id
2211: , XLA_ENVIRONMENT_PKG.g_prog_id program_id

Line 2210: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id

2206: , XLA_ENVIRONMENT_PKG.g_login_id created_by
2207: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by
2208: , jgzz_recon_ref
2209: , sysdate program_update_date
2210: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id
2211: , XLA_ENVIRONMENT_PKG.g_prog_id program_id
2212: , p_application_id application_id
2213: , XLA_ENVIRONMENT_PKG.g_req_id request_id
2214: , 'XLAJEL' gl_sl_link_table

Line 2211: , XLA_ENVIRONMENT_PKG.g_prog_id program_id

2207: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by
2208: , jgzz_recon_ref
2209: , sysdate program_update_date
2210: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id
2211: , XLA_ENVIRONMENT_PKG.g_prog_id program_id
2212: , p_application_id application_id
2213: , XLA_ENVIRONMENT_PKG.g_req_id request_id
2214: , 'XLAJEL' gl_sl_link_table
2215: , business_class_code -- 4336173

Line 2213: , XLA_ENVIRONMENT_PKG.g_req_id request_id

2209: , sysdate program_update_date
2210: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id
2211: , XLA_ENVIRONMENT_PKG.g_prog_id program_id
2212: , p_application_id application_id
2213: , XLA_ENVIRONMENT_PKG.g_req_id request_id
2214: , 'XLAJEL' gl_sl_link_table
2215: , business_class_code -- 4336173
2216: , mpa_accrual_entry_flag -- 4262811
2217: , encumbrance_type_id -- 4458381 Public Sector Enh

Line 2229: , XLA_ENVIRONMENT_PKG.g_login_id

2225: GROUP BY lin.ae_header_id
2226: , ae_line_num
2227: , header_num -- 4262811c MPA reversal lines
2228: , sysdate
2229: , XLA_ENVIRONMENT_PKG.g_login_id
2230: , XLA_ENVIRONMENT_PKG.g_prog_appl_id
2231: , XLA_ENVIRONMENT_PKG.g_prog_id
2232: , XLA_ENVIRONMENT_PKG.g_req_id
2233: , p_application_id

Line 2230: , XLA_ENVIRONMENT_PKG.g_prog_appl_id

2226: , ae_line_num
2227: , header_num -- 4262811c MPA reversal lines
2228: , sysdate
2229: , XLA_ENVIRONMENT_PKG.g_login_id
2230: , XLA_ENVIRONMENT_PKG.g_prog_appl_id
2231: , XLA_ENVIRONMENT_PKG.g_prog_id
2232: , XLA_ENVIRONMENT_PKG.g_req_id
2233: , p_application_id
2234: , accounting_class_code

Line 2231: , XLA_ENVIRONMENT_PKG.g_prog_id

2227: , header_num -- 4262811c MPA reversal lines
2228: , sysdate
2229: , XLA_ENVIRONMENT_PKG.g_login_id
2230: , XLA_ENVIRONMENT_PKG.g_prog_appl_id
2231: , XLA_ENVIRONMENT_PKG.g_prog_id
2232: , XLA_ENVIRONMENT_PKG.g_req_id
2233: , p_application_id
2234: , accounting_class_code
2235: , event_class_code

Line 2232: , XLA_ENVIRONMENT_PKG.g_req_id

2228: , sysdate
2229: , XLA_ENVIRONMENT_PKG.g_login_id
2230: , XLA_ENVIRONMENT_PKG.g_prog_appl_id
2231: , XLA_ENVIRONMENT_PKG.g_prog_id
2232: , XLA_ENVIRONMENT_PKG.g_req_id
2233: , p_application_id
2234: , accounting_class_code
2235: , event_class_code
2236: , event_type_code

Line 3880: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

3876: , SUBSTRB(DESCRIPTION, 0,
3877: 1995 - LENGTHB(v_aeh_desc))
3878: || ' ' || v_aeh_desc),
3879: LAST_UPDATE_DATE = sysdate,
3880: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3881: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3882: PROGRAM_UPDATE_DATE = sysdate,
3883: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3884: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 3881: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

3877: 1995 - LENGTHB(v_aeh_desc))
3878: || ' ' || v_aeh_desc),
3879: LAST_UPDATE_DATE = sysdate,
3880: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3881: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3882: PROGRAM_UPDATE_DATE = sysdate,
3883: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3884: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3885: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 3883: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

3879: LAST_UPDATE_DATE = sysdate,
3880: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3881: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3882: PROGRAM_UPDATE_DATE = sysdate,
3883: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3884: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3885: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
3886: WHERE aeh.APPLICATION_ID = p_application_id
3887: AND aeh.LEDGER_ID = p_array_ledger_id(i)

Line 3884: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

3880: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3881: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3882: PROGRAM_UPDATE_DATE = sysdate,
3883: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3884: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3885: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
3886: WHERE aeh.APPLICATION_ID = p_application_id
3887: AND aeh.LEDGER_ID = p_array_ledger_id(i)
3888: AND ((aeh.accounting_entry_status_code = 'F' AND

Line 3885: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

3881: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3882: PROGRAM_UPDATE_DATE = sysdate,
3883: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3884: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3885: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
3886: WHERE aeh.APPLICATION_ID = p_application_id
3887: AND aeh.LEDGER_ID = p_array_ledger_id(i)
3888: AND ((aeh.accounting_entry_status_code = 'F' AND
3889: p_array_merge_option(i) = 'CHANGE')

Line 3926: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

3922: , SUBSTRB(DESCRIPTION, 0,
3923: 1995 - LENGTHB(v_aeh_desc))
3924: || ' ' || v_aeh_desc),
3925: LAST_UPDATE_DATE = sysdate,
3926: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3927: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3928: PROGRAM_UPDATE_DATE = sysdate,
3929: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3930: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 3927: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

3923: 1995 - LENGTHB(v_aeh_desc))
3924: || ' ' || v_aeh_desc),
3925: LAST_UPDATE_DATE = sysdate,
3926: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3927: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3928: PROGRAM_UPDATE_DATE = sysdate,
3929: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3930: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3931: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 3929: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

3925: LAST_UPDATE_DATE = sysdate,
3926: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3927: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3928: PROGRAM_UPDATE_DATE = sysdate,
3929: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3930: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3931: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
3932: WHERE aeh.APPLICATION_ID = p_application_id
3933: AND aeh.LEDGER_ID = p_array_ledger_id(i)

Line 3930: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

3926: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3927: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3928: PROGRAM_UPDATE_DATE = sysdate,
3929: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3930: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3931: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
3932: WHERE aeh.APPLICATION_ID = p_application_id
3933: AND aeh.LEDGER_ID = p_array_ledger_id(i)
3934: AND ((aeh.accounting_entry_status_code = 'F' AND

Line 3931: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

3927: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3928: PROGRAM_UPDATE_DATE = sysdate,
3929: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3930: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3931: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
3932: WHERE aeh.APPLICATION_ID = p_application_id
3933: AND aeh.LEDGER_ID = p_array_ledger_id(i)
3934: AND ((aeh.accounting_entry_status_code = 'F' AND
3935: p_array_merge_option(i) = 'CHANGE')

Line 4005: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

4001: , SUBSTRB(DESCRIPTION, 0,
4002: 1995 - LENGTHB(p_line_desc))
4003: || ' ' || p_line_desc),
4004: LAST_UPDATE_DATE = sysdate,
4005: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4006: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4007: PROGRAM_UPDATE_DATE = sysdate,
4008: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4009: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 4006: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

4002: 1995 - LENGTHB(p_line_desc))
4003: || ' ' || p_line_desc),
4004: LAST_UPDATE_DATE = sysdate,
4005: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4006: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4007: PROGRAM_UPDATE_DATE = sysdate,
4008: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4009: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4010: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 4008: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

4004: LAST_UPDATE_DATE = sysdate,
4005: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4006: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4007: PROGRAM_UPDATE_DATE = sysdate,
4008: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4009: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4010: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4011: WHERE ael.PARTY_ID = p_old_party_id
4012: AND ( p_old_site_id IS NULL

Line 4009: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

4005: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4006: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4007: PROGRAM_UPDATE_DATE = sysdate,
4008: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4009: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4010: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4011: WHERE ael.PARTY_ID = p_old_party_id
4012: AND ( p_old_site_id IS NULL
4013: OR ael.PARTY_SITE_ID = p_old_site_id)

Line 4010: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

4006: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4007: PROGRAM_UPDATE_DATE = sysdate,
4008: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4009: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4010: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4011: WHERE ael.PARTY_ID = p_old_party_id
4012: AND ( p_old_site_id IS NULL
4013: OR ael.PARTY_SITE_ID = p_old_site_id)
4014: AND ael.PARTY_TYPE_CODE = p_party_type

Line 4058: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

4054: UPDATE XLA_TRIAL_BALANCES tb
4055: SET PARTY_ID = p_new_party_id,
4056: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4057: LAST_UPDATE_DATE = sysdate,
4058: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4059: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4060: PROGRAM_UPDATE_DATE = sysdate,
4061: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4062: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 4059: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

4055: SET PARTY_ID = p_new_party_id,
4056: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4057: LAST_UPDATE_DATE = sysdate,
4058: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4059: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4060: PROGRAM_UPDATE_DATE = sysdate,
4061: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4062: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4063: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 4061: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

4057: LAST_UPDATE_DATE = sysdate,
4058: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4059: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4060: PROGRAM_UPDATE_DATE = sysdate,
4061: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4062: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4063: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4064: WHERE tb.PARTY_ID = p_old_party_id
4065: AND ( p_old_site_id IS NULL

Line 4062: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

4058: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4059: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4060: PROGRAM_UPDATE_DATE = sysdate,
4061: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4062: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4063: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4064: WHERE tb.PARTY_ID = p_old_party_id
4065: AND ( p_old_site_id IS NULL
4066: OR tb.PARTY_SITE_ID = p_old_site_id)

Line 4063: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

4059: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4060: PROGRAM_UPDATE_DATE = sysdate,
4061: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4062: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4063: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4064: WHERE tb.PARTY_ID = p_old_party_id
4065: AND ( p_old_site_id IS NULL
4066: OR tb.PARTY_SITE_ID = p_old_site_id)
4067: AND tb.PARTY_TYPE_CODE = p_party_type

Line 4114: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

4110: , SUBSTRB(DESCRIPTION, 0,
4111: 1995 - LENGTHB(p_line_desc))
4112: || ' ' || p_line_desc),
4113: LAST_UPDATE_DATE = sysdate,
4114: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4115: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4116: PROGRAM_UPDATE_DATE = sysdate,
4117: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4118: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 4115: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

4111: 1995 - LENGTHB(p_line_desc))
4112: || ' ' || p_line_desc),
4113: LAST_UPDATE_DATE = sysdate,
4114: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4115: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4116: PROGRAM_UPDATE_DATE = sysdate,
4117: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4118: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4119: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 4117: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

4113: LAST_UPDATE_DATE = sysdate,
4114: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4115: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4116: PROGRAM_UPDATE_DATE = sysdate,
4117: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4118: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4119: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4120: WHERE ael.PARTY_ID = p_old_party_id
4121: AND ( p_old_site_id IS NULL

Line 4118: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

4114: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4115: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4116: PROGRAM_UPDATE_DATE = sysdate,
4117: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4118: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4119: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4120: WHERE ael.PARTY_ID = p_old_party_id
4121: AND ( p_old_site_id IS NULL
4122: OR ael.PARTY_SITE_ID = p_old_site_id)

Line 4119: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

4115: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4116: PROGRAM_UPDATE_DATE = sysdate,
4117: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4118: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4119: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4120: WHERE ael.PARTY_ID = p_old_party_id
4121: AND ( p_old_site_id IS NULL
4122: OR ael.PARTY_SITE_ID = p_old_site_id)
4123: AND ael.PARTY_TYPE_CODE = p_party_type

Line 4161: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

4157: UPDATE XLA_TRIAL_BALANCES tb
4158: SET PARTY_ID = p_new_party_id,
4159: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4160: LAST_UPDATE_DATE = sysdate,
4161: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4162: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4163: PROGRAM_UPDATE_DATE = sysdate,
4164: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4165: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 4162: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

4158: SET PARTY_ID = p_new_party_id,
4159: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4160: LAST_UPDATE_DATE = sysdate,
4161: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4162: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4163: PROGRAM_UPDATE_DATE = sysdate,
4164: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4165: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4166: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 4164: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

4160: LAST_UPDATE_DATE = sysdate,
4161: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4162: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4163: PROGRAM_UPDATE_DATE = sysdate,
4164: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4165: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4166: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4167: WHERE tb.PARTY_ID = p_old_party_id
4168: AND ( p_old_site_id IS NULL

Line 4165: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

4161: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4162: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4163: PROGRAM_UPDATE_DATE = sysdate,
4164: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4165: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4166: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4167: WHERE tb.PARTY_ID = p_old_party_id
4168: AND ( p_old_site_id IS NULL
4169: OR tb.PARTY_SITE_ID = p_old_site_id)

Line 4166: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

4162: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4163: PROGRAM_UPDATE_DATE = sysdate,
4164: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4165: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4166: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4167: WHERE tb.PARTY_ID = p_old_party_id
4168: AND ( p_old_site_id IS NULL
4169: OR tb.PARTY_SITE_ID = p_old_site_id)
4170: AND tb.PARTY_TYPE_CODE = p_party_type

Line 5646: p_request_id => XLA_ENVIRONMENT_PKG.g_req_id

5642: -- ---------------------------------------------------------------------
5643: -- create journal entries for the event: v_event_id for all the ledgers
5644: -- ---------------------------------------------------------------------
5645: create_work_table(
5646: p_request_id => XLA_ENVIRONMENT_PKG.g_req_id
5647: ,p_application_id => p_application_id
5648: ,p_event_id => v_event_id
5649: ,p_merge_date => v_merge_date
5650: ,p_merge_type => v_merge_type