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_ALL

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