APPS.OZF_SD_BATCH_FEED_PVT dependencies on OZF_SD_BATCH_HEADERS_ALL

Line 678: FROM ozf_sd_batch_headers_all

674: --Retreive batch id
675: BEGIN
676: SELECT batch_id, status_code
677: INTO l_batch_id, l_batch_status
678: FROM ozf_sd_batch_headers_all
679: WHERE batch_number = p_batch_number;
680: EXCEPTION
681: WHEN NO_DATA_FOUND THEN
682: UPDATE ozf_sd_batch_lines_int_all

Line 901: UPDATE ozf_sd_batch_headers_all

897: IF ( ( l_cnt_rejected_lines = l_cnt_tot_line) OR ( l_cnt_approved_lines = 0 ) ) THEN
898:
899: update_rejected_line_data(p_batch_number, l_batch_id, l_batch_id, x_return_status , x_msg_data );
900:
901: UPDATE ozf_sd_batch_headers_all
902: SET status_code = 'WIP',
903: object_version_number = object_version_number + 1,
904: last_update_date = sysdate,
905: last_updated_by = fnd_global.user_id

Line 927: UPDATE ozf_sd_batch_headers_all

923: IF l_cnt_approved_lines = l_cnt_tot_line THEN
924:
925: --when all lines of WIP/submitted batch get approved, then claim_number to be created without minor_version
926: IF l_batch_status IN ('WIP','SUBMITTED' ) THEN
927: UPDATE ozf_sd_batch_headers_all
928: SET -- claim_number = substr(claim_number,1,instr(claim_number,'_')-1) ,
929: claim_minor_version = NULL
930: where batch_id = l_batch_id;
931: END IF;

Line 933: UPDATE ozf_sd_batch_headers_all

929: claim_minor_version = NULL
930: where batch_id = l_batch_id;
931: END IF;
932:
933: UPDATE ozf_sd_batch_headers_all
934: SET status_code = 'APPROVED',
935: object_version_number = object_version_number + 1,
936: last_update_date = sysdate,
937: last_updated_by = fnd_global.user_id

Line 1048: FROM ozf_sd_batch_headers_all

1044: SELECT batch_number, vendor_id, vendor_site_id, org_id,
1045: currency_code, batch_amount_threshold, batch_line_amount_threshold, claim_number, claim_minor_version
1046: INTO l_batch_number, l_vendor_id, l_vendor_site_id, l_org_id,
1047: l_par_batch_curr_code, l_batch_threshold, l_line_threshold, l_claim_number, l_claim_minor_version
1048: FROM ozf_sd_batch_headers_all
1049: WHERE batch_id = p_batch_id;
1050:
1051: ozf_sd_batch_pvt.create_batch_header(l_vendor_id,
1052: l_vendor_site_id,

Line 1065: UPDATE ozf_sd_batch_headers_all

1061: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CREATE', x_return_status);
1062:
1063:
1064: /*set batch header as WIP for parent batch*/
1065: UPDATE ozf_sd_batch_headers_all
1066: SET status_code = 'WIP',
1067: object_version_number = object_version_number + 1,
1068: claim_minor_version = l_claim_minor_version + 1,
1069: last_update_date = sysdate,

Line 1075: UPDATE ozf_sd_batch_headers_all

1071: -- child_batch_id = l_new_batch_id
1072: WHERE batch_id = p_batch_id;
1073:
1074: /*set batch header as APPROVED for child batch*/
1075: UPDATE ozf_sd_batch_headers_all
1076: SET status_code = 'APPROVED',
1077: parent_batch_id = p_batch_id,
1078: claim_number = l_claim_number||'_'||l_claim_minor_version,
1079: claim_minor_version = l_claim_minor_version,

Line 1281: UPDATE ozf_sd_batch_headers_all

1277: 'Claim API Msg: '|| SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );
1278: END LOOP;
1279:
1280: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN
1281: UPDATE ozf_sd_batch_headers_all
1282: SET status_code = 'CLOSED',
1283: claim_id = l_claim_id,
1284: last_update_date = sysdate,
1285: last_updated_by = fnd_global.user_id,