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 1272: FROM pn_payment_terms_all

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

Line 1293: FROM pn_payment_terms_all

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

Line 1354: UPDATE PN_PAYMENT_TERMS_ALL

1350: ,min_acct_unit => l_min_acct_unit);
1351:
1352: l_context := 'updating payment terms';
1353:
1354: UPDATE PN_PAYMENT_TERMS_ALL
1355: SET PAYMENT_TERM_ID = X_PAYMENT_TERM_ID,
1356: PAYMENT_PURPOSE_CODE = X_PAYMENT_PURPOSE_CODE,
1357: PAYMENT_TERM_TYPE_CODE = X_PAYMENT_TERM_TYPE_CODE,
1358: FREQUENCY_CODE = X_FREQUENCY_CODE,

Line 1484: DELETE FROM pn_payment_terms_all

1480: BEGIN
1481:
1482: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.DELETE_ROW (+)');
1483:
1484: DELETE FROM pn_payment_terms_all
1485: WHERE payment_term_id = x_payment_term_id;
1486:
1487: IF (SQL%NOTFOUND) THEN
1488: RAISE NO_DATA_FOUND;

Line 1882: term_rec PN_PAYMENT_TERMS_ALL%ROWTYPE;

1878: p_change_mode IN VARCHAR2,
1879: p_eff_str_dt IN DATE,
1880: p_eff_end_dt IN DATE) IS
1881:
1882: term_rec PN_PAYMENT_TERMS_ALL%ROWTYPE;
1883: n NUMBER(1);
1884: l_dist_change_id NUMBER(15);
1885: l_prev_term_hist_id NUMBER(15);
1886: l_new_term_id NUMBER(15);

Line 1904: FROM pn_payment_terms_all

1900: l_changed_flag pn_payment_terms.changed_flag%TYPE;
1901:
1902: CURSOR get_term_cur(p_term_id IN NUMBER) IS
1903: SELECT *
1904: FROM pn_payment_terms_all
1905: WHERE payment_term_id = p_term_id;
1906:
1907: CURSOR get_dist_cur(p_term_id IN NUMBER) IS
1908: SELECT *

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

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

Line 2282: UPDATE pn_payment_terms_all

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

Line 2646: UPDATE pn_payment_terms_all

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

Line 2742: UPDATE pn_payment_terms_all

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

Line 3034: INSERT INTO pn_payment_terms_all

3030: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_str_dt : '||l_str_dt);
3031: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_end_dt : '||l_end_dt);
3032: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Terms table.');
3033:
3034: INSERT INTO pn_payment_terms_all
3035: (PAYMENT_TERM_ID
3036: ,LAST_UPDATE_DATE
3037: ,LAST_UPDATED_BY
3038: ,CREATION_DATE

Line 3636: FROM pn_payment_terms_all

3632: l_agreement_number VARCHAR2(30) := NULL;
3633:
3634: CURSOR c1 IS
3635: SELECT opex_agr_id,index_period_id,var_rent_inv_id,rec_agr_line_id
3636: FROM pn_payment_terms_all
3637: where payment_term_id = p_payment_term_id;
3638:
3639: BEGIN
3640:

Line 3740: FROM pn_payment_terms_all

3736: index_period_id,
3737: var_rent_inv_id,
3738: rec_agr_line_id,
3739: source_code
3740: FROM pn_payment_terms_all
3741: where payment_term_id = p_payment_term_id;
3742:
3743: BEGIN
3744:

Line 3775: UPDATE pn_payment_terms_all

3771: BEGIN
3772:
3773: pnp_debug_pkg.debug ('PNT_PAYMENT_TERMS_PKG.MODIFY_ROW (+)');
3774:
3775: UPDATE pn_payment_terms_all
3776: SET changed_flag = x_changed_flag
3777: WHERE payment_term_id = NVL(x_payment_term_id ,payment_term_id )
3778: AND var_rent_inv_id = x_var_rent_inv_id;
3779: