DBA Data[Home] [Help]

APPS.PN_CREATE_ACC dependencies on FND_GLOBAL

Line 511: FND_GLOBAL.prog_appl_id,

507: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
508: sysdate,
509: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
510: sysdate,
511: FND_GLOBAL.prog_appl_id,
512: FND_GLOBAL.conc_program_id,
513: FND_GLOBAL.conc_request_id);
514:
515: END LOOP;

Line 512: FND_GLOBAL.conc_program_id,

508: sysdate,
509: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
510: sysdate,
511: FND_GLOBAL.prog_appl_id,
512: FND_GLOBAL.conc_program_id,
513: FND_GLOBAL.conc_request_id);
514:
515: END LOOP;
516:

Line 513: FND_GLOBAL.conc_request_id);

509: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
510: sysdate,
511: FND_GLOBAL.prog_appl_id,
512: FND_GLOBAL.conc_program_id,
513: FND_GLOBAL.conc_request_id);
514:
515: END LOOP;
516:
517: l_amt := 0;

Line 594: FND_GLOBAL.prog_appl_id,

590: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
591: sysdate,
592: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
593: sysdate,
594: FND_GLOBAL.prog_appl_id,
595: FND_GLOBAL.conc_program_id,
596: FND_GLOBAL.conc_request_id);
597:
598: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');

Line 595: FND_GLOBAL.conc_program_id,

591: sysdate,
592: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
593: sysdate,
594: FND_GLOBAL.prog_appl_id,
595: FND_GLOBAL.conc_program_id,
596: FND_GLOBAL.conc_request_id);
597:
598: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');
599:

Line 596: FND_GLOBAL.conc_request_id);

592: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
593: sysdate,
594: FND_GLOBAL.prog_appl_id,
595: FND_GLOBAL.conc_program_id,
596: FND_GLOBAL.conc_request_id);
597:
598: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');
599:
600: END LOOP;

Line 736: l_created_by := FND_GLOBAL.user_id;

732:
733: l_index_item := 1;
734: l_index_sched := 1;
735: l_prior_payment_schedule_id := -999;
736: l_created_by := FND_GLOBAL.user_id;
737: l_last_updated_by := FND_GLOBAL.USER_ID;
738: l_last_update_login := FND_GLOBAL.LOGIN_ID;
739: l_last_update_date := SYSDATE;
740: l_creation_date := SYSDATE;

Line 737: l_last_updated_by := FND_GLOBAL.USER_ID;

733: l_index_item := 1;
734: l_index_sched := 1;
735: l_prior_payment_schedule_id := -999;
736: l_created_by := FND_GLOBAL.user_id;
737: l_last_updated_by := FND_GLOBAL.USER_ID;
738: l_last_update_login := FND_GLOBAL.LOGIN_ID;
739: l_last_update_date := SYSDATE;
740: l_creation_date := SYSDATE;
741:

Line 738: l_last_update_login := FND_GLOBAL.LOGIN_ID;

734: l_index_sched := 1;
735: l_prior_payment_schedule_id := -999;
736: l_created_by := FND_GLOBAL.user_id;
737: l_last_updated_by := FND_GLOBAL.USER_ID;
738: l_last_update_login := FND_GLOBAL.LOGIN_ID;
739: l_last_update_date := SYSDATE;
740: l_creation_date := SYSDATE;
741:
742: FOR acct_rec IN c_ap_data (p_low_lease_id => l_low_lease_id,

Line 1030: l_created_by := FND_GLOBAL.user_id;

1026:
1027: l_index_item := 1;
1028: l_index_sched := 1;
1029: l_prior_payment_schedule_id := -999;
1030: l_created_by := FND_GLOBAL.user_id;
1031: l_last_updated_by := FND_GLOBAL.USER_ID;
1032: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1033: l_last_update_date := SYSDATE;
1034: l_creation_date := SYSDATE;

Line 1031: l_last_updated_by := FND_GLOBAL.USER_ID;

1027: l_index_item := 1;
1028: l_index_sched := 1;
1029: l_prior_payment_schedule_id := -999;
1030: l_created_by := FND_GLOBAL.user_id;
1031: l_last_updated_by := FND_GLOBAL.USER_ID;
1032: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1033: l_last_update_date := SYSDATE;
1034: l_creation_date := SYSDATE;
1035:

Line 1032: l_last_update_login := FND_GLOBAL.LOGIN_ID;

1028: l_index_sched := 1;
1029: l_prior_payment_schedule_id := -999;
1030: l_created_by := FND_GLOBAL.user_id;
1031: l_last_updated_by := FND_GLOBAL.USER_ID;
1032: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1033: l_last_update_date := SYSDATE;
1034: l_creation_date := SYSDATE;
1035:
1036: FOR acct_rec IN c_ar_data (p_low_lease_id => l_low_lease_id,

Line 1544: l_created_by NUMBER := FND_GLOBAL.user_id;

1540: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1541: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1542: l_amt NUMBER;
1543: l_prior_payment_schedule_id NUMBER := -999;
1544: l_created_by NUMBER := FND_GLOBAL.user_id;
1545: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1546: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1547: l_last_update_date DATE := sysdate;
1548: l_creation_date DATE := SYSDATE;

Line 1545: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

1541: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1542: l_amt NUMBER;
1543: l_prior_payment_schedule_id NUMBER := -999;
1544: l_created_by NUMBER := FND_GLOBAL.user_id;
1545: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1546: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1547: l_last_update_date DATE := sysdate;
1548: l_creation_date DATE := SYSDATE;
1549: l_msgBuff VARCHAR2 (2000) := NULL;

Line 1546: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

1542: l_amt NUMBER;
1543: l_prior_payment_schedule_id NUMBER := -999;
1544: l_created_by NUMBER := FND_GLOBAL.user_id;
1545: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
1546: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
1547: l_last_update_date DATE := sysdate;
1548: l_creation_date DATE := SYSDATE;
1549: l_msgBuff VARCHAR2 (2000) := NULL;
1550: l_context VARCHAR2(2000);

Line 1903: FND_GLOBAL.conc_program_id,

1899: l_last_update_date,
1900: l_last_updated_by,
1901: l_last_update_login,
1902: SYSDATE,
1903: FND_GLOBAL.conc_program_id,
1904: FND_GLOBAL.prog_appl_id,
1905: FND_GLOBAL.conc_request_id,
1906: pn_mo_cache_utils.get_current_org_id,
1907: NULL

Line 1904: FND_GLOBAL.prog_appl_id,

1900: l_last_updated_by,
1901: l_last_update_login,
1902: SYSDATE,
1903: FND_GLOBAL.conc_program_id,
1904: FND_GLOBAL.prog_appl_id,
1905: FND_GLOBAL.conc_request_id,
1906: pn_mo_cache_utils.get_current_org_id,
1907: NULL
1908: )

Line 1905: FND_GLOBAL.conc_request_id,

1901: l_last_update_login,
1902: SYSDATE,
1903: FND_GLOBAL.conc_program_id,
1904: FND_GLOBAL.prog_appl_id,
1905: FND_GLOBAL.conc_request_id,
1906: pn_mo_cache_utils.get_current_org_id,
1907: NULL
1908: )
1909: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;

Line 1963: FND_GLOBAL.prog_appl_id,

1959: l_last_update_date,
1960: l_last_updated_by,
1961: l_last_update_login,
1962: SYSDATE,
1963: FND_GLOBAL.prog_appl_id,
1964: FND_GLOBAL.conc_program_id,
1965: FND_GLOBAL.conc_request_id,
1966: NULL
1967: )

Line 1964: FND_GLOBAL.conc_program_id,

1960: l_last_updated_by,
1961: l_last_update_login,
1962: SYSDATE,
1963: FND_GLOBAL.prog_appl_id,
1964: FND_GLOBAL.conc_program_id,
1965: FND_GLOBAL.conc_request_id,
1966: NULL
1967: )
1968: RETURNING AE_HEADER_ID INTO l_header_id;

Line 1965: FND_GLOBAL.conc_request_id,

1961: l_last_update_login,
1962: SYSDATE,
1963: FND_GLOBAL.prog_appl_id,
1964: FND_GLOBAL.conc_program_id,
1965: FND_GLOBAL.conc_request_id,
1966: NULL
1967: )
1968: RETURNING AE_HEADER_ID INTO l_header_id;
1969:

Line 2073: FND_GLOBAL.prog_appl_id,

2069: l_last_update_date,
2070: l_last_updated_by,
2071: l_last_update_login,
2072: SYSDATE,
2073: FND_GLOBAL.prog_appl_id,
2074: FND_GLOBAL.conc_program_id,
2075: FND_GLOBAL.conc_request_id
2076: );
2077:

Line 2074: FND_GLOBAL.conc_program_id,

2070: l_last_updated_by,
2071: l_last_update_login,
2072: SYSDATE,
2073: FND_GLOBAL.prog_appl_id,
2074: FND_GLOBAL.conc_program_id,
2075: FND_GLOBAL.conc_request_id
2076: );
2077:
2078: pnp_debug_pkg.log('Inserted into lines for Revenue');

Line 2075: FND_GLOBAL.conc_request_id

2071: l_last_update_login,
2072: SYSDATE,
2073: FND_GLOBAL.prog_appl_id,
2074: FND_GLOBAL.conc_program_id,
2075: FND_GLOBAL.conc_request_id
2076: );
2077:
2078: pnp_debug_pkg.log('Inserted into lines for Revenue');
2079:

Line 2186: FND_GLOBAL.prog_appl_id,

2182: l_last_update_date,
2183: l_last_updated_by,
2184: l_last_update_login,
2185: SYSDATE,
2186: FND_GLOBAL.prog_appl_id,
2187: FND_GLOBAL.conc_program_id,
2188: FND_GLOBAL.conc_request_id
2189: );
2190:

Line 2187: FND_GLOBAL.conc_program_id,

2183: l_last_updated_by,
2184: l_last_update_login,
2185: SYSDATE,
2186: FND_GLOBAL.prog_appl_id,
2187: FND_GLOBAL.conc_program_id,
2188: FND_GLOBAL.conc_request_id
2189: );
2190:
2191: pnp_debug_pkg.log('Inserted into lines for Accrued Asset');

Line 2188: FND_GLOBAL.conc_request_id

2184: l_last_update_login,
2185: SYSDATE,
2186: FND_GLOBAL.prog_appl_id,
2187: FND_GLOBAL.conc_program_id,
2188: FND_GLOBAL.conc_request_id
2189: );
2190:
2191: pnp_debug_pkg.log('Inserted into lines for Accrued Asset');
2192:

Line 2297: l_created_by NUMBER := FND_GLOBAL.user_id;

2293: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
2294: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
2295: l_amt NUMBER;
2296: l_prior_payment_schedule_id NUMBER := -999;
2297: l_created_by NUMBER := FND_GLOBAL.user_id;
2298: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2299: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2300: l_last_update_date DATE := sysdate;
2301: l_creation_date DATE := SYSDATE; --ASH

Line 2298: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

2294: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
2295: l_amt NUMBER;
2296: l_prior_payment_schedule_id NUMBER := -999;
2297: l_created_by NUMBER := FND_GLOBAL.user_id;
2298: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2299: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2300: l_last_update_date DATE := sysdate;
2301: l_creation_date DATE := SYSDATE; --ASH
2302: l_msgBuff VARCHAR2 (2000) := NULL;

Line 2299: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

2295: l_amt NUMBER;
2296: l_prior_payment_schedule_id NUMBER := -999;
2297: l_created_by NUMBER := FND_GLOBAL.user_id;
2298: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
2299: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
2300: l_last_update_date DATE := sysdate;
2301: l_creation_date DATE := SYSDATE; --ASH
2302: l_msgBuff VARCHAR2 (2000) := NULL;
2303: l_context VARCHAR2(2000);

Line 2661: FND_GLOBAL.conc_program_id,

2657: l_last_update_date,
2658: l_last_updated_by,
2659: l_last_update_login,
2660: SYSDATE,
2661: FND_GLOBAL.conc_program_id,
2662: FND_GLOBAL.prog_appl_id,
2663: FND_GLOBAL.conc_request_id,
2664: pn_mo_cache_utils.get_current_org_id,
2665: NULL

Line 2662: FND_GLOBAL.prog_appl_id,

2658: l_last_updated_by,
2659: l_last_update_login,
2660: SYSDATE,
2661: FND_GLOBAL.conc_program_id,
2662: FND_GLOBAL.prog_appl_id,
2663: FND_GLOBAL.conc_request_id,
2664: pn_mo_cache_utils.get_current_org_id,
2665: NULL
2666: )

Line 2663: FND_GLOBAL.conc_request_id,

2659: l_last_update_login,
2660: SYSDATE,
2661: FND_GLOBAL.conc_program_id,
2662: FND_GLOBAL.prog_appl_id,
2663: FND_GLOBAL.conc_request_id,
2664: pn_mo_cache_utils.get_current_org_id,
2665: NULL
2666: )
2667: RETURNING ACCOUNTING_EVENT_ID INTO l_EVENT_id ;

Line 2723: FND_GLOBAL.prog_appl_id,

2719: l_last_update_date,
2720: l_last_updated_by,
2721: l_last_update_login,
2722: SYSDATE,
2723: FND_GLOBAL.prog_appl_id,
2724: FND_GLOBAL.conc_program_id,
2725: FND_GLOBAL.conc_request_id,
2726: NULL
2727: )

Line 2724: FND_GLOBAL.conc_program_id,

2720: l_last_updated_by,
2721: l_last_update_login,
2722: SYSDATE,
2723: FND_GLOBAL.prog_appl_id,
2724: FND_GLOBAL.conc_program_id,
2725: FND_GLOBAL.conc_request_id,
2726: NULL
2727: )
2728: RETURNING AE_HEADER_ID INTO l_header_id;

Line 2725: FND_GLOBAL.conc_request_id,

2721: l_last_update_login,
2722: SYSDATE,
2723: FND_GLOBAL.prog_appl_id,
2724: FND_GLOBAL.conc_program_id,
2725: FND_GLOBAL.conc_request_id,
2726: NULL
2727: )
2728: RETURNING AE_HEADER_ID INTO l_header_id;
2729:

Line 2833: FND_GLOBAL.prog_appl_id,

2829: l_last_update_date,
2830: l_last_updated_by,
2831: l_last_update_login,
2832: SYSDATE,
2833: FND_GLOBAL.prog_appl_id,
2834: FND_GLOBAL.conc_program_id,
2835: FND_GLOBAL.conc_request_id
2836: );
2837:

Line 2834: FND_GLOBAL.conc_program_id,

2830: l_last_updated_by,
2831: l_last_update_login,
2832: SYSDATE,
2833: FND_GLOBAL.prog_appl_id,
2834: FND_GLOBAL.conc_program_id,
2835: FND_GLOBAL.conc_request_id
2836: );
2837:
2838: pnp_debug_pkg.log('Inserted into lines for Expense');

Line 2835: FND_GLOBAL.conc_request_id

2831: l_last_update_login,
2832: SYSDATE,
2833: FND_GLOBAL.prog_appl_id,
2834: FND_GLOBAL.conc_program_id,
2835: FND_GLOBAL.conc_request_id
2836: );
2837:
2838: pnp_debug_pkg.log('Inserted into lines for Expense');
2839:

Line 2948: FND_GLOBAL.prog_appl_id,

2944: l_last_update_date,
2945: l_last_updated_by,
2946: l_last_update_login,
2947: SYSDATE,
2948: FND_GLOBAL.prog_appl_id,
2949: FND_GLOBAL.conc_program_id,
2950: FND_GLOBAL.conc_request_id
2951: );
2952:

Line 2949: FND_GLOBAL.conc_program_id,

2945: l_last_updated_by,
2946: l_last_update_login,
2947: SYSDATE,
2948: FND_GLOBAL.prog_appl_id,
2949: FND_GLOBAL.conc_program_id,
2950: FND_GLOBAL.conc_request_id
2951: );
2952:
2953: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');

Line 2950: FND_GLOBAL.conc_request_id

2946: l_last_update_login,
2947: SYSDATE,
2948: FND_GLOBAL.prog_appl_id,
2949: FND_GLOBAL.conc_program_id,
2950: FND_GLOBAL.conc_request_id
2951: );
2952:
2953: pnp_debug_pkg.log('Inserted into lines for Accrued Liability');
2954: