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_LEASES

Line 6: p_low_lease_id pn_leases.lease_id%TYPE,

2: -- $Header: PNCRACCB.pls 120.10 2010/10/14 09:34:14 acprakas ship $
3:
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,

Line 7: p_high_lease_id pn_leases.lease_id%TYPE,

3:
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)

Line 28: PN_LEASES_ALL le ,

24: pi.export_currency_amount,
25: pi.export_currency_code,
26: pi.accounted_amount
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

Line 54: p_low_lease_id pn_leases.lease_id%TYPE,

50: OR (pi.transferred_to_ar_flag IS NULL AND pi1.actual_Amount = 0 ))
51: ORDER BY ps.payment_schedule_id;
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,

Line 55: p_high_lease_id pn_leases.lease_id%TYPE,

51: ORDER BY ps.payment_schedule_id;
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)

Line 67: PN_LEASES_ALL le ,

63: pt.org_id org_id,
64: pt.customer_id customer_id,
65: pt.cust_trx_type_id cust_trx_type_id
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

Line 94: p_low_lease_id pn_leases.lease_id%TYPE,

90: AND pt.legal_entity_id IS NULL
91: ORDER BY pt.payment_term_id ;
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,

Line 95: p_high_lease_id pn_leases.lease_id%TYPE,

91: ORDER BY pt.payment_term_id ;
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)

Line 115: pn_leases_all le ,

111: pi.export_currency_amount,
112: pi.export_currency_code,
113: pi.accounted_amount
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

Line 142: p_low_lease_id pn_leases.lease_id%TYPE,

138: OR (pi.transferred_to_ap_flag IS NULL AND pi1.actual_Amount = 0 ))
139: ORDER BY ps.payment_schedule_id;
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,

Line 143: p_high_lease_id pn_leases.lease_id%TYPE,

139: ORDER BY ps.payment_schedule_id;
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)

Line 155: pn_leases_all le ,

151: pt.org_id org_id,
152: pt.vendor_id vendor_id,
153: pt.vendor_site_id vendor_site_id
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

Line 182: CURSOR c_lease_num(p_lease_id pn_leases.lease_id%TYPE)

178: OR (pi.transferred_to_ap_flag IS NULL AND pi1.actual_Amount = 0 ))
179: AND pt.legal_entity_id IS NULL
180: ORDER BY pt.payment_term_id;
181:
182: CURSOR c_lease_num(p_lease_id pn_leases.lease_id%TYPE)
183: IS
184: SELECT lease_num
185: FROM pn_leases_all
186: WHERE lease_id = p_lease_id;

Line 185: FROM pn_leases_all

181:
182: CURSOR c_lease_num(p_lease_id pn_leases.lease_id%TYPE)
183: IS
184: SELECT lease_num
185: FROM pn_leases_all
186: WHERE lease_id = p_lease_id;
187:
188:
189:

Line 627: l_low_lease_id pn_leases.lease_id%TYPE;

623: p_vendor_id IN NUMBER ,
624: P_Org_id IN NUMBER
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;

Line 628: l_high_lease_id pn_leases.lease_id%TYPE;

624: P_Org_id IN NUMBER
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;

Line 927: l_low_lease_id pn_leases.lease_id%TYPE;

923: p_customer_id IN NUMBER ,
924: P_Org_id IN NUMBER
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:

Line 928: l_high_lease_id pn_leases.lease_id%TYPE;

924: P_Org_id IN NUMBER
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;

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 1527: v_pn_lease_id PN_LEASES.lease_id%TYPE;

1523: p_customer_id IN NUMBER ,
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;

Line 1580: l_low_lease_id PN_LEASES.lease_id%TYPE;

1576: v_cash_actual_amount NUMBER := 0;
1577: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%type ;
1578: l_sch_start_date DATE ;
1579: l_sch_end_date DATE;
1580: l_low_lease_id PN_LEASES.lease_id%TYPE;
1581: l_high_lease_id PN_LEASES.lease_id%TYPE;
1582: l_total_acc_amt NUMBER := 0;
1583: l_total_acc_percent NUMBER := 0;
1584: l_header_desc VARCHAR2(240);

Line 1581: l_high_lease_id PN_LEASES.lease_id%TYPE;

1577: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%type ;
1578: l_sch_start_date DATE ;
1579: l_sch_end_date DATE;
1580: l_low_lease_id PN_LEASES.lease_id%TYPE;
1581: l_high_lease_id PN_LEASES.lease_id%TYPE;
1582: l_total_acc_amt NUMBER := 0;
1583: l_total_acc_percent NUMBER := 0;
1584: l_header_desc VARCHAR2(240);
1585: l_line_desc VARCHAR2(240);

Line 1587: v_pn_lease_num PN_LEASES.lease_num%TYPE; --Bug#5739873

1583: l_total_acc_percent NUMBER := 0;
1584: l_header_desc VARCHAR2(240);
1585: l_line_desc VARCHAR2(240);
1586: l_message VARCHAR2(2000);
1587: v_pn_lease_num PN_LEASES.lease_num%TYPE; --Bug#5739873
1588:
1589: CURSOR get_func_curr_code(p_set_of_books_id IN NUMBER) IS
1590: SELECT currency_code ,chart_of_accounts_id
1591: FROM gl_sets_of_books

Line 1635: PN_LEASES_ALL le ,

1631: pi.accounted_amount,
1632: pi1.actual_amount,
1633: ps.schedule_date
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

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 2280: v_pn_lease_id PN_LEASES.lease_id%TYPE;

2276: p_vendor_id IN NUMBER ,
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;

Line 2333: l_low_lease_id PN_LEASES.lease_id%TYPE;

2329: v_cash_actual_amount number := 0;
2330: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%type ;
2331: l_sch_start_date date ;
2332: l_sch_end_date date;
2333: l_low_lease_id PN_LEASES.lease_id%TYPE;
2334: l_high_lease_id PN_LEASES.lease_id%TYPE;
2335: l_total_acc_amt NUMBER := 0;
2336: l_total_acc_percent NUMBER := 0;
2337: l_header_desc varchar2(240);

Line 2334: l_high_lease_id PN_LEASES.lease_id%TYPE;

2330: l_start_date RA_CUST_TRX_LINE_GL_DIST.gl_date%type ;
2331: l_sch_start_date date ;
2332: l_sch_end_date date;
2333: l_low_lease_id PN_LEASES.lease_id%TYPE;
2334: l_high_lease_id PN_LEASES.lease_id%TYPE;
2335: l_total_acc_amt NUMBER := 0;
2336: l_total_acc_percent NUMBER := 0;
2337: l_header_desc varchar2(240);
2338: l_line_desc varchar2(240);

Line 2340: v_pn_lease_num PN_LEASES.lease_num%TYPE; --Bug#5739873

2336: l_total_acc_percent NUMBER := 0;
2337: l_header_desc varchar2(240);
2338: l_line_desc varchar2(240);
2339: l_message VARCHAR2(250);
2340: v_pn_lease_num PN_LEASES.lease_num%TYPE; --Bug#5739873
2341:
2342: CURSOR get_func_curr_code(p_set_of_books_id IN NUMBER) IS
2343: SELECT currency_code ,chart_of_accounts_id
2344: FROM gl_sets_of_books

Line 2388: pn_leases_all le ,

2384: pi.accounted_amount,
2385: pi1.actual_amount,
2386: ps.schedule_date
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