APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_DISTRIBUTIONS_HISTORY

Line 1914: FROM pn_distributions_history pdh,

1910: WHERE payment_term_id = p_term_id;
1911:
1912: CURSOR get_max_dist_change_id_cur(p_term_id IN NUMBER) IS
1913: SELECT MAX(pdh.distribution_change_id)
1914: FROM pn_distributions_history pdh,
1915: pn_distributions_all pd
1916: WHERE pdh.distribution_id = pd.distribution_id
1917: AND pd.payment_term_id = p_term_id;
1918:

Line 1995: SELECT pn_distributions_history_s1.NEXTVAL

1991:
1992: IF NVL(p_hist_dist_tab.count,0) <> 0 AND
1993: NVL(tlinfo.term_altered_flag, 'N') = 'N' THEN
1994:
1995: SELECT pn_distributions_history_s1.NEXTVAL
1996: INTO l_dist_change_id
1997: FROM DUAL;
1998:
1999: pnp_debug_pkg.debug('create_hist_corr_upd : l_dist_change_id :'||l_dist_change_id);

Line 2005: INSERT INTO pn_distributions_history

2001: FOR i in 1..p_hist_dist_tab.count LOOP
2002:
2003: pnp_debug_pkg.debug('create_hist_corr_upd : Inserting in Dist. Hist. for very first time');
2004:
2005: INSERT INTO pn_distributions_history
2006: (
2007: DISTRIBUTION_HISTORY_ID
2008: ,LAST_UPDATE_DATE
2009: ,LAST_UPDATED_BY

Line 2037: pn_distributions_history_s.NEXTVAL

2033: ,ATTRIBUTE14
2034: ,ATTRIBUTE15)
2035: VALUES
2036: (
2037: pn_distributions_history_s.NEXTVAL
2038: ,SYSDATE
2039: ,FND_GLOBAL.USER_ID
2040: ,SYSDATE
2041: ,FND_GLOBAL.USER_ID

Line 2290: SELECT pn_distributions_history_s1.NEXTVAL

2286:
2287: IF NVL(p_dist_changed, 0) > 0 AND
2288: p_change_mode = 'CORRECT' THEN
2289:
2290: SELECT pn_distributions_history_s1.NEXTVAL
2291: INTO l_dist_change_id
2292: FROM DUAL;
2293:
2294: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id : '||l_dist_change_id);

Line 2300: INSERT INTO pn_distributions_history

2296: FOR dist_rec IN get_dist_cur(p_term_id) LOOP
2297:
2298: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist.');
2299:
2300: INSERT INTO pn_distributions_history
2301: (
2302: DISTRIBUTION_HISTORY_ID
2303: ,LAST_UPDATE_DATE
2304: ,LAST_UPDATED_BY

Line 2332: pn_distributions_history_s.NEXTVAL

2328: ,ATTRIBUTE14
2329: ,ATTRIBUTE15)
2330: VALUES
2331: (
2332: pn_distributions_history_s.NEXTVAL
2333: ,SYSDATE
2334: ,FND_GLOBAL.USER_ID
2335: ,SYSDATE
2336: ,FND_GLOBAL.USER_ID

Line 2654: SELECT pn_distributions_history_s1.NEXTVAL

2650: changed_flag = 'N',
2651: payment_term_id = l_new_term_id
2652: WHERE payment_term_id = p_term_id;
2653:
2654: SELECT pn_distributions_history_s1.NEXTVAL
2655: INTO l_dist_change_id
2656: FROM DUAL;
2657:
2658: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- l_dist_change_id: '||l_dist_change_id);

Line 2676: INSERT INTO pn_distributions_history

2672: WHERE distribution_id = dist_rec.distribution_id;
2673:
2674: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist.');
2675:
2676: INSERT INTO pn_distributions_history
2677: (DISTRIBUTION_HISTORY_ID
2678: ,LAST_UPDATE_DATE
2679: ,LAST_UPDATED_BY
2680: ,CREATION_DATE

Line 2706: (pn_distributions_history_s.NEXTVAL

2702: ,ATTRIBUTE13
2703: ,ATTRIBUTE14
2704: ,ATTRIBUTE15)
2705: VALUES
2706: (pn_distributions_history_s.NEXTVAL
2707: ,SYSDATE
2708: ,FND_GLOBAL.USER_ID
2709: ,SYSDATE
2710: ,FND_GLOBAL.USER_ID

Line 3235: SELECT pn_distributions_history_s1.NEXTVAL

3231: ,tlinfo.term_comments);
3232:
3233: IF NVL(p_hist_dist_tab.count,0) <> 0 THEN
3234:
3235: SELECT pn_distributions_history_s1.NEXTVAL
3236: INTO l_dist_change_id
3237: FROM DUAL;
3238:
3239: l_insert_dist_hist := 'N';

Line 3333: INSERT INTO pn_distributions_history

3329: IF l_insert_dist_hist = 'Y' THEN
3330:
3331: pnp_debug_pkg.debug('create_hist_corr_upd : '||p_change_mode|| '- Inserting into Dist. Hist. table.');
3332:
3333: INSERT INTO pn_distributions_history
3334: (DISTRIBUTION_HISTORY_ID
3335: ,LAST_UPDATE_DATE
3336: ,LAST_UPDATED_BY
3337: ,CREATION_DATE

Line 3363: (pn_distributions_history_s.NEXTVAL

3359: ,ATTRIBUTE13
3360: ,ATTRIBUTE14
3361: ,ATTRIBUTE15)
3362: VALUES
3363: (pn_distributions_history_s.NEXTVAL
3364: ,SYSDATE
3365: ,FND_GLOBAL.USER_ID
3366: ,SYSDATE
3367: ,FND_GLOBAL.USER_ID