APPS.PN_SOI_VOL_IMPORT dependencies on PN_SOI_VOL_IMPORT

Line 1: PACKAGE BODY PN_SOI_VOL_IMPORT AS

1: PACKAGE BODY PN_SOI_VOL_IMPORT AS
2: /* $Header: PNSOIMPB.pls 120.12 2007/05/04 10:48:21 sraaj ship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : IMPORT_VOL_HIST

Line 212: pnp_debug_pkg.debug ('PN_SOI_VOL_IMPORT .IMPORT_VOL_HIST(+)');

208: lines_t NUM_T;
209:
210: BEGIN
211:
212: pnp_debug_pkg.debug ('PN_SOI_VOL_IMPORT .IMPORT_VOL_HIST(+)');
213: fnd_message.set_name ('PN','PN_SOI_PBATCH');
214: fnd_message.set_token ('ID', p_batch_id);
215: pnp_debug_pkg.put_log_msg(fnd_message.get);
216:

Line 752: PN_SOI_VOL_IMPORT.g_org_id := l_org_id;

748: l_report_type_code <> v_lines.report_type_code OR
749: l_reporting_date <> v_lines.reporting_date THEN
750:
751:
752: PN_SOI_VOL_IMPORT.g_org_id := l_org_id;
753: INSERT INTO PN_VAR_VOL_ARCH_ALL(
754: VOL_ARCH_ID
755: ,LAST_UPDATE_DATE
756: ,LAST_UPDATED_BY

Line 814: ,PN_SOI_VOL_IMPORT.g_org_id

810: ,NVL(fnd_profile.value('USER_ID'), 0)
811: ,sysDATE
812: ,NVL(fnd_profile.value('USER_ID'), 0)
813: ,NVL(fnd_profile.value('USER_ID'), 0)
814: ,PN_SOI_VOL_IMPORT.g_org_id
815: ,VOL_HIST_ID
816: ,VOL_HIST_NUM
817: ,LAST_UPDATE_DATE
818: ,LAST_UPDATED_BY

Line 953: PN_SOI_VOL_IMPORT.g_org_id := l_org_id;

949: l_end_date <> v_lines.rep_end_DATE OR
950: l_deduction_type_code <> v_lines.deduction_type_code OR
951: l_deduction_amount <> NVL(v_ded_amount,0) THEN
952:
953: PN_SOI_VOL_IMPORT.g_org_id := l_org_id;
954: INSERT INTO PN_VAR_DEDUCT_ARCH_ALL(
955: DEDUCT_ARCH_ID
956: ,LAST_UPDATE_DATE
957: ,LAST_UPDATED_BY

Line 1006: ,PN_SOI_VOL_IMPORT.g_org_id

1002: ,NVL(fnd_profile.value('USER_ID'), 0)
1003: ,sysDATE
1004: ,NVL(fnd_profile.value('USER_ID'), 0)
1005: ,NVL(fnd_profile.value('USER_ID'), 0)
1006: ,PN_SOI_VOL_IMPORT.g_org_id
1007: ,DEDUCTION_ID
1008: ,DEDUCTION_NUM
1009: ,LAST_UPDATE_DATE
1010: ,LAST_UPDATED_BY

Line 1188: PNP_DEBUG_PKG.debug ('PN_SOI_VOL_IMPORT .DELETE_VOL_HIST(+)');

1184: l_total_lines_deleted NUMBER := 0 ;
1185: l_error_message VARCHAR2(2000);
1186:
1187: BEGIN
1188: PNP_DEBUG_PKG.debug ('PN_SOI_VOL_IMPORT .DELETE_VOL_HIST(+)');
1189:
1190: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1191: fnd_message.set_token ('ID', p_batch_id);
1192: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1257: END pn_soi_vol_import;

1253: pnp_debug_pkg.debug ('PN_VAR_RENTS_PKG.DELETE_VOL_HIST (-)');
1254:
1255: END delete_vol_hist;
1256:
1257: END pn_soi_vol_import;