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_TERMS

Line 11: p_customer_id pn_payment_terms.customer_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,
15: pi.payment_item_id,

Line 23: FROM PN_PAYMENT_TERMS pt,

19: pt.set_of_books_id,
20: pi.org_id,
21: ps.payment_schedule_id,
22: pi1.actual_amount
23: FROM PN_PAYMENT_TERMS pt,
24: PN_LEASES_ALL le ,
25: PN_PAYMENT_ITEMS_ALL pi,
26: PN_PAYMENT_ITEMS_ALL pi1,
27: PN_PAYMENT_SCHEDULES_ALL ps

Line 55: p_customer_id pn_payment_terms.customer_id%TYPE)

51: p_high_lease_id pn_leases.lease_id%TYPE,
52: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
53: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
54: p_period_name pn_payment_schedules.period_name%TYPE,
55: p_customer_id pn_payment_terms.customer_id%TYPE)
56: IS
57: SELECT pt.payment_term_id payment_term_id,
58: pt.legal_entity_id legal_entity_id,
59: pt.org_id org_id,

Line 62: FROM PN_PAYMENT_TERMS pt,

58: pt.legal_entity_id legal_entity_id,
59: pt.org_id org_id,
60: pt.customer_id customer_id,
61: pt.cust_trx_type_id cust_trx_type_id
62: FROM PN_PAYMENT_TERMS pt,
63: PN_LEASES_ALL le ,
64: PN_PAYMENT_ITEMS_ALL pi,
65: PN_PAYMENT_ITEMS_ALL pi1,
66: PN_PAYMENT_SCHEDULES_ALL ps

Line 95: p_vendor_id pn_payment_terms.vendor_id%TYPE)

91: p_high_lease_id pn_leases.lease_id%TYPE,
92: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
93: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
94: p_period_name pn_payment_schedules.period_name%TYPE,
95: p_vendor_id pn_payment_terms.vendor_id%TYPE)
96: IS
97: SELECT pt.payment_term_id,
98: pt.lease_id,
99: pt.set_of_books_id,

Line 107: FROM pn_payment_terms pt,

103: ps.schedule_date,
104: pi.org_id,
105: ps.payment_schedule_id,
106: pi1.actual_amount
107: FROM pn_payment_terms pt,
108: pn_leases_all le ,
109: pn_payment_items_all pi,
110: pn_payment_items_all pi1,
111: pn_payment_schedules_all ps

Line 140: p_vendor_id pn_payment_terms.vendor_id%TYPE)

136: p_high_lease_id pn_leases.lease_id%TYPE,
137: p_sch_start_date pn_payment_schedules.schedule_date%TYPE,
138: p_sch_end_date pn_payment_schedules.schedule_date%TYPE,
139: p_period_name pn_payment_schedules.period_name%TYPE,
140: p_vendor_id pn_payment_terms.vendor_id%TYPE)
141: IS
142: SELECT pt.payment_term_id payment_term_id,
143: pt.legal_entity_id legal_entity_id,
144: pt.org_id org_id,

Line 147: FROM pn_payment_terms pt,

143: pt.legal_entity_id legal_entity_id,
144: pt.org_id org_id,
145: pt.vendor_id vendor_id,
146: pt.vendor_site_id vendor_site_id
147: FROM pn_payment_terms pt,
148: pn_leases_all le ,
149: pn_payment_items_all pi,
150: pn_payment_items_all pi1,
151: pn_payment_schedules_all ps

Line 297: UPDATE pn_payment_terms_all

293:
294: IF term_ID_tbl.COUNT > 0 THEN
295:
296: FORALL i IN term_ID_tbl.FIRST..term_ID_tbl.LAST
297: UPDATE pn_payment_terms_all
298: SET legal_entity_id = LE_tbl(i)
299: WHERE payment_term_id = term_ID_tbl(i);
300:
301: END IF;

Line 568: UPDATE pn_payment_terms_all

564:
565: IF term_ID_tbl.COUNT > 0 THEN
566:
567: FORALL i IN term_ID_tbl.FIRST..term_ID_tbl.LAST
568: UPDATE pn_payment_terms_all
569: SET legal_entity_id = LE_tbl(i)
570: WHERE payment_term_id = term_ID_tbl(i);
571:
572: END IF;

Line 1035: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,

1031: -- ensure accounted_Amount is NOT NULL.
1032: -- o Added code to split accounted_Amount per
1033: -- distributions
1034: -- o indented code - bug # 3446951
1035: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,
1036: -- pn_leases,pn__payment_items,pn_payment_schedules
1037: -- with their respective _ALL tables
1038: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id
1039: -- to get_profile_value.

Line 1061: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;

1057: )
1058: AS
1059: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1060: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1061: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1062: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1063: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1064: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1065: v_normalize PN_PAYMENT_TERMS.normalize%type;

Line 1062: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

1058: AS
1059: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1060: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1061: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1062: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1063: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1064: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1065: v_normalize PN_PAYMENT_TERMS.normalize%type;
1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

Line 1063: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

1059: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1060: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1061: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1062: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1063: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1064: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1065: v_normalize PN_PAYMENT_TERMS.normalize%type;
1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

Line 1065: v_normalize PN_PAYMENT_TERMS.normalize%type;

1061: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1062: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;
1063: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1064: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1065: v_normalize PN_PAYMENT_TERMS.normalize%type;
1066: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1067: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1068: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1069: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

Line 1099: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;

1095: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'
1096: ,pn_mo_cache_utils.get_current_org_id));
1097: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1098: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1099: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;
1100: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;
1101: l_LINE_ID PN_AE_LINES.AE_LINE_ID%TYPE;
1102: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%TYPE;
1103: l_event_number NUMBER;

Line 1166: FROM PN_PAYMENT_TERMS pt,

1162: pi.rate,
1163: pi.accounted_amount,
1164: pi1.actual_amount,
1165: ps.schedule_date
1166: FROM PN_PAYMENT_TERMS pt,
1167: PN_LEASES_ALL le ,
1168: PN_PAYMENT_ITEMS_ALL pi,
1169: PN_PAYMENT_ITEMS_ALL pi1,
1170: PN_PAYMENT_SCHEDULES_ALL ps

Line 1394: WHERE source_table = 'PN_PAYMENT_TERMS'

1390:
1391: SELECT nvl(max(event_number),0) + 1
1392: INTO l_event_number
1393: FROM PN_ACCOUNTING_EVENTS_ALL
1394: WHERE source_table = 'PN_PAYMENT_TERMS'
1395: AND SOURCE_ID = v_pn_payment_term_id
1396: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1397:
1398: pnp_debug_pkg.log('Before event insert');

Line 1427: 'PN_PAYMENT_TERMS',

1423: nvl(V_PN_EVENT_TYPE_CODE ,'ABS'),
1424: SYSDATE,
1425: l_event_number,
1426: 'ACCOUNTED',
1427: 'PN_PAYMENT_TERMS',
1428: l_term_id,
1429: l_creation_date,
1430: l_created_by,
1431: l_last_update_date,

Line 1787: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,

1783: -- ensure accounted_Amount is NOT NULL.
1784: -- o Added code to split accounted_Amount per
1785: -- distributions
1786: -- o indented code - bug # 3446951
1787: -- 14-jul-2005 SatyaDeep o replaced pn_distributions,pn_payment_terms,
1788: -- pn_leases,pn__payment_items,pn_payment_schedules
1789: -- with their respective _ALL tables
1790: -- 01-DEC-05 Hareesha o Passed pn_mo_cache_utils.get_current_org_id to
1791: -- get_profile_value.

Line 1814: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;

1810: )
1811: AS
1812: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1813: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1814: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1815: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;
1816: v_pn_project_id pn_payment_terms.project_id%type;
1817: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1818: v_normalize PN_PAYMENT_TERMS.normalize%type;

Line 1815: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;

1811: AS
1812: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1813: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1814: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1815: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;
1816: v_pn_project_id pn_payment_terms.project_id%type;
1817: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1818: v_normalize PN_PAYMENT_TERMS.normalize%type;
1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

Line 1816: v_pn_project_id pn_payment_terms.project_id%type;

1812: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1813: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1814: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1815: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;
1816: v_pn_project_id pn_payment_terms.project_id%type;
1817: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1818: v_normalize PN_PAYMENT_TERMS.normalize%type;
1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

Line 1818: v_normalize PN_PAYMENT_TERMS.normalize%type;

1814: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1815: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;
1816: v_pn_project_id pn_payment_terms.project_id%type;
1817: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
1818: v_normalize PN_PAYMENT_TERMS.normalize%type;
1819: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1820: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1821: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1822: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

Line 1852: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;

1848: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
1849: pn_mo_cache_utils.get_current_org_id));
1850: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1851: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1852: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;
1853: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;
1854: l_LINE_ID PN_AE_LINES.AE_LINE_ID%type;
1855: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%type;
1856: l_event_number number;

Line 1919: FROM pn_payment_terms pt,

1915: pi.rate,
1916: pi.accounted_amount,
1917: pi1.actual_amount,
1918: ps.schedule_date
1919: FROM pn_payment_terms pt,
1920: pn_leases_all le ,
1921: pn_payment_items_all pi,
1922: pn_payment_items_all pi1,
1923: pn_payment_schedules_all ps

Line 2148: WHERE source_table = 'PN_PAYMENT_TERMS'

2144:
2145: SELECT nvl(max(event_number),0) + 1
2146: INTO l_event_number
2147: FROM pn_accounting_events_all
2148: WHERE source_table = 'PN_PAYMENT_TERMS'
2149: AND SOURCE_ID = v_pn_payment_term_id
2150: AND EVENT_TYPE_CODE = v_pn_event_type_code;
2151:
2152: pnp_debug_pkg.log('Before event insert');

Line 2185: 'PN_PAYMENT_TERMS',

2181: nvl(V_PN_EVENT_TYPE_CODE ,'ABS') ,
2182: SYSDATE,
2183: l_event_number,
2184: 'ACCOUNTED',
2185: 'PN_PAYMENT_TERMS',
2186: v_pn_payment_term_id,
2187: l_creation_date,
2188: l_created_by,
2189: l_last_update_date,