DBA Data[Home] [Help]

APPS.PN_CREATE_ACC dependencies on FND_GLOBAL

Line 312: l_created_by := FND_GLOBAL.user_id;

308:
309: l_index_item := 1;
310: l_index_sched := 1;
311: l_prior_payment_schedule_id := -999;
312: l_created_by := FND_GLOBAL.user_id;
313: l_last_updated_by := FND_GLOBAL.USER_ID;
314: l_last_update_login := FND_GLOBAL.LOGIN_ID;
315: l_last_update_date := SYSDATE;
316: l_creation_date := SYSDATE;

Line 313: l_last_updated_by := FND_GLOBAL.USER_ID;

309: l_index_item := 1;
310: l_index_sched := 1;
311: l_prior_payment_schedule_id := -999;
312: l_created_by := FND_GLOBAL.user_id;
313: l_last_updated_by := FND_GLOBAL.USER_ID;
314: l_last_update_login := FND_GLOBAL.LOGIN_ID;
315: l_last_update_date := SYSDATE;
316: l_creation_date := SYSDATE;
317:

Line 314: l_last_update_login := FND_GLOBAL.LOGIN_ID;

310: l_index_sched := 1;
311: l_prior_payment_schedule_id := -999;
312: l_created_by := FND_GLOBAL.user_id;
313: l_last_updated_by := FND_GLOBAL.USER_ID;
314: l_last_update_login := FND_GLOBAL.LOGIN_ID;
315: l_last_update_date := SYSDATE;
316: l_creation_date := SYSDATE;
317:
318: FOR acct_rec IN c_ap_data (p_low_lease_id => l_low_lease_id,

Line 583: l_created_by := FND_GLOBAL.user_id;

579:
580: l_index_item := 1;
581: l_index_sched := 1;
582: l_prior_payment_schedule_id := -999;
583: l_created_by := FND_GLOBAL.user_id;
584: l_last_updated_by := FND_GLOBAL.USER_ID;
585: l_last_update_login := FND_GLOBAL.LOGIN_ID;
586: l_last_update_date := SYSDATE;
587: l_creation_date := SYSDATE;

Line 584: l_last_updated_by := FND_GLOBAL.USER_ID;

580: l_index_item := 1;
581: l_index_sched := 1;
582: l_prior_payment_schedule_id := -999;
583: l_created_by := FND_GLOBAL.user_id;
584: l_last_updated_by := FND_GLOBAL.USER_ID;
585: l_last_update_login := FND_GLOBAL.LOGIN_ID;
586: l_last_update_date := SYSDATE;
587: l_creation_date := SYSDATE;
588:

Line 585: l_last_update_login := FND_GLOBAL.LOGIN_ID;

581: l_index_sched := 1;
582: l_prior_payment_schedule_id := -999;
583: l_created_by := FND_GLOBAL.user_id;
584: l_last_updated_by := FND_GLOBAL.USER_ID;
585: l_last_update_login := FND_GLOBAL.LOGIN_ID;
586: l_last_update_date := SYSDATE;
587: l_creation_date := SYSDATE;
588:
589: FOR acct_rec IN c_ar_data (p_low_lease_id => l_low_lease_id,

Line 1076: l_created_by NUMBER := FND_GLOBAL.user_id;

1072: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1073: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1074: l_amt NUMBER;
1075: l_prior_payment_schedule_id NUMBER := -999;
1076: l_created_by NUMBER := FND_GLOBAL.user_id;
1077: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1078: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1079: l_last_update_date DATE := sysdate;
1080: l_creation_date DATE := SYSDATE;

Line 1077: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1073: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1074: l_amt NUMBER;
1075: l_prior_payment_schedule_id NUMBER := -999;
1076: l_created_by NUMBER := FND_GLOBAL.user_id;
1077: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1078: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1079: l_last_update_date DATE := sysdate;
1080: l_creation_date DATE := SYSDATE;
1081: l_msgBuff VARCHAR2 (2000) := NULL;

Line 1078: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1074: l_amt NUMBER;
1075: l_prior_payment_schedule_id NUMBER := -999;
1076: l_created_by NUMBER := FND_GLOBAL.user_id;
1077: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1078: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1079: l_last_update_date DATE := sysdate;
1080: l_creation_date DATE := SYSDATE;
1081: l_msgBuff VARCHAR2 (2000) := NULL;
1082: l_context VARCHAR2(2000);

Line 1435: FND_GLOBAL.conc_program_id,

1431: l_last_update_date,
1432: l_last_updated_by,
1433: l_last_update_login,
1434: SYSDATE,
1435: FND_GLOBAL.conc_program_id,
1436: FND_GLOBAL.prog_appl_id,
1437: FND_GLOBAL.conc_request_id,
1438: pn_mo_cache_utils.get_current_org_id,
1439: NULL

Line 1436: FND_GLOBAL.prog_appl_id,

1432: l_last_updated_by,
1433: l_last_update_login,
1434: SYSDATE,
1435: FND_GLOBAL.conc_program_id,
1436: FND_GLOBAL.prog_appl_id,
1437: FND_GLOBAL.conc_request_id,
1438: pn_mo_cache_utils.get_current_org_id,
1439: NULL
1440: )

Line 1437: FND_GLOBAL.conc_request_id,

1433: l_last_update_login,
1434: SYSDATE,
1435: FND_GLOBAL.conc_program_id,
1436: FND_GLOBAL.prog_appl_id,
1437: FND_GLOBAL.conc_request_id,
1438: pn_mo_cache_utils.get_current_org_id,
1439: NULL
1440: )
1441: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;

Line 1495: FND_GLOBAL.prog_appl_id,

1491: l_last_update_date,
1492: l_last_updated_by,
1493: l_last_update_login,
1494: SYSDATE,
1495: FND_GLOBAL.prog_appl_id,
1496: FND_GLOBAL.conc_program_id,
1497: FND_GLOBAL.conc_request_id,
1498: NULL
1499: )

Line 1496: FND_GLOBAL.conc_program_id,

1492: l_last_updated_by,
1493: l_last_update_login,
1494: SYSDATE,
1495: FND_GLOBAL.prog_appl_id,
1496: FND_GLOBAL.conc_program_id,
1497: FND_GLOBAL.conc_request_id,
1498: NULL
1499: )
1500: RETURNING AE_HEADER_ID INTO l_header_id;

Line 1497: FND_GLOBAL.conc_request_id,

1493: l_last_update_login,
1494: SYSDATE,
1495: FND_GLOBAL.prog_appl_id,
1496: FND_GLOBAL.conc_program_id,
1497: FND_GLOBAL.conc_request_id,
1498: NULL
1499: )
1500: RETURNING AE_HEADER_ID INTO l_header_id;
1501:

Line 1605: FND_GLOBAL.prog_appl_id,

1601: l_last_update_date,
1602: l_last_updated_by,
1603: l_last_update_login,
1604: SYSDATE,
1605: FND_GLOBAL.prog_appl_id,
1606: FND_GLOBAL.conc_program_id,
1607: FND_GLOBAL.conc_request_id
1608: );
1609:

Line 1606: FND_GLOBAL.conc_program_id,

1602: l_last_updated_by,
1603: l_last_update_login,
1604: SYSDATE,
1605: FND_GLOBAL.prog_appl_id,
1606: FND_GLOBAL.conc_program_id,
1607: FND_GLOBAL.conc_request_id
1608: );
1609:
1610: pnp_debug_pkg.log('Inserted into lines for Revenue');

Line 1607: FND_GLOBAL.conc_request_id

1603: l_last_update_login,
1604: SYSDATE,
1605: FND_GLOBAL.prog_appl_id,
1606: FND_GLOBAL.conc_program_id,
1607: FND_GLOBAL.conc_request_id
1608: );
1609:
1610: pnp_debug_pkg.log('Inserted into lines for Revenue');
1611:

Line 1718: FND_GLOBAL.prog_appl_id,

1714: l_last_update_date,
1715: l_last_updated_by,
1716: l_last_update_login,
1717: SYSDATE,
1718: FND_GLOBAL.prog_appl_id,
1719: FND_GLOBAL.conc_program_id,
1720: FND_GLOBAL.conc_request_id
1721: );
1722:

Line 1719: FND_GLOBAL.conc_program_id,

1715: l_last_updated_by,
1716: l_last_update_login,
1717: SYSDATE,
1718: FND_GLOBAL.prog_appl_id,
1719: FND_GLOBAL.conc_program_id,
1720: FND_GLOBAL.conc_request_id
1721: );
1722:
1723: pnp_debug_pkg.log('Inserted into lines for Accrued Asset');

Line 1720: FND_GLOBAL.conc_request_id

1716: l_last_update_login,
1717: SYSDATE,
1718: FND_GLOBAL.prog_appl_id,
1719: FND_GLOBAL.conc_program_id,
1720: FND_GLOBAL.conc_request_id
1721: );
1722:
1723: pnp_debug_pkg.log('Inserted into lines for Accrued Asset');
1724:

Line 1829: l_created_by NUMBER := FND_GLOBAL.user_id;

1825: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1826: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1827: l_amt NUMBER;
1828: l_prior_payment_schedule_id NUMBER := -999;
1829: l_created_by NUMBER := FND_GLOBAL.user_id;
1830: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1831: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1832: l_last_update_date DATE := sysdate;
1833: l_creation_date DATE := SYSDATE; --ASH

Line 1830: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1826: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1827: l_amt NUMBER;
1828: l_prior_payment_schedule_id NUMBER := -999;
1829: l_created_by NUMBER := FND_GLOBAL.user_id;
1830: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1831: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1832: l_last_update_date DATE := sysdate;
1833: l_creation_date DATE := SYSDATE; --ASH
1834: l_msgBuff VARCHAR2 (2000) := NULL;

Line 1831: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1827: l_amt NUMBER;
1828: l_prior_payment_schedule_id NUMBER := -999;
1829: l_created_by NUMBER := FND_GLOBAL.user_id;
1830: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1831: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1832: l_last_update_date DATE := sysdate;
1833: l_creation_date DATE := SYSDATE; --ASH
1834: l_msgBuff VARCHAR2 (2000) := NULL;
1835: l_context VARCHAR2(2000);

Line 2193: FND_GLOBAL.conc_program_id,

2189: l_last_update_date,
2190: l_last_updated_by,
2191: l_last_update_login,
2192: SYSDATE,
2193: FND_GLOBAL.conc_program_id,
2194: FND_GLOBAL.prog_appl_id,
2195: FND_GLOBAL.conc_request_id,
2196: pn_mo_cache_utils.get_current_org_id,
2197: NULL

Line 2194: FND_GLOBAL.prog_appl_id,

2190: l_last_updated_by,
2191: l_last_update_login,
2192: SYSDATE,
2193: FND_GLOBAL.conc_program_id,
2194: FND_GLOBAL.prog_appl_id,
2195: FND_GLOBAL.conc_request_id,
2196: pn_mo_cache_utils.get_current_org_id,
2197: NULL
2198: )

Line 2195: FND_GLOBAL.conc_request_id,

2191: l_last_update_login,
2192: SYSDATE,
2193: FND_GLOBAL.conc_program_id,
2194: FND_GLOBAL.prog_appl_id,
2195: FND_GLOBAL.conc_request_id,
2196: pn_mo_cache_utils.get_current_org_id,
2197: NULL
2198: )
2199: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;

Line 2255: FND_GLOBAL.prog_appl_id,

2251: l_last_update_date,
2252: l_last_updated_by,
2253: l_last_update_login,
2254: SYSDATE,
2255: FND_GLOBAL.prog_appl_id,
2256: FND_GLOBAL.conc_program_id,
2257: FND_GLOBAL.conc_request_id,
2258: NULL
2259: )

Line 2256: FND_GLOBAL.conc_program_id,

2252: l_last_updated_by,
2253: l_last_update_login,
2254: SYSDATE,
2255: FND_GLOBAL.prog_appl_id,
2256: FND_GLOBAL.conc_program_id,
2257: FND_GLOBAL.conc_request_id,
2258: NULL
2259: )
2260: RETURNING AE_HEADER_ID INTO l_header_id;

Line 2257: FND_GLOBAL.conc_request_id,

2253: l_last_update_login,
2254: SYSDATE,
2255: FND_GLOBAL.prog_appl_id,
2256: FND_GLOBAL.conc_program_id,
2257: FND_GLOBAL.conc_request_id,
2258: NULL
2259: )
2260: RETURNING AE_HEADER_ID INTO l_header_id;
2261:

Line 2365: FND_GLOBAL.prog_appl_id,

2361: l_last_update_date,
2362: l_last_updated_by,
2363: l_last_update_login,
2364: SYSDATE,
2365: FND_GLOBAL.prog_appl_id,
2366: FND_GLOBAL.conc_program_id,
2367: FND_GLOBAL.conc_request_id
2368: );
2369:

Line 2366: FND_GLOBAL.conc_program_id,

2362: l_last_updated_by,
2363: l_last_update_login,
2364: SYSDATE,
2365: FND_GLOBAL.prog_appl_id,
2366: FND_GLOBAL.conc_program_id,
2367: FND_GLOBAL.conc_request_id
2368: );
2369:
2370: pnp_debug_pkg.log('Inserted into lines for Expense');

Line 2367: FND_GLOBAL.conc_request_id

2363: l_last_update_login,
2364: SYSDATE,
2365: FND_GLOBAL.prog_appl_id,
2366: FND_GLOBAL.conc_program_id,
2367: FND_GLOBAL.conc_request_id
2368: );
2369:
2370: pnp_debug_pkg.log('Inserted into lines for Expense');
2371:

Line 2480: FND_GLOBAL.prog_appl_id,

2476: l_last_update_date,
2477: l_last_updated_by,
2478: l_last_update_login,
2479: SYSDATE,
2480: FND_GLOBAL.prog_appl_id,
2481: FND_GLOBAL.conc_program_id,
2482: FND_GLOBAL.conc_request_id
2483: );
2484:

Line 2481: FND_GLOBAL.conc_program_id,

2477: l_last_updated_by,
2478: l_last_update_login,
2479: SYSDATE,
2480: FND_GLOBAL.prog_appl_id,
2481: FND_GLOBAL.conc_program_id,
2482: FND_GLOBAL.conc_request_id
2483: );
2484:
2485: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');

Line 2482: FND_GLOBAL.conc_request_id

2478: l_last_update_login,
2479: SYSDATE,
2480: FND_GLOBAL.prog_appl_id,
2481: FND_GLOBAL.conc_program_id,
2482: FND_GLOBAL.conc_request_id
2483: );
2484:
2485: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');
2486: