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 27: FROM PN_PAYMENT_TERMS pt,

23: pi.due_date, -- Added for Bug#8303091 ,
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

Line 59: p_customer_id pn_payment_terms.customer_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,
63: pt.org_id org_id,

Line 66: FROM PN_PAYMENT_TERMS pt,

62: pt.legal_entity_id legal_entity_id,
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

Line 99: p_vendor_id pn_payment_terms.vendor_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,
103: pt.set_of_books_id,

Line 114: FROM pn_payment_terms pt,

110: pi1.actual_amount,
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

Line 147: p_vendor_id pn_payment_terms.vendor_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,
151: pt.org_id org_id,

Line 154: FROM pn_payment_terms pt,

150: pt.legal_entity_id legal_entity_id,
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

Line 721: UPDATE pn_payment_terms_all

717:
718: IF term_ID_tbl.COUNT > 0 THEN
719:
720: FORALL i IN term_ID_tbl.FIRST..term_ID_tbl.LAST
721: UPDATE pn_payment_terms_all
722: SET legal_entity_id = LE_tbl(i)
723: WHERE payment_term_id = term_ID_tbl(i);
724:
725: END IF;

Line 1015: UPDATE pn_payment_terms_all

1011:
1012: IF term_ID_tbl.COUNT > 0 THEN
1013:
1014: FORALL i IN term_ID_tbl.FIRST..term_ID_tbl.LAST
1015: UPDATE pn_payment_terms_all
1016: SET legal_entity_id = LE_tbl(i)
1017: WHERE payment_term_id = term_ID_tbl(i);
1018:
1019: END IF;

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

1499: -- ensure accounted_Amount is NOT NULL.
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.

Line 1529: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;

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;
1533: v_normalize PN_PAYMENT_TERMS.normalize%type;

Line 1530: v_pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE;

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;
1533: v_normalize PN_PAYMENT_TERMS.normalize%type;
1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

Line 1531: v_pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

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;
1533: v_normalize PN_PAYMENT_TERMS.normalize%type;
1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

Line 1533: v_normalize PN_PAYMENT_TERMS.normalize%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;
1533: v_normalize PN_PAYMENT_TERMS.normalize%type;
1534: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
1535: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
1536: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
1537: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

Line 1567: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;

1563: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'
1564: ,pn_mo_cache_utils.get_current_org_id));
1565: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
1566: l_conv_rate_type pn_currencies.conversion_type%TYPE;
1567: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%TYPE;
1568: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%TYPE;
1569: l_LINE_ID PN_AE_LINES.AE_LINE_ID%TYPE;
1570: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%TYPE;
1571: l_event_number NUMBER;

Line 1634: FROM PN_PAYMENT_TERMS pt,

1630: pi.rate,
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

Line 1862: WHERE source_table = 'PN_PAYMENT_TERMS'

1858:
1859: SELECT nvl(max(event_number),0) + 1
1860: INTO l_event_number
1861: FROM PN_ACCOUNTING_EVENTS_ALL
1862: WHERE source_table = 'PN_PAYMENT_TERMS'
1863: AND SOURCE_ID = v_pn_payment_term_id
1864: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1865:
1866: pnp_debug_pkg.log('Before event insert');

Line 1895: 'PN_PAYMENT_TERMS',

1891: nvl(V_PN_EVENT_TYPE_CODE ,'ABS'),
1892: SYSDATE,
1893: l_event_number,
1894: 'ACCOUNTED',
1895: 'PN_PAYMENT_TERMS',
1896: l_term_id,
1897: l_creation_date,
1898: l_created_by,
1899: l_last_update_date,

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

2251: -- ensure accounted_Amount is NOT NULL.
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.

Line 2282: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;

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;
2286: v_normalize PN_PAYMENT_TERMS.normalize%type;

Line 2283: v_pn_distribution_set_id pn_payment_terms.distribution_set_id%TYPE;

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;
2286: v_normalize PN_PAYMENT_TERMS.normalize%type;
2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;

Line 2284: v_pn_project_id pn_payment_terms.project_id%type;

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;
2286: v_normalize PN_PAYMENT_TERMS.normalize%type;
2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;

Line 2286: v_normalize PN_PAYMENT_TERMS.normalize%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;
2286: v_normalize PN_PAYMENT_TERMS.normalize%type;
2287: v_pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE;
2288: v_pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE;
2289: v_pn_currency_code PN_PAYMENT_ITEMS.currency_code%TYPE;
2290: v_pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE;

Line 2320: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;

2316: l_set_of_books_id NUMBER := TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
2317: pn_mo_cache_utils.get_current_org_id));
2318: l_func_curr_code gl_sets_of_books.currency_code%TYPE;
2319: l_conv_rate_type pn_currencies.conversion_type%TYPE;
2320: v_pn_EVENT_TYPE_CODE pn_payment_terms.EVENT_TYPE_CODE%type;
2321: l_header_ID PN_AE_HEADERS.AE_HEADER_ID%type;
2322: l_LINE_ID PN_AE_LINES.AE_LINE_ID%type;
2323: l_EVENT_ID PN_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID%type;
2324: l_event_number number;

Line 2387: FROM pn_payment_terms pt,

2383: pi.rate,
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

Line 2616: WHERE source_table = 'PN_PAYMENT_TERMS'

2612:
2613: SELECT nvl(max(event_number),0) + 1
2614: INTO l_event_number
2615: FROM pn_accounting_events_all
2616: WHERE source_table = 'PN_PAYMENT_TERMS'
2617: AND SOURCE_ID = v_pn_payment_term_id
2618: AND EVENT_TYPE_CODE = v_pn_event_type_code;
2619:
2620: pnp_debug_pkg.log('Before event insert');

Line 2653: 'PN_PAYMENT_TERMS',

2649: nvl(V_PN_EVENT_TYPE_CODE ,'ABS') ,
2650: SYSDATE,
2651: l_event_number,
2652: 'ACCOUNTED',
2653: 'PN_PAYMENT_TERMS',
2654: v_pn_payment_term_id,
2655: l_creation_date,
2656: l_created_by,
2657: l_last_update_date,