DBA Data[Home] [Help]

APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on FND_GLOBAL

Line 1569: l_user_id := FND_GLOBAL.user_id;

1565: l_acctg_date := FND_DATE.CANONICAL_TO_DATE(P_acctg_date);
1566: --
1567: l_debug_info := 'Get Profiles';
1568:
1569: l_user_id := FND_GLOBAL.user_id;
1570: l_request_id := FND_GLOBAL.conc_request_id;
1571: l_login_id := FND_GLOBAL.login_id;
1572: --
1573: l_debug_info := 'Get FA Book ledger id based on FA API';

Line 1570: l_request_id := FND_GLOBAL.conc_request_id;

1566: --
1567: l_debug_info := 'Get Profiles';
1568:
1569: l_user_id := FND_GLOBAL.user_id;
1570: l_request_id := FND_GLOBAL.conc_request_id;
1571: l_login_id := FND_GLOBAL.login_id;
1572: --
1573: l_debug_info := 'Get FA Book ledger id based on FA API';
1574: --

Line 1571: l_login_id := FND_GLOBAL.login_id;

1567: l_debug_info := 'Get Profiles';
1568:
1569: l_user_id := FND_GLOBAL.user_id;
1570: l_request_id := FND_GLOBAL.conc_request_id;
1571: l_login_id := FND_GLOBAL.login_id;
1572: --
1573: l_debug_info := 'Get FA Book ledger id based on FA API';
1574: --
1575: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1641: APID.program_application_id = FND_GLOBAL.prog_appl_id,

1637: --
1638: UPDATE ap_invoice_distributions_all APID
1639: SET APID.assets_addition_flag = 'N',
1640: APID.program_update_date = SYSDATE,
1641: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1642: APID.program_id = FND_GLOBAL.conc_program_id,
1643: APID.request_id = l_request_id
1644: WHERE APID.assets_addition_flag = 'U'
1645: AND APID.org_id IN (SELECT org_id

Line 1642: APID.program_id = FND_GLOBAL.conc_program_id,

1638: UPDATE ap_invoice_distributions_all APID
1639: SET APID.assets_addition_flag = 'N',
1640: APID.program_update_date = SYSDATE,
1641: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1642: APID.program_id = FND_GLOBAL.conc_program_id,
1643: APID.request_id = l_request_id
1644: WHERE APID.assets_addition_flag = 'U'
1645: AND APID.org_id IN (SELECT org_id
1646: FROM ap_system_parameters)

Line 1778: APID.program_application_id = FND_GLOBAL.prog_appl_id,

1774: /* BUG 8236268
1775: UPDATE ap_invoice_distributions_all APID
1776: SET APID.assets_addition_flag = 'Y',
1777: APID.program_update_date = SYSDATE,
1778: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1779: APID.program_id = FND_GLOBAL.conc_program_id,
1780: APID.request_id = FND_GLOBAL.conc_request_id,
1781: APID.asset_book_type_code = P_bt_code
1782: WHERE APID.invoice_distribution_id IN

Line 1779: APID.program_id = FND_GLOBAL.conc_program_id,

1775: UPDATE ap_invoice_distributions_all APID
1776: SET APID.assets_addition_flag = 'Y',
1777: APID.program_update_date = SYSDATE,
1778: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1779: APID.program_id = FND_GLOBAL.conc_program_id,
1780: APID.request_id = FND_GLOBAL.conc_request_id,
1781: APID.asset_book_type_code = P_bt_code
1782: WHERE APID.invoice_distribution_id IN
1783: (SELECT FMAG.invoice_distribution_id

Line 1780: APID.request_id = FND_GLOBAL.conc_request_id,

1776: SET APID.assets_addition_flag = 'Y',
1777: APID.program_update_date = SYSDATE,
1778: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1779: APID.program_id = FND_GLOBAL.conc_program_id,
1780: APID.request_id = FND_GLOBAL.conc_request_id,
1781: APID.asset_book_type_code = P_bt_code
1782: WHERE APID.invoice_distribution_id IN
1783: (SELECT FMAG.invoice_distribution_id
1784: FROM fa_mass_additions_gt FMAG

Line 1806: sq.program_application_id = fnd_global.prog_appl_id,

1802: AND fmag.ledger_id = l_ledger_id
1803: AND apid.assets_addition_flag = 'U') sq
1804: SET sq.assets_addition_flag = 'Y',
1805: sq.program_update_date = sysdate,
1806: sq.program_application_id = fnd_global.prog_appl_id,
1807: sq.program_id = fnd_global.conc_program_id,
1808: sq.request_id = fnd_global.conc_request_id,
1809: sq.asset_book_type_code = sq.book_type_code;
1810: --

Line 1807: sq.program_id = fnd_global.conc_program_id,

1803: AND apid.assets_addition_flag = 'U') sq
1804: SET sq.assets_addition_flag = 'Y',
1805: sq.program_update_date = sysdate,
1806: sq.program_application_id = fnd_global.prog_appl_id,
1807: sq.program_id = fnd_global.conc_program_id,
1808: sq.request_id = fnd_global.conc_request_id,
1809: sq.asset_book_type_code = sq.book_type_code;
1810: --
1811: l_count := SQL%ROWCOUNT;

Line 1808: sq.request_id = fnd_global.conc_request_id,

1804: SET sq.assets_addition_flag = 'Y',
1805: sq.program_update_date = sysdate,
1806: sq.program_application_id = fnd_global.prog_appl_id,
1807: sq.program_id = fnd_global.conc_program_id,
1808: sq.request_id = fnd_global.conc_request_id,
1809: sq.asset_book_type_code = sq.book_type_code;
1810: --
1811: l_count := SQL%ROWCOUNT;
1812: --

Line 1823: APID.program_application_id = FND_GLOBAL.prog_appl_id,

1819: --
1820: UPDATE ap_invoice_distributions_all APID
1821: SET APID.assets_addition_flag = 'N',
1822: APID.program_update_date = SYSDATE,
1823: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1824: APID.program_id = FND_GLOBAL.conc_program_id,
1825: APID.request_id = FND_GLOBAL.conc_request_id,
1826: APID.asset_book_type_code = P_bt_code
1827: WHERE APID.invoice_distribution_id IN

Line 1824: APID.program_id = FND_GLOBAL.conc_program_id,

1820: UPDATE ap_invoice_distributions_all APID
1821: SET APID.assets_addition_flag = 'N',
1822: APID.program_update_date = SYSDATE,
1823: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1824: APID.program_id = FND_GLOBAL.conc_program_id,
1825: APID.request_id = FND_GLOBAL.conc_request_id,
1826: APID.asset_book_type_code = P_bt_code
1827: WHERE APID.invoice_distribution_id IN
1828: (SELECT FMAG.invoice_distribution_id

Line 1825: APID.request_id = FND_GLOBAL.conc_request_id,

1821: SET APID.assets_addition_flag = 'N',
1822: APID.program_update_date = SYSDATE,
1823: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1824: APID.program_id = FND_GLOBAL.conc_program_id,
1825: APID.request_id = FND_GLOBAL.conc_request_id,
1826: APID.asset_book_type_code = P_bt_code
1827: WHERE APID.invoice_distribution_id IN
1828: (SELECT FMAG.invoice_distribution_id
1829: FROM fa_mass_additions_gt FMAG