APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_PAYMENT_TERMS_HISTORY

Line 1898: l_adj_type_code pn_payment_terms_history.adjustment_type_code%TYPE;

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

Line 1899: l_term_comments pn_payment_terms_history.term_comments%TYPE;

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

Line 1921: FROM pn_payment_terms_history

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

Line 2070: INSERT INTO pn_payment_terms_history

2066: END LOOP;
2067:
2068: pnp_debug_pkg.debug('create_hist_corr_upd : Inserting in Term Hist. for very first time');
2069:
2070: INSERT INTO pn_payment_terms_history
2071: (
2072: TERM_HISTORY_ID
2073: ,LAST_UPDATE_DATE
2074: ,LAST_UPDATED_BY

Line 2176: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL

2172: ,AREA_TYPE_CODE
2173: ,AREA
2174: ,TERM_COMMENTS)
2175: VALUES
2176: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2177: ,SYSDATE
2178: ,FND_GLOBAL.USER_ID
2179: ,SYSDATE
2180: ,FND_GLOBAL.USER_ID

Line 2416: INSERT INTO pn_payment_terms_history

2412:
2413: pnp_debug_pkg.debug('create_hist_corr_upd : l_adj_type_code :'||l_adj_type_code);
2414: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');
2415:
2416: INSERT INTO pn_payment_terms_history
2417: (TERM_HISTORY_ID
2418: ,LAST_UPDATE_DATE
2419: ,LAST_UPDATED_BY
2420: ,CREATION_DATE

Line 2521: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL

2517: ,AREA_TYPE_CODE
2518: ,AREA
2519: ,TERM_COMMENTS)
2520: VALUES
2521: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2522: ,SYSDATE
2523: ,FND_GLOBAL.USER_ID
2524: ,SYSDATE
2525: ,FND_GLOBAL.USER_ID

Line 2763: INSERT INTO pn_payment_terms_history

2759: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_new_term_id: '||l_new_term_id);
2760: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);
2761: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Term Hist.');
2762:
2763: INSERT INTO pn_payment_terms_history
2764: (TERM_HISTORY_ID
2765: ,LAST_UPDATE_DATE
2766: ,LAST_UPDATED_BY
2767: ,CREATION_DATE

Line 2868: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL

2864: ,AREA_TYPE_CODE
2865: ,AREA
2866: ,TERM_COMMENTS)
2867: VALUES
2868: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
2869: ,SYSDATE
2870: ,FND_GLOBAL.USER_ID
2871: ,SYSDATE
2872: ,FND_GLOBAL.USER_ID

Line 3406: INSERT INTO pn_payment_terms_history

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

Line 3511: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL

3507: ,AREA_TYPE_CODE
3508: ,AREA
3509: ,TERM_COMMENTS)
3510: VALUES
3511: (PN_PAYMENT_TERMS_HISTORY_S.NEXTVAL
3512: ,SYSDATE
3513: ,FND_GLOBAL.USER_ID
3514: ,SYSDATE
3515: ,FND_GLOBAL.USER_ID