APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_PAYMENT_TERMS_HISTORY

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