APPS.OZF_SD_BATCH_FEED_PVT dependencies on OZF_SD_BATCH_LINES_ALL

Line 742: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr

738: BEGIN
739: DELETE ozf_sd_batch_line_disputes
740: WHERE batch_id = l_batch_id
741: AND batch_line_id IN (SELECT bl.batch_line_id
742: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr
743: WHERE bl.batch_id = l_batch_id
744: AND bl.batch_id = intr.ship_frm_sd_claim_request_id
745: AND bl.batch_line_number = intr.batch_line_number
746: AND intr.processed_flag = 'N'

Line 762: UPDATE ozf_sd_batch_lines_all

758: AND processed_flag = 'N')
759:
760: LOOP
761:
762: UPDATE ozf_sd_batch_lines_all
763: SET vendor_ref_id = v_vendor_ref.credit_reference_id
764: WHERE batch_id = l_batch_id
765: AND batch_line_number = v_vendor_ref.batch_line_number
766: AND purge_flag <> 'Y';

Line 772: FROM ozf_sd_batch_lines_all

768: END LOOP;
769:
770: -- cursor to check if lines are in SUBMITTED status (response for lines in already REJECTED status should be marked as error )
771: FOR v_batch_lines IN (SELECT batch_id, batch_line_number, batch_line_id, status_code
772: FROM ozf_sd_batch_lines_all
773: WHERE batch_id = l_batch_id
774: AND purge_flag <> 'Y')
775: LOOP
776: IF v_batch_lines.status_code <> 'SUBMITTED' THEN

Line 812: UPDATE ozf_sd_batch_lines_all

808:
809: x_return_status := fnd_api.g_ret_sts_error;
810: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');
811:
812: UPDATE ozf_sd_batch_lines_all
813: SET status_code = 'REJECTED',
814: approved_amount = v_missing_invalid_sts_lines.vendor_auth_cost_monetary_amt,
815: approved_currency_code = v_missing_invalid_sts_lines.vendor_auth_cost_currency_code,
816: object_version_number = object_version_number + 1,

Line 834: UPDATE ozf_sd_batch_lines_all

830: AND processed_flag = 'N'
831: AND gbl_claim_disposition_code = 'REJECTED')
832: LOOP
833:
834: UPDATE ozf_sd_batch_lines_all
835: SET status_code = 'REJECTED',
836: approved_amount = v_reject_lines.vendor_auth_cost_monetary_amt,
837: approved_currency_code = v_reject_lines.vendor_auth_cost_currency_code,
838: object_version_number = object_version_number + 1,

Line 855: UPDATE ozf_sd_batch_lines_all

851: AND processed_flag = 'N'
852: AND gbl_claim_disposition_code = 'APPROVED')
853: LOOP
854:
855: UPDATE ozf_sd_batch_lines_all
856: SET status_code = 'APPROVED',
857: approved_amount = agreement_price,
858: approved_currency_code = agreement_currency_code,
859: object_version_number = object_version_number + 1,

Line 871: FROM ozf_sd_batch_lines_all

867:
868: --get total number of lines
869: SELECT COUNT(1)
870: INTO l_cnt_tot_line
871: FROM ozf_sd_batch_lines_all
872: WHERE batch_id = l_batch_id
873: AND purge_flag <> 'Y';
874:
875: --get number of approved lines

Line 878: FROM ozf_sd_batch_lines_all

874:
875: --get number of approved lines
876: SELECT COUNT(1)
877: INTO l_cnt_approved_lines
878: FROM ozf_sd_batch_lines_all
879: WHERE batch_id = l_batch_id
880: AND status_code = 'APPROVED'
881: AND purge_flag <> 'Y';
882:

Line 886: FROM ozf_sd_batch_lines_all

882:
883: --get number of rejected lines
884: SELECT COUNT(1)
885: INTO l_cnt_rejected_lines
886: FROM ozf_sd_batch_lines_all
887: WHERE batch_id = l_batch_id
888: AND status_code = 'REJECTED'
889: AND purge_flag <> 'Y';
890:

Line 1089: FROM ozf_sd_batch_lines_all

1085: update_rejected_line_data(l_batch_number, p_batch_id, l_new_batch_id, x_return_status, x_msg_data);
1086:
1087: -- cursor to update batch_id of all APPROVED lines with New Batch Id
1088: FOR v_update_batch IN (SELECT batch_id, batch_line_number, batch_line_id
1089: FROM ozf_sd_batch_lines_all
1090: WHERE batch_id = p_batch_id
1091: AND status_code = 'APPROVED'
1092: AND purge_flag <> 'Y')
1093: LOOP

Line 1095: UPDATE ozf_sd_batch_lines_all

1091: AND status_code = 'APPROVED'
1092: AND purge_flag <> 'Y')
1093: LOOP
1094:
1095: UPDATE ozf_sd_batch_lines_all
1096: SET batch_id = l_new_batch_id,
1097: object_version_number = object_version_number + 1,
1098: last_update_date = sysdate,
1099: last_updated_by = fnd_global.user_id

Line 1136: FROM ozf_sd_batch_lines_all bl,

1132: bint.gbl_claim_rej_code7,
1133: bint.gbl_claim_rej_code8,
1134: bint.gbl_claim_rej_code9,
1135: bint.gbl_claim_rej_code10
1136: FROM ozf_sd_batch_lines_all bl,
1137: ozf_sd_batch_lines_int_all bint
1138: WHERE bl.batch_id = bint.ship_frm_sd_claim_request_id
1139: AND bl.batch_line_number = bint.batch_line_number
1140: AND bl.status_code = 'REJECTED'

Line 1309: FROM ozf_sd_batch_lines_int_all intr, ozf_sd_batch_lines_all bl

1305: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_rejected_line_data',
1306: 'Procedure Starts: Batch number -> '||p_batch_number||' Batch Id -> '||p_batch_id|| ' New Batch Id -> '||new_batch_id);
1307:
1308: FOR v_rejected_lines IN (SELECT intr.*
1309: FROM ozf_sd_batch_lines_int_all intr, ozf_sd_batch_lines_all bl
1310: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1311: AND intr.processed_flag = 'N'
1312: AND bl.purge_flag <> 'Y'
1313: AND intr.gbl_claim_disposition_code = 'REJECTED'

Line 1343: FROM ozf_sd_batch_lines_all

1339: END IF;
1340:
1341: SELECT claim_amount_currency_code
1342: INTO l_currency_code
1343: FROM ozf_sd_batch_lines_all
1344: WHERE batch_id = p_batch_id
1345: AND batch_line_number = v_rejected_lines.batch_line_number;
1346:
1347: IF l_currency_code <> v_rejected_lines.vendor_auth_cost_currency_code THEN

Line 1376: UPDATE ozf_sd_batch_lines_all

1372: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');
1373:
1374: END IF;
1375:
1376: UPDATE ozf_sd_batch_lines_all
1377: SET approved_amount = v_rejected_lines.vendor_auth_cost_monetary_amt,
1378: approved_currency_code = v_rejected_lines.vendor_auth_cost_currency_code,
1379: object_version_number = object_version_number + 1,
1380: last_update_date = sysdate,