APPS.PN_SOI_VOL_IMPORT dependencies on PN_VAR_DEDUCTIONS_ALL

Line 15: -- records in the pn_var_vol_hist_all and pn_var_deductions_all.

11: -- rents.var_rent_id in where clause
12: -- 22-MAR-06 Hareesha o Bug 4731212 Modified import_vol_hist to get
13: -- reporttype and insert into pn_var_vol_hist_all
14: -- 15-JAN-07 Prabhakar o Modified the import_vol_hist procedure to update the
15: -- records in the pn_var_vol_hist_all and pn_var_deductions_all.
16: -- Before updating, the old records will be inserted into
17: -- pn_var_vol_arch_all and pn_var_deduct_arch_all.
18: -- 12-mar-07 Shabda o After we have updated volume history. We set the
19: -- pn_var_lines_all.sales-Vol_update_flag to Y for

Line 147: FROM PN_VAR_DEDUCTIONS_ALL

143: START_DATE,
144: END_DATE,
145: DEDUCTION_TYPE_CODE,
146: DEDUCTION_AMOUNT
147: FROM PN_VAR_DEDUCTIONS_ALL
148: WHERE deduction_id = p_deduction_id;
149:
150: -- Get the details of lines updated.
151: CURSOR get_vr_lines_c(ip_batch_id NUMBER

Line 897: FROM pn_var_deductions_all

893:
894: ELSIF v_lines.volume_type ='DEDUCTION' THEN
895:
896: SELECT NVL(MAX(deduction_num), 0)+1 INTO v_ded_num
897: FROM pn_var_deductions_all
898: WHERE line_item_id = v_lines.line_item_id;
899:
900: IF v_lines.vol_deduct_id IS NULL THEN
901: INSERT INTO pn_var_deductions_all (DEDUCTION_ID

Line 901: INSERT INTO pn_var_deductions_all (DEDUCTION_ID

897: FROM pn_var_deductions_all
898: WHERE line_item_id = v_lines.line_item_id;
899:
900: IF v_lines.vol_deduct_id IS NULL THEN
901: INSERT INTO pn_var_deductions_all (DEDUCTION_ID
902: ,DEDUCTION_NUM
903: ,LAST_UPDATE_DATE
904: ,LAST_UPDATED_BY
905: ,CREATION_DATE

Line 1043: FROM PN_VAR_DEDUCTIONS_ALL

1039: ,ATTRIBUTE13
1040: ,ATTRIBUTE14
1041: ,ATTRIBUTE15
1042: ,ORG_ID
1043: FROM PN_VAR_DEDUCTIONS_ALL
1044: WHERE DEDUCTION_ID = v_lines.vol_deduct_id;
1045:
1046: UPDATE PN_VAR_DEDUCTIONS_ALL
1047: SET LAST_UPDATE_DATE = sysDATE

Line 1046: UPDATE PN_VAR_DEDUCTIONS_ALL

1042: ,ORG_ID
1043: FROM PN_VAR_DEDUCTIONS_ALL
1044: WHERE DEDUCTION_ID = v_lines.vol_deduct_id;
1045:
1046: UPDATE PN_VAR_DEDUCTIONS_ALL
1047: SET LAST_UPDATE_DATE = sysDATE
1048: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
1049: ,LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'), 0)
1050: ,LINE_ITEM_ID = v_lines.line_item_id