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.PNT_PAYMENT_TERMS_PKG dependencies on PN_PAYMENT_TERMS

Line 12: p_lease_id IN pn_payment_terms.lease_id%TYPE,

8: PROCEDURE UPDATE_PNT_ITEMS_AMT
9: (p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
10: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
11: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
12: p_lease_id IN pn_payment_terms.lease_id%TYPE,
13: p_trm_str_dt IN DATE,
14: p_trm_end_dt IN DATE,
15: p_freq_code IN pn_payment_terms.frequency_code%TYPE);
16:

Line 15: p_freq_code IN pn_payment_terms.frequency_code%TYPE);

11: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
12: p_lease_id IN pn_payment_terms.lease_id%TYPE,
13: p_trm_str_dt IN DATE,
14: p_trm_end_dt IN DATE,
15: p_freq_code IN pn_payment_terms.frequency_code%TYPE);
16:
17: -------------------------------------------------------------------
18: -- PROCEDURE UPDATE_PNT_ITEMS_RATE
19: -------------------------------------------------------------------

Line 52: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_terms with _ALL

48: -- HISTORY :
49: -- 04-DEC-03 ftanudja o Added parameter area_type_code, area. 3257508.
50: -- 17-DEC-03 ATUPPAD o Added parameter grouping_rule_id.
51: -- Part of Grouping Logic for Invoices
52: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_terms with _ALL
53: -- table.
54: -- 15-JUL-05 ftanudja o R12 changes. #4495054, #4497295
55: -- 24-NOV-05 Kiran o rounding for amounts done based on currency precision
56: -- 17-APR-06 Hareesha o Bug 5115291 Passed norm_start_date while inserting

Line 57: -- into pn_payment_terms_all

53: -- table.
54: -- 15-JUL-05 ftanudja o R12 changes. #4495054, #4497295
55: -- 24-NOV-05 Kiran o rounding for amounts done based on currency precision
56: -- 17-APR-06 Hareesha o Bug 5115291 Passed norm_start_date while inserting
57: -- into pn_payment_terms_all
58: -- 14-AUG-06 Pikhar o Set update_nbp_flag to 'Y' on insert
59: -- 21-SEP-06 Hareesha o Removed populating pn_index_exclude_term basing on
60: -- profile option, since we are using a systemoption
61: -- 09-JAN-07 Lokesh o Removed call to CHECK_APPROVED_SCHEDULE_EXISTS which

Line 180: FROM pn_payment_terms_all

176: )
177: IS
178: CURSOR c IS
179: SELECT ROWID
180: FROM pn_payment_terms_all
181: WHERE payment_term_id = x_payment_term_id;
182:
183: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
184: l_return_status VARCHAR2(2) := NULL;

Line 183: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;

179: SELECT ROWID
180: FROM pn_payment_terms_all
181: WHERE payment_term_id = x_payment_term_id;
182:
183: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
184: l_return_status VARCHAR2(2) := NULL;
185:
186: CURSOR org_cur IS
187: SELECT org_id FROM pn_leases_all WHERE lease_id = X_LEASE_ID;

Line 258: INSERT INTO pn_payment_terms_all

254: ,ext_precision => l_ext_precision
255: ,min_acct_unit => l_min_acct_unit);
256:
257: BEGIN
258: INSERT INTO pn_payment_terms_all
259: (
260: PAYMENT_TERM_ID,
261: LAST_UPDATE_DATE,
262: LAST_UPDATED_BY,

Line 370: NVL(X_PAYMENT_TERM_ID,pn_payment_terms_s.NEXTVAL),

366: OPEX_TYPE
367: )
368: VALUES
369: (
370: NVL(X_PAYMENT_TERM_ID,pn_payment_terms_s.NEXTVAL),
371: X_LAST_UPDATE_DATE,
372: X_LAST_UPDATED_BY,
373: X_CREATION_DATE,
374: X_CREATED_BY,

Line 606: FROM PN_PAYMENT_TERMS_ALL

602: )
603: IS
604: CURSOR c1 IS
605: SELECT *
606: FROM PN_PAYMENT_TERMS_ALL
607: WHERE PAYMENT_TERM_ID = X_PAYMENT_TERM_ID
608: FOR UPDATE OF payment_term_id NOWAIT;
609:
610: --tlinfo c1%rowtype;

Line 1083: -- 25-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_terms, pn_leases

1079: -- PURPOSE : updates a term
1080: -- HISTORY :
1081: -- 04-DEC-03 ftanudja o Added parameter area_type_code, area. 3257508.
1082: -- 15-JUL-05 ftanudja o R12 changes. #4495054, #4497295
1083: -- 25-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_terms, pn_leases
1084: -- with _ALL table.
1085: -- 24-NOV-05 Kiran o rounding for amounts done based on currency precision
1086: -- 01-DEC-05 Hareesha o Fetched legal_entity_id into l_legal_entity_id
1087: -- for handling incase it has distributions.

Line 1198: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;

1194: FROM dual
1195: WHERE EXISTS (SELECT 'Y' FROM pn_distributions_all
1196: WHERE payment_term_id = x_payment_term_id);
1197:
1198: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
1199: l_org_id pn_payment_terms.org_id%TYPE;
1200: l_find_le BOOLEAN;
1201: l_return_status VARCHAR2 (2) := NULL;
1202: l_old_est NUMBER;

Line 1199: l_org_id pn_payment_terms.org_id%TYPE;

1195: WHERE EXISTS (SELECT 'Y' FROM pn_distributions_all
1196: WHERE payment_term_id = x_payment_term_id);
1197:
1198: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
1199: l_org_id pn_payment_terms.org_id%TYPE;
1200: l_find_le BOOLEAN;
1201: l_return_status VARCHAR2 (2) := NULL;
1202: l_old_est NUMBER;
1203: l_status PN_LEASES.status%TYPE;

Line 1205: l_rate pn_payment_terms.rate%TYPE;

1201: l_return_status VARCHAR2 (2) := NULL;
1202: l_old_est NUMBER;
1203: l_status PN_LEASES.status%TYPE;
1204: l_context varchar2(240);
1205: l_rate pn_payment_terms.rate%TYPE;
1206: l_precision NUMBER;
1207: l_ext_precision NUMBER;
1208: l_min_acct_unit NUMBER;
1209: l_update_nbp_flag VARCHAR2(1);

Line 1270: FROM pn_payment_terms_all

1266: l_context := 'SELECTing estimated amt';
1267:
1268: SELECT estimated_amount
1269: INTO l_old_est
1270: FROM pn_payment_terms_all
1271: WHERE payment_term_id = X_PAYMENT_TERM_ID;
1272:
1273: IF (l_status = 'F' AND l_old_est <> X_ESTIMATED_AMOUNT) THEN
1274:

Line 1291: FROM pn_payment_terms_all

1287: l_context := 'Selecting old rate and org_id';
1288:
1289: SELECT rate, org_id,legal_entity_id
1290: INTO l_rate, l_org_id,l_legal_entity_id
1291: FROM pn_payment_terms_all
1292: WHERE payment_term_id = X_PAYMENT_TERM_ID;
1293:
1294: l_context := 'updating payment items rate IF rate IS changed';
1295:

Line 1350: UPDATE PN_PAYMENT_TERMS_ALL

1346: ,min_acct_unit => l_min_acct_unit);
1347:
1348: l_context := 'updating payment terms';
1349:
1350: UPDATE PN_PAYMENT_TERMS_ALL
1351: SET PAYMENT_TERM_ID = X_PAYMENT_TERM_ID,
1352: PAYMENT_PURPOSE_CODE = X_PAYMENT_PURPOSE_CODE,
1353: PAYMENT_TERM_TYPE_CODE = X_PAYMENT_TERM_TYPE_CODE,
1354: FREQUENCY_CODE = X_FREQUENCY_CODE,

Line 1469: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_terms with _ALL

1465: -- PROCDURE : DELETE_ROW
1466: -- INVOKED FROM : DELETE_ROW procedure
1467: -- PURPOSE : deletes the row
1468: -- HISTORY :
1469: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_terms with _ALL
1470: -- table.
1471: -------------------------------------------------------------------------------
1472: PROCEDURE DELETE_ROW (
1473: X_PAYMENT_TERM_ID IN NUMBER

Line 1480: DELETE FROM pn_payment_terms_all

1476: BEGIN
1477:
1478: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.DELETE_ROW (+)');
1479:
1480: DELETE FROM pn_payment_terms_all
1481: WHERE payment_term_id = x_payment_term_id;
1482:
1483: IF (SQL%NOTFOUND) THEN
1484: RAISE NO_DATA_FOUND;

Line 1634: p_lease_id IN pn_payment_terms.lease_id%TYPE,

1630: PROCEDURE UPDATE_PNT_ITEMS_AMT (
1631: p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
1632: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
1633: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
1634: p_lease_id IN pn_payment_terms.lease_id%TYPE,
1635: p_trm_str_dt IN DATE,
1636: p_trm_end_dt IN DATE,
1637: p_freq_code IN pn_payment_terms.frequency_code%TYPE
1638: )

Line 1637: p_freq_code IN pn_payment_terms.frequency_code%TYPE

1633: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
1634: p_lease_id IN pn_payment_terms.lease_id%TYPE,
1635: p_trm_str_dt IN DATE,
1636: p_trm_end_dt IN DATE,
1637: p_freq_code IN pn_payment_terms.frequency_code%TYPE
1638: )
1639: IS
1640:
1641: l_prorate_rule NUMBER;

Line 1868: -- 25-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_terms with _ALL

1864: -- term record is 'corrected' or 'updated' in the Leases UI.
1865: -- HISTORY
1866: -- 15-OCT-04 Mrinal o Created.
1867: -- 15-JUL-05 ftanudja o R12 changes - #4495054, #4497295
1868: -- 25-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_terms with _ALL
1869: -- table.
1870: -------------------------------------------------------------------------------
1871: PROCEDURE create_hist_corr_upd(p_term_id IN NUMBER,
1872: p_dist_changed IN NUMBER,

Line 1878: term_rec PN_PAYMENT_TERMS_ALL%ROWTYPE;

1874: p_change_mode IN VARCHAR2,
1875: p_eff_str_dt IN DATE,
1876: p_eff_end_dt IN DATE) IS
1877:
1878: term_rec PN_PAYMENT_TERMS_ALL%ROWTYPE;
1879: n NUMBER(1);
1880: l_dist_change_id NUMBER(15);
1881: l_prev_term_hist_id NUMBER(15);
1882: l_new_term_id NUMBER(15);

Line 1894: l_adj_type_code pn_payment_terms_history.adjustment_type_code%TYPE;

1890: l_creation_date DATE;
1891: l_created_by NUMBER;
1892: l_last_update_login NUMBER;
1893: l_insert_dist_hist VARCHAR2(1);
1894: l_adj_type_code pn_payment_terms_history.adjustment_type_code%TYPE;
1895: l_term_comments pn_payment_terms_history.term_comments%TYPE;
1896: l_changed_flag pn_payment_terms.changed_flag%TYPE;
1897:
1898: CURSOR get_term_cur(p_term_id IN NUMBER) IS

Line 1895: l_term_comments pn_payment_terms_history.term_comments%TYPE;

1891: l_created_by NUMBER;
1892: l_last_update_login NUMBER;
1893: l_insert_dist_hist VARCHAR2(1);
1894: l_adj_type_code pn_payment_terms_history.adjustment_type_code%TYPE;
1895: l_term_comments pn_payment_terms_history.term_comments%TYPE;
1896: l_changed_flag pn_payment_terms.changed_flag%TYPE;
1897:
1898: CURSOR get_term_cur(p_term_id IN NUMBER) IS
1899: SELECT *

Line 1896: l_changed_flag pn_payment_terms.changed_flag%TYPE;

1892: l_last_update_login NUMBER;
1893: l_insert_dist_hist VARCHAR2(1);
1894: l_adj_type_code pn_payment_terms_history.adjustment_type_code%TYPE;
1895: l_term_comments pn_payment_terms_history.term_comments%TYPE;
1896: l_changed_flag pn_payment_terms.changed_flag%TYPE;
1897:
1898: CURSOR get_term_cur(p_term_id IN NUMBER) IS
1899: SELECT *
1900: FROM pn_payment_terms_all

Line 1900: FROM pn_payment_terms_all

1896: l_changed_flag pn_payment_terms.changed_flag%TYPE;
1897:
1898: CURSOR get_term_cur(p_term_id IN NUMBER) IS
1899: SELECT *
1900: FROM pn_payment_terms_all
1901: WHERE payment_term_id = p_term_id;
1902:
1903: CURSOR get_dist_cur(p_term_id IN NUMBER) IS
1904: SELECT *

Line 1917: FROM pn_payment_terms_history

1913: AND pd.payment_term_id = p_term_id;
1914:
1915: CURSOR get_max_term_hist_id_cur(p_term_id IN NUMBER) IS
1916: SELECT MAX(term_history_id)
1917: FROM pn_payment_terms_history
1918: WHERE payment_term_id = p_term_id;
1919: BEGIN
1920:
1921: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.create_hist_corr_upd (+)');

Line 2066: INSERT INTO pn_payment_terms_history

2062: END LOOP;
2063:
2064: pnp_debug_pkg.debug('create_hist_corr_upd : Inserting in Term Hist. for very first time');
2065:
2066: INSERT INTO pn_payment_terms_history
2067: (
2068: TERM_HISTORY_ID
2069: ,LAST_UPDATE_DATE
2070: ,LAST_UPDATED_BY

Line 2172: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL

2168: ,AREA_TYPE_CODE
2169: ,AREA
2170: ,TERM_COMMENTS)
2171: VALUES
2172: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2173: ,SYSDATE
2174: ,FND_GLOBAL.USER_ID
2175: ,SYSDATE
2176: ,FND_GLOBAL.USER_ID

Line 2276: pnp_debug_pkg.debug('create_hist_corr_upd : Updating Term Altered Flag in pn_payment_terms_all');

2272: ,tlinfo.AREA_TYPE_CODE
2273: ,tlinfo.AREA
2274: ,NULL);
2275:
2276: pnp_debug_pkg.debug('create_hist_corr_upd : Updating Term Altered Flag in pn_payment_terms_all');
2277:
2278: UPDATE pn_payment_terms_all
2279: SET term_altered_flag = 'Y'
2280: WHERE payment_term_id = p_term_id;

Line 2278: UPDATE pn_payment_terms_all

2274: ,NULL);
2275:
2276: pnp_debug_pkg.debug('create_hist_corr_upd : Updating Term Altered Flag in pn_payment_terms_all');
2277:
2278: UPDATE pn_payment_terms_all
2279: SET term_altered_flag = 'Y'
2280: WHERE payment_term_id = p_term_id;
2281: END IF;
2282:

Line 2412: INSERT INTO pn_payment_terms_history

2408:
2409: pnp_debug_pkg.debug('create_hist_corr_upd : l_adj_type_code :'||l_adj_type_code);
2410: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');
2411:
2412: INSERT INTO pn_payment_terms_history
2413: (TERM_HISTORY_ID
2414: ,LAST_UPDATE_DATE
2415: ,LAST_UPDATED_BY
2416: ,CREATION_DATE

Line 2517: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL

2513: ,AREA_TYPE_CODE
2514: ,AREA
2515: ,TERM_COMMENTS)
2516: VALUES
2517: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2518: ,SYSDATE
2519: ,FND_GLOBAL.USER_ID
2520: ,SYSDATE
2521: ,FND_GLOBAL.USER_ID

Line 2632: SELECT pn_payment_terms_s.nextval

2628:
2629: IF (p_eff_str_dt > term_rec.start_date AND
2630: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN
2631:
2632: SELECT pn_payment_terms_s.nextval
2633: INTO l_new_term_id
2634: FROM DUAL;
2635:
2636: l_adj_type_code := NULL;

Line 2642: UPDATE pn_payment_terms_all

2638:
2639: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);
2640: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Updating term with new Term Id');
2641:
2642: UPDATE pn_payment_terms_all
2643: SET start_date = p_eff_str_dt,
2644: end_date = NVL(p_eff_end_dt,term_rec.end_date),
2645: term_altered_flag = 'Y',
2646: changed_flag = 'N',

Line 2738: UPDATE pn_payment_terms_all

2734: NVL(p_eff_end_dt, term_rec.end_date) <= term_rec.end_date) THEN
2735:
2736: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Updating term with Eff. End Date');
2737:
2738: UPDATE pn_payment_terms_all
2739: SET end_date = NVL(p_eff_end_dt, term_rec.end_date),
2740: term_altered_flag = 'Y',
2741: changed_flag = 'Y'
2742: WHERE payment_term_id = p_term_id;

Line 2759: INSERT INTO pn_payment_terms_history

2755: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);
2756: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);
2757: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');
2758:
2759: INSERT INTO pn_payment_terms_history
2760: (TERM_HISTORY_ID
2761: ,LAST_UPDATE_DATE
2762: ,LAST_UPDATED_BY
2763: ,CREATION_DATE

Line 2864: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL

2860: ,AREA_TYPE_CODE
2861: ,AREA
2862: ,TERM_COMMENTS)
2863: VALUES
2864: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2865: ,SYSDATE
2866: ,FND_GLOBAL.USER_ID
2867: ,SYSDATE
2868: ,FND_GLOBAL.USER_ID

Line 3008: SELECT pn_payment_terms_s.nextval

3004: i = 2) OR
3005: (p_eff_str_dt = term_rec.start_date AND
3006: i = 1) THEN
3007:
3008: SELECT pn_payment_terms_s.nextval
3009: INTO l_term_id
3010: FROM DUAL;
3011:
3012: l_str_dt := NVL(p_eff_end_dt, term_rec.end_date) + 1;

Line 3030: INSERT INTO pn_payment_terms_all

3026: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);
3027: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);
3028: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');
3029:
3030: INSERT INTO pn_payment_terms_all
3031: (PAYMENT_TERM_ID
3032: ,LAST_UPDATE_DATE
3033: ,LAST_UPDATED_BY
3034: ,CREATION_DATE

Line 3402: INSERT INTO pn_payment_terms_history

3398: END IF;
3399:
3400: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist. table.');
3401:
3402: INSERT INTO pn_payment_terms_history
3403: (TERM_HISTORY_ID
3404: ,LAST_UPDATE_DATE
3405: ,LAST_UPDATED_BY
3406: ,CREATION_DATE

Line 3507: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL

3503: ,AREA_TYPE_CODE
3504: ,AREA
3505: ,TERM_COMMENTS)
3506: VALUES
3507: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
3508: ,SYSDATE
3509: ,FND_GLOBAL.USER_ID
3510: ,SYSDATE
3511: ,FND_GLOBAL.USER_ID

Line 3620: -- INVOKED FROM : pn_payment_terms_v form view (PNPTERMV.sql)

3616: END create_hist_corr_upd;
3617:
3618: --------------------------------------------------------------------------------
3619: -- FUNCTION : return_agreement_number
3620: -- INVOKED FROM : pn_payment_terms_v form view (PNPTERMV.sql)
3621: -- PURPOSE : returns the agreement number to which the payment term is associated.
3622: -- HISTORY :
3623: --
3624: -- 12-MAR-07 Prabhakar o Created.

Line 3632: FROM pn_payment_terms_all

3628: l_agreement_number VARCHAR2(30) := NULL;
3629:
3630: CURSOR c1 IS
3631: SELECT opex_agr_id,index_period_id,var_rent_inv_id,rec_agr_line_id
3632: FROM pn_payment_terms_all
3633: where payment_term_id = p_payment_term_id;
3634:
3635: BEGIN
3636:

Line 3719: -- INVOKED FROM : pn_payment_terms_v form view (PNPTERMV.sql)

3715: END CHECK_IF_OPEX_TERM;
3716:
3717: --------------------------------------------------------------------------------
3718: -- FUNCTION : get_source_module_type
3719: -- INVOKED FROM : pn_payment_terms_v form view (PNPTERMV.sql)
3720: -- PURPOSE : returns the source of the term from which it is created.
3721: -- HISTORY :
3722: --
3723: -- 09-MAY-07 Prabhakar o Created.

Line 3736: FROM pn_payment_terms_all

3732: index_period_id,
3733: var_rent_inv_id,
3734: rec_agr_line_id,
3735: source_code
3736: FROM pn_payment_terms_all
3737: where payment_term_id = p_payment_term_id;
3738:
3739: BEGIN
3740:

Line 3771: UPDATE pn_payment_terms_all

3767: BEGIN
3768:
3769: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.MODIFY_ROW (+)');
3770:
3771: UPDATE pn_payment_terms_all
3772: SET changed_flag = x_changed_flag
3773: WHERE payment_term_id = NVL(x_payment_term_id ,payment_term_id )
3774: AND var_rent_inv_id = x_var_rent_inv_id;
3775: