eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_CREATE_ACC dependencies on PN_PAYMENT_SCHEDULES

Line 8: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,

4:
5: CURSOR c_ar_data (
6: p_low_lease_id pn_leases.lease_id%TYPE,
7: p_high_lease_id pn_leases.lease_id%TYPE,
8: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
9: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
10: p_period_name pn_payment_schedules.period_name%TYPE,
11: p_customer_id pn_payment_terms.customer_id%TYPE)
12: IS

Line 9: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,

5: CURSOR c_ar_data (
6: p_low_lease_id pn_leases.lease_id%TYPE,
7: p_high_lease_id pn_leases.lease_id%TYPE,
8: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
9: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
10: p_period_name pn_payment_schedules.period_name%TYPE,
11: p_customer_id pn_payment_terms.customer_id%TYPE)
12: IS
13: SELECT pt.payment_term_id,

Line 10: p_period_name pn_payment_schedules.period_name%TYPE,

6: p_low_lease_id pn_leases.lease_id%TYPE,
7: p_high_lease_id pn_leases.lease_id%TYPE,
8: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
9: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
10: p_period_name pn_payment_schedules.period_name%TYPE,
11: p_customer_id pn_payment_terms.customer_id%TYPE)
12: IS
13: SELECT pt.payment_term_id,
14: pt.lease_id,

Line 31: PN_PAYMENT_SCHEDULES_ALL ps

27: FROM PN_PAYMENT_TERMS pt,
28: PN_LEASES_ALL le ,
29: PN_PAYMENT_ITEMS_ALL pi,
30: PN_PAYMENT_ITEMS_ALL pi1,
31: PN_PAYMENT_SCHEDULES_ALL ps
32: WHERE pt.lease_id = le.lease_id
33: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
34: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
35: AND ps.lease_id = le.lease_id

Line 56: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,

52:
53: CURSOR c_ar_data_le_upg (
54: p_low_lease_id pn_leases.lease_id%TYPE,
55: p_high_lease_id pn_leases.lease_id%TYPE,
56: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
57: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
58: p_period_name pn_payment_schedules.period_name%TYPE,
59: p_customer_id pn_payment_terms.customer_id%TYPE)
60: IS

Line 57: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,

53: CURSOR c_ar_data_le_upg (
54: p_low_lease_id pn_leases.lease_id%TYPE,
55: p_high_lease_id pn_leases.lease_id%TYPE,
56: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
57: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
58: p_period_name pn_payment_schedules.period_name%TYPE,
59: p_customer_id pn_payment_terms.customer_id%TYPE)
60: IS
61: SELECT pt.payment_term_id payment_term_id,

Line 58: p_period_name pn_payment_schedules.period_name%TYPE,

54: p_low_lease_id pn_leases.lease_id%TYPE,
55: p_high_lease_id pn_leases.lease_id%TYPE,
56: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
57: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
58: p_period_name pn_payment_schedules.period_name%TYPE,
59: p_customer_id pn_payment_terms.customer_id%TYPE)
60: IS
61: SELECT pt.payment_term_id payment_term_id,
62: pt.legal_entity_id legal_entity_id,

Line 70: PN_PAYMENT_SCHEDULES_ALL ps

66: FROM PN_PAYMENT_TERMS pt,
67: PN_LEASES_ALL le ,
68: PN_PAYMENT_ITEMS_ALL pi,
69: PN_PAYMENT_ITEMS_ALL pi1,
70: PN_PAYMENT_SCHEDULES_ALL ps
71: WHERE pt.lease_id = le.lease_id
72: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
73: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
74: AND ps.lease_id = le.lease_id

Line 96: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,

92:
93: CURSOR c_ap_data(
94: p_low_lease_id pn_leases.lease_id%TYPE,
95: p_high_lease_id pn_leases.lease_id%TYPE,
96: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
97: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
98: p_period_name pn_payment_schedules.period_name%TYPE,
99: p_vendor_id pn_payment_terms.vendor_id%TYPE)
100: IS

Line 97: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,

93: CURSOR c_ap_data(
94: p_low_lease_id pn_leases.lease_id%TYPE,
95: p_high_lease_id pn_leases.lease_id%TYPE,
96: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
97: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
98: p_period_name pn_payment_schedules.period_name%TYPE,
99: p_vendor_id pn_payment_terms.vendor_id%TYPE)
100: IS
101: SELECT pt.payment_term_id,

Line 98: p_period_name pn_payment_schedules.period_name%TYPE,

94: p_low_lease_id pn_leases.lease_id%TYPE,
95: p_high_lease_id pn_leases.lease_id%TYPE,
96: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
97: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
98: p_period_name pn_payment_schedules.period_name%TYPE,
99: p_vendor_id pn_payment_terms.vendor_id%TYPE)
100: IS
101: SELECT pt.payment_term_id,
102: pt.lease_id,

Line 118: pn_payment_schedules_all ps

114: FROM pn_payment_terms pt,
115: pn_leases_all le ,
116: pn_payment_items_all pi,
117: pn_payment_items_all pi1,
118: pn_payment_schedules_all ps
119: WHERE pt.lease_id = le.lease_id
120: AND le.lease_class_code = 'DIRECT'
121: and LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
122: and ps.lease_id = le.lease_id

Line 144: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,

140:
141: CURSOR c_ap_data_le_upg(
142: p_low_lease_id pn_leases.lease_id%TYPE,
143: p_high_lease_id pn_leases.lease_id%TYPE,
144: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
145: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
146: p_period_name pn_payment_schedules.period_name%TYPE,
147: p_vendor_id pn_payment_terms.vendor_id%TYPE)
148: IS

Line 145: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,

141: CURSOR c_ap_data_le_upg(
142: p_low_lease_id pn_leases.lease_id%TYPE,
143: p_high_lease_id pn_leases.lease_id%TYPE,
144: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
145: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
146: p_period_name pn_payment_schedules.period_name%TYPE,
147: p_vendor_id pn_payment_terms.vendor_id%TYPE)
148: IS
149: SELECT pt.payment_term_id payment_term_id,

Line 146: p_period_name pn_payment_schedules.period_name%TYPE,

142: p_low_lease_id pn_leases.lease_id%TYPE,
143: p_high_lease_id pn_leases.lease_id%TYPE,
144: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
145: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
146: p_period_name pn_payment_schedules.period_name%TYPE,
147: p_vendor_id pn_payment_terms.vendor_id%TYPE)
148: IS
149: SELECT pt.payment_term_id payment_term_id,
150: pt.legal_entity_id legal_entity_id,

Line 158: pn_payment_schedules_all ps

154: FROM pn_payment_terms pt,
155: pn_leases_all le ,
156: pn_payment_items_all pi,
157: pn_payment_items_all pi1,
158: pn_payment_schedules_all ps
159: WHERE pt.lease_id = le.lease_id
160: AND le.lease_class_code = 'DIRECT'
161: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
162: AND ps.lease_id = le.lease_id

Line 613: -- Set transfer related information in PN_PAYMENT_SCHEDULES

609: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
610: -- 12-MAY-06 sdmahesh o Bug # 5219481
611: -- Set transferred_to_ap_flag in PN_PAYMENT_ITEMS
612: -- Stamped xla_event_id PN_PAYMENT_ITEMS
613: -- Set transfer related information in PN_PAYMENT_SCHEDULES
614: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
615: -------------------------------------------------------------------------------
616:
617: PROCEDURE CREATE_AP_ACC_R12(

Line 629: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;

625: ) AS
626:
627: l_low_lease_id pn_leases.lease_id%TYPE;
628: l_high_lease_id pn_leases.lease_id%TYPE;
629: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
630: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
631: l_lia_account NUMBER;
632: l_prior_payment_schedule_id NUMBER;
633: l_created_by NUMBER;

Line 630: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;

626:
627: l_low_lease_id pn_leases.lease_id%TYPE;
628: l_high_lease_id pn_leases.lease_id%TYPE;
629: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
630: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
631: l_lia_account NUMBER;
632: l_prior_payment_schedule_id NUMBER;
633: l_created_by NUMBER;
634: l_last_updated_by NUMBER;

Line 642: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;

638: l_due_date DATE;
639:
640: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
641: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
642: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
643: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
644:
645: term_ID_tbl NUMBER_tbl_typ;
646: LE_tbl NUMBER_tbl_typ;

Line 814: UPDATE PN_Payment_Schedules_all

810:
811: IF schedule_id_tbl.COUNT > 0 THEN
812:
813: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
814: UPDATE PN_Payment_Schedules_all
815: SET Transferred_By_User_Id = l_last_updated_by,
816: Transfer_Date = l_last_update_date,
817: last_updated_by = l_last_updated_by,
818: last_update_login = l_last_update_login,

Line 871: UPDATE PN_Payment_Schedules_all

867:
868: IF schedule_id_tbl.COUNT > 0 THEN
869:
870: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
871: UPDATE PN_Payment_Schedules_all
872: SET Transferred_By_User_Id = l_last_updated_by,
873: Transfer_Date = l_last_update_date,
874: last_updated_by = l_last_updated_by,
875: last_update_login = l_last_update_login,

Line 913: -- Set transfer related information in PN_PAYMENT_SCHEDULES

909: -- 01-DEC-05 Hareesha o Changes for Lazy upgrade for LE uptake.
910: -- 12-MAY-06 sdmahesh o Bug # 5219481
911: -- Set transferred_to_ar_flag in PN_PAYMENT_ITEMS
912: -- Stamped xla_event_id PN_PAYMENT_ITEMS
913: -- Set transfer related information in PN_PAYMENT_SCHEDULES
914: -- 27-NOV-06 sdmahesh o Changed event_id_tbl_typ to NUMBER
915: -------------------------------------------------------------------------------
916:
917: PROCEDURE CREATE_AR_ACC_R12(

Line 929: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;

925: ) AS
926:
927: l_low_lease_id pn_leases.lease_id%TYPE;
928: l_high_lease_id pn_leases.lease_id%TYPE;
929: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
930: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
931:
932: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
933: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;

Line 930: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;

926:
927: l_low_lease_id pn_leases.lease_id%TYPE;
928: l_high_lease_id pn_leases.lease_id%TYPE;
929: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
930: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
931:
932: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
933: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
934: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 933: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;

929: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
930: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
931:
932: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
933: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
934: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
935: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
936:
937: term_ID_tbl NUMBER_tbl_typ;

Line 1106: UPDATE PN_Payment_Schedules_all

1102:
1103: IF schedule_id_tbl.COUNT > 0 THEN
1104:
1105: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
1106: UPDATE PN_Payment_Schedules_all
1107: SET Transferred_By_User_Id = l_last_updated_by,
1108: Transfer_Date = l_last_update_date,
1109: last_updated_by = l_last_updated_by,
1110: last_update_login = l_last_update_login,

Line 1163: UPDATE PN_Payment_Schedules_all

1159:
1160: IF schedule_id_tbl.COUNT > 0 THEN
1161:
1162: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
1163: UPDATE PN_Payment_Schedules_all
1164: SET Transferred_By_User_Id = l_last_updated_by,
1165: Transfer_Date = l_last_update_date,
1166: last_updated_by = l_last_updated_by,
1167: last_update_login = l_last_update_login,

Line 1504: -- pn_leases,pn__payment_items,pn_payment_schedules

1500: -- o Added code to split accounted_Amount per
1501: -- distributions
1502: -- o indented code - bug # 3446951
1503: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,
1504: -- pn_leases,pn__payment_items,pn_payment_schedules
1505: -- with their respective _ALL tables
1506: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
1507: -- to get_profile_value.
1508: -- Inserted pn_mo_cache_utils.get_current_org_id as

Line 1528: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;

1524: P_Org_id IN NUMBER
1525: )
1526: AS
1527: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1528: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1529: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1530: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1531: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1532: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;

Line 1638: PN_PAYMENT_SCHEDULES_ALL ps

1634: FROM PN_PAYMENT_TERMS pt,
1635: PN_LEASES_ALL le ,
1636: PN_PAYMENT_ITEMS_ALL pi,
1637: PN_PAYMENT_ITEMS_ALL pi1,
1638: PN_PAYMENT_SCHEDULES_ALL ps
1639: WHERE pt.lease_id = le.lease_id
1640: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
1641: AND LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID
1642: AND ps.lease_id = le.lease_id

Line 2217: UPDATE PN_Payment_Schedules_all

2213: l_context := 'Updating Payment Schedules';
2214: pnp_debug_pkg.log('Updating billing schedules for billing sch id : ' ||
2215: to_char(V_PN_Payment_Schedule_Id) );
2216:
2217: UPDATE PN_Payment_Schedules_all
2218: SET Transferred_By_User_Id = l_last_updated_by,
2219: Transfer_Date = l_last_update_date,
2220: last_updated_by = l_last_updated_by,
2221: last_update_login = l_last_update_login,

Line 2256: -- pn_leases,pn__payment_items,pn_payment_schedules

2252: -- o Added code to split accounted_Amount per
2253: -- distributions
2254: -- o indented code - bug # 3446951
2255: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,
2256: -- pn_leases,pn__payment_items,pn_payment_schedules
2257: -- with their respective _ALL tables
2258: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id to
2259: -- get_profile_value.
2260: -- Inserted pn_mo_cache_utils.get_current_org_id

Line 2281: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;

2277: P_Org_id IN NUMBER
2278: )
2279: AS
2280: v_pn_lease_id PN_LEASES.lease_id%TYPE;
2281: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
2282: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
2283: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;
2284: v_pn_project_id pn_payment_terms.project_id%type;
2285: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;

Line 2391: pn_payment_schedules_all ps

2387: FROM pn_payment_terms pt,
2388: pn_leases_all le ,
2389: pn_payment_items_all pi,
2390: pn_payment_items_all pi1,
2391: pn_payment_schedules_all ps
2392: WHERE pt.lease_id = le.lease_id
2393: AND le.lease_class_code = 'DIRECT'
2394: and LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID
2395: and ps.lease_id = le.lease_id

Line 2978: UPDATE PN_Payment_Schedules_all

2974:
2975: pnp_debug_pkg.log('Updating Payment schedules for Payment sch id : ' ||
2976: to_char(V_PN_Payment_Schedule_Id) );
2977:
2978: UPDATE PN_Payment_Schedules_all
2979: SET Transferred_By_User_Id = l_last_updated_by,
2980: Transfer_Date = l_last_update_date,
2981: last_updated_by = l_last_updated_by,
2982: last_update_login = l_last_update_login,