APPS.OZF_SD_BATCH_PVT dependencies on OZF_SD_BATCH_HEADERS_ALL

Line 62: SELECT OZF_SD_BATCH_HEADERS_ALL.Creation_Date

58: x_to_amount NUMBER;
59: l_util_id NUMBER;
60: BEGIN
61:
62: SELECT OZF_SD_BATCH_HEADERS_ALL.Creation_Date
63: INTO l_conv_date
64: FROM OZF_SD_BATCH_HEADERS_ALL
65: WHERE batch_id = p_batch_id;
66:

Line 64: FROM OZF_SD_BATCH_HEADERS_ALL

60: BEGIN
61:
62: SELECT OZF_SD_BATCH_HEADERS_ALL.Creation_Date
63: INTO l_conv_date
64: FROM OZF_SD_BATCH_HEADERS_ALL
65: WHERE batch_id = p_batch_id;
66:
67: SELECT OZF_FUNDS_UTILIZED_ALL_B.PLAN_CURR_AMOUNT_REMAINING,
68: OZF_OFFERS.TRANSACTION_CURRENCY_CODE

Line 126: SELECT OZF_SD_BATCH_HEADERS_ALL.Creation_Date

122: x_to_amount NUMBER;
123:
124: BEGIN
125:
126: SELECT OZF_SD_BATCH_HEADERS_ALL.Creation_Date
127: INTO l_conv_date
128: FROM OZF_SD_BATCH_HEADERS_ALL
129: WHERE batch_id = p_batch_id;
130:

Line 128: FROM OZF_SD_BATCH_HEADERS_ALL

124: BEGIN
125:
126: SELECT OZF_SD_BATCH_HEADERS_ALL.Creation_Date
127: INTO l_conv_date
128: FROM OZF_SD_BATCH_HEADERS_ALL
129: WHERE batch_id = p_batch_id;
130:
131:
132: IF p_discount_val_currency <> p_offer_currency then

Line 1031: UPDATE ozf_sd_batch_headers_all

1027: IF OZF_DEBUG_HIGH_ON THEN
1028: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AutoClaim Flag : True.');
1029: END IF;
1030:
1031: UPDATE ozf_sd_batch_headers_all
1032: SET status_code = 'APPROVED'
1033: WHERE batch_id = l_batch_id;
1034: COMMIT;
1035:

Line 1073: UPDATE ozf_sd_batch_headers_all

1069:
1070: --Code added for Bug#6971836
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.');
1072:
1073: UPDATE ozf_sd_batch_headers_all
1074: SET status_code = 'CLOSED',
1075: claim_id = l_claim_id,
1076: last_update_date = sysdate,
1077: last_updated_by = FND_GLOBAL.USER_ID,

Line 1171: SELECT ozf_sd_batch_headers_all_s.nextval INTO l_batch_id FROM dual;

1167: l_supplier_id := p_supplier_id;
1168: l_supplier_site_id := p_supplier_site_id;
1169: l_batch_new := p_batch_new;
1170:
1171: SELECT ozf_sd_batch_headers_all_s.nextval INTO l_batch_id FROM dual;
1172:
1173: l_org_id := p_org_id;
1174: p_batch_id := l_batch_id;
1175: l_batch_threshold := p_batch_threshold;

Line 1223: INSERT INTO ozf_sd_batch_headers_all

1219: IF OZF_DEBUG_HIGH_ON THEN
1220: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Number = ' || to_char(l_claim_number));
1221: END IF;
1222:
1223: INSERT INTO ozf_sd_batch_headers_all
1224: (batch_id,
1225: object_version_number,
1226: batch_number,
1227: claim_number,

Line 2111: || ' FROM ozf_sd_batch_headers_all HDR, ozf_sd_batch_lines_all BLN '

2107: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Start INVOKE_BATCH_AUTO_CLAIM ---');
2108: END IF;
2109:
2110: l_sql := 'SELECT HDR.BATCH_ID, HDR.vendor_site_id, HDR.BATCH_SUBMISSION_DATE '
2111: || ' FROM ozf_sd_batch_headers_all HDR, ozf_sd_batch_lines_all BLN '
2112: || ' WHERE HDR.batch_id = BLN.batch_id'
2113: || ' AND HDR.status_code = ''SUBMITTED'' ';
2114:
2115:

Line 2194: UPDATE OZF_SD_BATCH_HEADERS_ALL

2190:
2191: --Code added for Bug#6971836
2192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.');
2193:
2194: UPDATE OZF_SD_BATCH_HEADERS_ALL
2195: SET status_code = 'CLOSED',
2196: claim_id = l_claim_id,
2197: last_update_date = sysdate,
2198: last_updated_by = FND_GLOBAL.USER_ID,