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;
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:
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;
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');
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:
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;
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;
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:
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,
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;
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:
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,
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;
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;
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);
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
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: )
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 ;
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: )
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;
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:
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:
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');
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:
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:
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');
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:
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
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;
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);
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
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: )
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 ;
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: )
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;
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:
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:
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');
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:
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:
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');
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: