APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_DISTRIBUTIONS_HISTORY

Line 1910: FROM pn_distributions_history pdh,

1906: WHERE payment_term_id = p_term_id;
1907:
1908: CURSOR get_max_dist_change_id_cur(p_term_id IN NUMBER) IS
1909: SELECT MAX(pdh.distribution_change_id)
1910: FROM pn_distributions_history pdh,
1911: pn_distributions_all pd
1912: WHERE pdh.distribution_id = pd.distribution_id
1913: AND pd.payment_term_id = p_term_id;
1914:

Line 1991: SELECT pn_distributions_history_s1.NEXTVAL

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

Line 2001: INSERT INTO pn_distributions_history

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

Line 2033: pn_distributions_history_s.NEXTVAL

2029: ,ATTRIBUTE14
2030: ,ATTRIBUTE15)
2031: VALUES
2032: (
2033: pn_distributions_history_s.NEXTVAL
2034: ,SYSDATE
2035: ,FND_GLOBAL.USER_ID
2036: ,SYSDATE
2037: ,FND_GLOBAL.USER_ID

Line 2286: SELECT pn_distributions_history_s1.NEXTVAL

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

Line 2296: INSERT INTO pn_distributions_history

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

Line 2328: pn_distributions_history_s.NEXTVAL

2324: ,ATTRIBUTE14
2325: ,ATTRIBUTE15)
2326: VALUES
2327: (
2328: pn_distributions_history_s.NEXTVAL
2329: ,SYSDATE
2330: ,FND_GLOBAL.USER_ID
2331: ,SYSDATE
2332: ,FND_GLOBAL.USER_ID

Line 2650: SELECT pn_distributions_history_s1.NEXTVAL

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

Line 2672: INSERT INTO pn_distributions_history

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

Line 2702: (pn_distributions_history_s.NEXTVAL

2698: ,ATTRIBUTE13
2699: ,ATTRIBUTE14
2700: ,ATTRIBUTE15)
2701: VALUES
2702: (pn_distributions_history_s.NEXTVAL
2703: ,SYSDATE
2704: ,FND_GLOBAL.USER_ID
2705: ,SYSDATE
2706: ,FND_GLOBAL.USER_ID

Line 3231: SELECT pn_distributions_history_s1.NEXTVAL

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

Line 3329: INSERT INTO pn_distributions_history

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

Line 3359: (pn_distributions_history_s.NEXTVAL

3355: ,ATTRIBUTE13
3356: ,ATTRIBUTE14
3357: ,ATTRIBUTE15)
3358: VALUES
3359: (pn_distributions_history_s.NEXTVAL
3360: ,SYSDATE
3361: ,FND_GLOBAL.USER_ID
3362: ,SYSDATE
3363: ,FND_GLOBAL.USER_ID