APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_ENVIRONMENT_PKG

Line 536: XLA_ENVIRONMENT_PKG.g_usr_id,

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

Line 538: XLA_ENVIRONMENT_PKG.g_usr_id,

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

Line 539: XLA_ENVIRONMENT_PKG.g_login_id)

535: sysdate,
536: XLA_ENVIRONMENT_PKG.g_usr_id,
537: sysdate,
538: XLA_ENVIRONMENT_PKG.g_usr_id,
539: XLA_ENVIRONMENT_PKG.g_login_id)
540: RETURNING ENTITY_ID INTO v_entity_id;
541: -- It's a new transaciton entity, so the maximum event number must be 0
542: -- v_max_event_number := 0; commented for bug 9439643
543:

Line 640: XLA_ENVIRONMENT_PKG.g_usr_id,

636: p_third_party_merge_date,
637: 'U',
638: 'U',
639: sysdate,
640: XLA_ENVIRONMENT_PKG.g_usr_id,
641: sysdate,
642: XLA_ENVIRONMENT_PKG.g_usr_id,
643: XLA_ENVIRONMENT_PKG.g_login_id,
644: sysdate,

Line 642: XLA_ENVIRONMENT_PKG.g_usr_id,

638: 'U',
639: sysdate,
640: XLA_ENVIRONMENT_PKG.g_usr_id,
641: sysdate,
642: XLA_ENVIRONMENT_PKG.g_usr_id,
643: XLA_ENVIRONMENT_PKG.g_login_id,
644: sysdate,
645: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
646: XLA_ENVIRONMENT_PKG.g_prog_id,

Line 643: XLA_ENVIRONMENT_PKG.g_login_id,

639: sysdate,
640: XLA_ENVIRONMENT_PKG.g_usr_id,
641: sysdate,
642: XLA_ENVIRONMENT_PKG.g_usr_id,
643: XLA_ENVIRONMENT_PKG.g_login_id,
644: sysdate,
645: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
646: XLA_ENVIRONMENT_PKG.g_prog_id,
647: XLA_ENVIRONMENT_PKG.g_req_id,

Line 645: XLA_ENVIRONMENT_PKG.g_prog_appl_id,

641: sysdate,
642: XLA_ENVIRONMENT_PKG.g_usr_id,
643: XLA_ENVIRONMENT_PKG.g_login_id,
644: sysdate,
645: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
646: XLA_ENVIRONMENT_PKG.g_prog_id,
647: XLA_ENVIRONMENT_PKG.g_req_id,
648: p_original_third_party_id,
649: p_original_site_id,

Line 646: XLA_ENVIRONMENT_PKG.g_prog_id,

642: XLA_ENVIRONMENT_PKG.g_usr_id,
643: XLA_ENVIRONMENT_PKG.g_login_id,
644: sysdate,
645: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
646: XLA_ENVIRONMENT_PKG.g_prog_id,
647: XLA_ENVIRONMENT_PKG.g_req_id,
648: p_original_third_party_id,
649: p_original_site_id,
650: p_new_third_party_id,

Line 647: XLA_ENVIRONMENT_PKG.g_req_id,

643: XLA_ENVIRONMENT_PKG.g_login_id,
644: sysdate,
645: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
646: XLA_ENVIRONMENT_PKG.g_prog_id,
647: XLA_ENVIRONMENT_PKG.g_req_id,
648: p_original_third_party_id,
649: p_original_site_id,
650: p_new_third_party_id,
651: p_new_site_id,

Line 688: XLA_ENVIRONMENT_PKG.g_usr_id,

684: gt.TO_VALUE,
685: v_event_id,
686: gt.CHART_OF_ACCOUNTS_ID,
687: sysdate,
688: XLA_ENVIRONMENT_PKG.g_usr_id,
689: sysdate,
690: XLA_ENVIRONMENT_PKG.g_usr_id,
691: XLA_ENVIRONMENT_PKG.g_login_id,
692: sysdate,

Line 690: XLA_ENVIRONMENT_PKG.g_usr_id,

686: gt.CHART_OF_ACCOUNTS_ID,
687: sysdate,
688: XLA_ENVIRONMENT_PKG.g_usr_id,
689: sysdate,
690: XLA_ENVIRONMENT_PKG.g_usr_id,
691: XLA_ENVIRONMENT_PKG.g_login_id,
692: sysdate,
693: XLA_ENVIRONMENT_PKG.g_prog_appl_id
694: FROM XLA_LEDGER_RELATIONSHIPS_V rs,

Line 691: XLA_ENVIRONMENT_PKG.g_login_id,

687: sysdate,
688: XLA_ENVIRONMENT_PKG.g_usr_id,
689: sysdate,
690: XLA_ENVIRONMENT_PKG.g_usr_id,
691: XLA_ENVIRONMENT_PKG.g_login_id,
692: sysdate,
693: XLA_ENVIRONMENT_PKG.g_prog_appl_id
694: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
695: XLA_MERGE_SEG_MAPS_GT gt,

Line 693: XLA_ENVIRONMENT_PKG.g_prog_appl_id

689: sysdate,
690: XLA_ENVIRONMENT_PKG.g_usr_id,
691: XLA_ENVIRONMENT_PKG.g_login_id,
692: sysdate,
693: XLA_ENVIRONMENT_PKG.g_prog_appl_id
694: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
695: XLA_MERGE_SEG_MAPS_GT gt,
696: GL_LEDGERS gl
697: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'

Line 746: XLA_ENVIRONMENT_PKG.g_usr_id,

742: gt.SOURCE_ID_CHAR_3,
743: gt.SOURCE_ID_CHAR_4,
744: gt.VALUATION_METHOD,
745: sysdate,
746: XLA_ENVIRONMENT_PKG.g_usr_id,
747: sysdate,
748: XLA_ENVIRONMENT_PKG.g_usr_id,
749: XLA_ENVIRONMENT_PKG.g_login_id,
750: sysdate,

Line 748: XLA_ENVIRONMENT_PKG.g_usr_id,

744: gt.VALUATION_METHOD,
745: sysdate,
746: XLA_ENVIRONMENT_PKG.g_usr_id,
747: sysdate,
748: XLA_ENVIRONMENT_PKG.g_usr_id,
749: XLA_ENVIRONMENT_PKG.g_login_id,
750: sysdate,
751: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
752: XLA_ENVIRONMENT_PKG.g_prog_id,

Line 749: XLA_ENVIRONMENT_PKG.g_login_id,

745: sysdate,
746: XLA_ENVIRONMENT_PKG.g_usr_id,
747: sysdate,
748: XLA_ENVIRONMENT_PKG.g_usr_id,
749: XLA_ENVIRONMENT_PKG.g_login_id,
750: sysdate,
751: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
752: XLA_ENVIRONMENT_PKG.g_prog_id,
753: XLA_ENVIRONMENT_PKG.g_req_id

Line 751: XLA_ENVIRONMENT_PKG.g_prog_appl_id,

747: sysdate,
748: XLA_ENVIRONMENT_PKG.g_usr_id,
749: XLA_ENVIRONMENT_PKG.g_login_id,
750: sysdate,
751: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
752: XLA_ENVIRONMENT_PKG.g_prog_id,
753: XLA_ENVIRONMENT_PKG.g_req_id
754: FROM XLA_EVENTS_GT gt,
755: XLA_TRANSACTION_ENTITIES ent

Line 752: XLA_ENVIRONMENT_PKG.g_prog_id,

748: XLA_ENVIRONMENT_PKG.g_usr_id,
749: XLA_ENVIRONMENT_PKG.g_login_id,
750: sysdate,
751: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
752: XLA_ENVIRONMENT_PKG.g_prog_id,
753: XLA_ENVIRONMENT_PKG.g_req_id
754: FROM XLA_EVENTS_GT gt,
755: XLA_TRANSACTION_ENTITIES ent
756: WHERE gt.APPLICATION_ID = p_application_id

Line 753: XLA_ENVIRONMENT_PKG.g_req_id

749: XLA_ENVIRONMENT_PKG.g_login_id,
750: sysdate,
751: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
752: XLA_ENVIRONMENT_PKG.g_prog_id,
753: XLA_ENVIRONMENT_PKG.g_req_id
754: FROM XLA_EVENTS_GT gt,
755: XLA_TRANSACTION_ENTITIES ent
756: WHERE gt.APPLICATION_ID = p_application_id
757: AND gt.LEDGER_ID = v_ledger_id

Line 1580: , xla_environment_pkg.g_Usr_Id

1576: , hed.product_rule_code
1577: , hed.product_rule_version
1578: , hed.description
1579: , TRUNC(SYSDATE)
1580: , xla_environment_pkg.g_Usr_Id
1581: , TRUNC(SYSDATE)
1582: , xla_environment_pkg.g_Usr_Id
1583: , xla_environment_pkg.g_Login_Id
1584: , hed.doc_sequence_id

Line 1582: , xla_environment_pkg.g_Usr_Id

1578: , hed.description
1579: , TRUNC(SYSDATE)
1580: , xla_environment_pkg.g_Usr_Id
1581: , TRUNC(SYSDATE)
1582: , xla_environment_pkg.g_Usr_Id
1583: , xla_environment_pkg.g_Login_Id
1584: , hed.doc_sequence_id
1585: , hed.doc_sequence_value
1586: , hed.doc_category_code

Line 1583: , xla_environment_pkg.g_Login_Id

1579: , TRUNC(SYSDATE)
1580: , xla_environment_pkg.g_Usr_Id
1581: , TRUNC(SYSDATE)
1582: , xla_environment_pkg.g_Usr_Id
1583: , xla_environment_pkg.g_Login_Id
1584: , hed.doc_sequence_id
1585: , hed.doc_sequence_value
1586: , hed.doc_category_code
1587: , TRUNC(SYSDATE)

Line 1588: , xla_environment_pkg.g_Prog_Appl_Id

1584: , hed.doc_sequence_id
1585: , hed.doc_sequence_value
1586: , hed.doc_category_code
1587: , TRUNC(SYSDATE)
1588: , xla_environment_pkg.g_Prog_Appl_Id
1589: , xla_environment_pkg.g_Prog_Id
1590: , xla_environment_pkg.g_req_Id
1591: , CASE hed.balance_type_code
1592: WHEN 'B' THEN hed.budget_version_id

Line 1589: , xla_environment_pkg.g_Prog_Id

1585: , hed.doc_sequence_value
1586: , hed.doc_category_code
1587: , TRUNC(SYSDATE)
1588: , xla_environment_pkg.g_Prog_Appl_Id
1589: , xla_environment_pkg.g_Prog_Id
1590: , xla_environment_pkg.g_req_Id
1591: , CASE hed.balance_type_code
1592: WHEN 'B' THEN hed.budget_version_id
1593: ELSE NULL

Line 1590: , xla_environment_pkg.g_req_Id

1586: , hed.doc_category_code
1587: , TRUNC(SYSDATE)
1588: , xla_environment_pkg.g_Prog_Appl_Id
1589: , xla_environment_pkg.g_Prog_Id
1590: , xla_environment_pkg.g_req_Id
1591: , CASE hed.balance_type_code
1592: WHEN 'B' THEN hed.budget_version_id
1593: ELSE NULL
1594: END

Line 2214: , XLA_ENVIRONMENT_PKG.g_login_id last_update_login

2210: END
2211: END
2212: END unrounded_entered_dr
2213: , sysdate last_update_date
2214: , XLA_ENVIRONMENT_PKG.g_login_id last_update_login
2215: , party_id
2216: , party_site_id
2217: , party_type_code
2218: , sum(statistical_amount) statistical_amount

Line 2220: , XLA_ENVIRONMENT_PKG.g_login_id created_by

2216: , party_site_id
2217: , party_type_code
2218: , sum(statistical_amount) statistical_amount
2219: , ussgl_transaction_code
2220: , XLA_ENVIRONMENT_PKG.g_login_id created_by
2221: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by
2222: , jgzz_recon_ref
2223: , sysdate program_update_date
2224: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id

Line 2221: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by

2217: , party_type_code
2218: , sum(statistical_amount) statistical_amount
2219: , ussgl_transaction_code
2220: , XLA_ENVIRONMENT_PKG.g_login_id created_by
2221: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by
2222: , jgzz_recon_ref
2223: , sysdate program_update_date
2224: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id
2225: , XLA_ENVIRONMENT_PKG.g_prog_id program_id

Line 2224: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id

2220: , XLA_ENVIRONMENT_PKG.g_login_id created_by
2221: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by
2222: , jgzz_recon_ref
2223: , sysdate program_update_date
2224: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id
2225: , XLA_ENVIRONMENT_PKG.g_prog_id program_id
2226: , p_application_id application_id
2227: , XLA_ENVIRONMENT_PKG.g_req_id request_id
2228: , 'XLAJEL' gl_sl_link_table

Line 2225: , XLA_ENVIRONMENT_PKG.g_prog_id program_id

2221: , XLA_ENVIRONMENT_PKG.g_login_id last_updated_by
2222: , jgzz_recon_ref
2223: , sysdate program_update_date
2224: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id
2225: , XLA_ENVIRONMENT_PKG.g_prog_id program_id
2226: , p_application_id application_id
2227: , XLA_ENVIRONMENT_PKG.g_req_id request_id
2228: , 'XLAJEL' gl_sl_link_table
2229: , business_class_code -- 4336173

Line 2227: , XLA_ENVIRONMENT_PKG.g_req_id request_id

2223: , sysdate program_update_date
2224: , XLA_ENVIRONMENT_PKG.g_prog_appl_id program_application_id
2225: , XLA_ENVIRONMENT_PKG.g_prog_id program_id
2226: , p_application_id application_id
2227: , XLA_ENVIRONMENT_PKG.g_req_id request_id
2228: , 'XLAJEL' gl_sl_link_table
2229: , business_class_code -- 4336173
2230: , mpa_accrual_entry_flag -- 4262811
2231: , encumbrance_type_id -- 4458381 Public Sector Enh

Line 2243: , XLA_ENVIRONMENT_PKG.g_login_id

2239: GROUP BY lin.ae_header_id
2240: , ae_line_num
2241: , header_num -- 4262811c MPA reversal lines
2242: , sysdate
2243: , XLA_ENVIRONMENT_PKG.g_login_id
2244: , XLA_ENVIRONMENT_PKG.g_prog_appl_id
2245: , XLA_ENVIRONMENT_PKG.g_prog_id
2246: , XLA_ENVIRONMENT_PKG.g_req_id
2247: , p_application_id

Line 2244: , XLA_ENVIRONMENT_PKG.g_prog_appl_id

2240: , ae_line_num
2241: , header_num -- 4262811c MPA reversal lines
2242: , sysdate
2243: , XLA_ENVIRONMENT_PKG.g_login_id
2244: , XLA_ENVIRONMENT_PKG.g_prog_appl_id
2245: , XLA_ENVIRONMENT_PKG.g_prog_id
2246: , XLA_ENVIRONMENT_PKG.g_req_id
2247: , p_application_id
2248: , accounting_class_code

Line 2245: , XLA_ENVIRONMENT_PKG.g_prog_id

2241: , header_num -- 4262811c MPA reversal lines
2242: , sysdate
2243: , XLA_ENVIRONMENT_PKG.g_login_id
2244: , XLA_ENVIRONMENT_PKG.g_prog_appl_id
2245: , XLA_ENVIRONMENT_PKG.g_prog_id
2246: , XLA_ENVIRONMENT_PKG.g_req_id
2247: , p_application_id
2248: , accounting_class_code
2249: , event_class_code

Line 2246: , XLA_ENVIRONMENT_PKG.g_req_id

2242: , sysdate
2243: , XLA_ENVIRONMENT_PKG.g_login_id
2244: , XLA_ENVIRONMENT_PKG.g_prog_appl_id
2245: , XLA_ENVIRONMENT_PKG.g_prog_id
2246: , XLA_ENVIRONMENT_PKG.g_req_id
2247: , p_application_id
2248: , accounting_class_code
2249: , event_class_code
2250: , event_type_code

Line 3925: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

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

Line 3926: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

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

Line 3928: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

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

Line 3929: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

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

Line 3930: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

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

Line 3971: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

3967: , SUBSTRB(DESCRIPTION, 0,
3968: 1995 - LENGTHB(v_aeh_desc))
3969: || ' ' || v_aeh_desc),
3970: LAST_UPDATE_DATE = sysdate,
3971: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3972: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3973: PROGRAM_UPDATE_DATE = sysdate,
3974: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3975: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 3972: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

3968: 1995 - LENGTHB(v_aeh_desc))
3969: || ' ' || v_aeh_desc),
3970: LAST_UPDATE_DATE = sysdate,
3971: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3972: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3973: PROGRAM_UPDATE_DATE = sysdate,
3974: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3975: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3976: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 3974: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

3970: LAST_UPDATE_DATE = sysdate,
3971: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3972: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3973: PROGRAM_UPDATE_DATE = sysdate,
3974: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3975: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3976: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
3977: WHERE aeh.APPLICATION_ID = p_application_id
3978: AND aeh.LEDGER_ID = p_array_ledger_id(i)

Line 3975: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

3971: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
3972: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3973: PROGRAM_UPDATE_DATE = sysdate,
3974: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3975: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3976: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
3977: WHERE aeh.APPLICATION_ID = p_application_id
3978: AND aeh.LEDGER_ID = p_array_ledger_id(i)
3979: AND ((aeh.accounting_entry_status_code = 'F' AND

Line 3976: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

3972: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
3973: PROGRAM_UPDATE_DATE = sysdate,
3974: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
3975: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
3976: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
3977: WHERE aeh.APPLICATION_ID = p_application_id
3978: AND aeh.LEDGER_ID = p_array_ledger_id(i)
3979: AND ((aeh.accounting_entry_status_code = 'F' AND
3980: p_array_merge_option(i) = 'CHANGE')

Line 4050: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

4046: , SUBSTRB(DESCRIPTION, 0,
4047: 1995 - LENGTHB(p_line_desc))
4048: || ' ' || p_line_desc),
4049: LAST_UPDATE_DATE = sysdate,
4050: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4051: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4052: PROGRAM_UPDATE_DATE = sysdate,
4053: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4054: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 4051: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

4047: 1995 - LENGTHB(p_line_desc))
4048: || ' ' || p_line_desc),
4049: LAST_UPDATE_DATE = sysdate,
4050: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4051: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4052: PROGRAM_UPDATE_DATE = sysdate,
4053: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4054: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4055: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 4053: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

4049: LAST_UPDATE_DATE = sysdate,
4050: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4051: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4052: PROGRAM_UPDATE_DATE = sysdate,
4053: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4054: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4055: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4056: WHERE ael.PARTY_ID = p_old_party_id
4057: AND ( p_old_site_id IS NULL

Line 4054: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

4050: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4051: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4052: PROGRAM_UPDATE_DATE = sysdate,
4053: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4054: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4055: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4056: WHERE ael.PARTY_ID = p_old_party_id
4057: AND ( p_old_site_id IS NULL
4058: OR ael.PARTY_SITE_ID = p_old_site_id)

Line 4055: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

4051: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4052: PROGRAM_UPDATE_DATE = sysdate,
4053: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4054: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4055: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4056: WHERE ael.PARTY_ID = p_old_party_id
4057: AND ( p_old_site_id IS NULL
4058: OR ael.PARTY_SITE_ID = p_old_site_id)
4059: AND ael.PARTY_TYPE_CODE = p_party_type

Line 4103: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

4099: UPDATE XLA_TRIAL_BALANCES tb
4100: SET PARTY_ID = p_new_party_id,
4101: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4102: LAST_UPDATE_DATE = sysdate,
4103: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4104: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4105: PROGRAM_UPDATE_DATE = sysdate,
4106: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4107: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 4104: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

4100: SET PARTY_ID = p_new_party_id,
4101: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4102: LAST_UPDATE_DATE = sysdate,
4103: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4104: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4105: PROGRAM_UPDATE_DATE = sysdate,
4106: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4107: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4108: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 4106: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

4102: LAST_UPDATE_DATE = sysdate,
4103: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4104: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4105: PROGRAM_UPDATE_DATE = sysdate,
4106: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4107: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4108: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4109: WHERE tb.PARTY_ID = p_old_party_id
4110: AND ( p_old_site_id IS NULL

Line 4107: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

4103: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4104: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4105: PROGRAM_UPDATE_DATE = sysdate,
4106: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4107: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4108: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4109: WHERE tb.PARTY_ID = p_old_party_id
4110: AND ( p_old_site_id IS NULL
4111: OR tb.PARTY_SITE_ID = p_old_site_id)

Line 4108: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

4104: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4105: PROGRAM_UPDATE_DATE = sysdate,
4106: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4107: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4108: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4109: WHERE tb.PARTY_ID = p_old_party_id
4110: AND ( p_old_site_id IS NULL
4111: OR tb.PARTY_SITE_ID = p_old_site_id)
4112: AND tb.PARTY_TYPE_CODE = p_party_type

Line 4159: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

4155: , SUBSTRB(DESCRIPTION, 0,
4156: 1995 - LENGTHB(p_line_desc))
4157: || ' ' || p_line_desc),
4158: LAST_UPDATE_DATE = sysdate,
4159: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4160: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4161: PROGRAM_UPDATE_DATE = sysdate,
4162: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4163: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 4160: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

4156: 1995 - LENGTHB(p_line_desc))
4157: || ' ' || p_line_desc),
4158: LAST_UPDATE_DATE = sysdate,
4159: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4160: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4161: PROGRAM_UPDATE_DATE = sysdate,
4162: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4163: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4164: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 4162: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

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

Line 4163: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

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

Line 4164: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

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

Line 4206: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,

4202: UPDATE XLA_TRIAL_BALANCES tb
4203: SET PARTY_ID = p_new_party_id,
4204: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4205: LAST_UPDATE_DATE = sysdate,
4206: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4207: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4208: PROGRAM_UPDATE_DATE = sysdate,
4209: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4210: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

Line 4207: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,

4203: SET PARTY_ID = p_new_party_id,
4204: PARTY_SITE_ID = NVL(p_new_site_id, PARTY_SITE_ID),
4205: LAST_UPDATE_DATE = sysdate,
4206: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4207: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4208: PROGRAM_UPDATE_DATE = sysdate,
4209: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4210: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4211: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

Line 4209: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,

4205: LAST_UPDATE_DATE = sysdate,
4206: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4207: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4208: PROGRAM_UPDATE_DATE = sysdate,
4209: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4210: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4211: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4212: WHERE tb.PARTY_ID = p_old_party_id
4213: AND ( p_old_site_id IS NULL

Line 4210: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,

4206: LAST_UPDATED_BY = XLA_ENVIRONMENT_PKG.g_usr_id,
4207: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4208: PROGRAM_UPDATE_DATE = sysdate,
4209: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4210: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4211: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4212: WHERE tb.PARTY_ID = p_old_party_id
4213: AND ( p_old_site_id IS NULL
4214: OR tb.PARTY_SITE_ID = p_old_site_id)

Line 4211: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id

4207: LAST_UPDATE_LOGIN = XLA_ENVIRONMENT_PKG.g_login_id,
4208: PROGRAM_UPDATE_DATE = sysdate,
4209: PROGRAM_APPLICATION_ID = XLA_ENVIRONMENT_PKG.g_prog_appl_id,
4210: PROGRAM_ID = XLA_ENVIRONMENT_PKG.g_prog_id,
4211: REQUEST_ID = XLA_ENVIRONMENT_PKG.g_req_id
4212: WHERE tb.PARTY_ID = p_old_party_id
4213: AND ( p_old_site_id IS NULL
4214: OR tb.PARTY_SITE_ID = p_old_site_id)
4215: AND tb.PARTY_TYPE_CODE = p_party_type

Line 5811: p_request_id => XLA_ENVIRONMENT_PKG.g_req_id

5807: -- ---------------------------------------------------------------------
5808: -- create journal entries for the event: v_event_id for all the ledgers
5809: -- ---------------------------------------------------------------------
5810: create_work_table(
5811: p_request_id => XLA_ENVIRONMENT_PKG.g_req_id
5812: ,p_application_id => p_application_id
5813: ,p_event_id => v_event_id
5814: ,p_merge_date => v_merge_date
5815: ,p_merge_type => v_merge_type