eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_SD_BATCH_PVT dependencies on OZF_SD_BATCH_HEADERS_ALL

Line 186: SELECT OZF_SD_BATCH_HEADERS_ALL.Creation_Date

182: x_to_amount NUMBER;
183:
184: BEGIN
185: /*
186: SELECT OZF_SD_BATCH_HEADERS_ALL.Creation_Date
187: INTO l_conv_date
188: FROM OZF_SD_BATCH_HEADERS_ALL
189: WHERE batch_id = p_batch_id;
190: */

Line 188: FROM OZF_SD_BATCH_HEADERS_ALL

184: BEGIN
185: /*
186: SELECT OZF_SD_BATCH_HEADERS_ALL.Creation_Date
187: INTO l_conv_date
188: FROM OZF_SD_BATCH_HEADERS_ALL
189: WHERE batch_id = p_batch_id;
190: */
191:
192: IF p_discount_val_currency <> p_offer_currency then

Line 1253: UPDATE ozf_sd_batch_headers_all

1249: IF OZF_DEBUG_HIGH_ON THEN
1250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Negative Claim Number = ' || to_char(l_claim_number));
1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_batch_id = ' || l_batch_id);
1252: END IF;
1253: UPDATE ozf_sd_batch_headers_all
1254: SET claim_number = l_claim_number
1255: WHERE batch_id = l_batch_id;
1256:
1257: END IF;

Line 1285: UPDATE ozf_sd_batch_headers_all

1281: IF OZF_DEBUG_HIGH_ON THEN
1282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AutoClaim Flag : True.');
1283: END IF;
1284:
1285: UPDATE ozf_sd_batch_headers_all
1286: SET status_code = 'APPROVED'
1287: WHERE batch_id = l_batch_id;
1288: COMMIT;
1289:

Line 1335: UPDATE ozf_sd_batch_headers_all

1331:
1332: --Code added for Bug#6971836
1333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.');
1334:
1335: UPDATE ozf_sd_batch_headers_all
1336: SET status_code = 'CLOSED',
1337: claim_id = l_claim_id,
1338: last_update_date = sysdate,
1339: last_updated_by = FND_GLOBAL.USER_ID,

Line 1343: UPDATE ozf_sd_batch_headers_all

1339: last_updated_by = FND_GLOBAL.USER_ID,
1340: object_version_number = object_version_number + 1
1341: WHERE batch_id = l_batch_id;
1342: ELSE
1343: UPDATE ozf_sd_batch_headers_all
1344: SET status_code = 'PENDING_CLAIM',
1345: last_update_date = sysdate,
1346: last_updated_by = FND_GLOBAL.USER_ID,
1347: object_version_number = object_version_number + 1

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

1481: l_supplier_id := p_supplier_id;
1482: l_supplier_site_id := p_supplier_site_id;
1483: l_batch_new := p_batch_new;
1484:
1485: SELECT ozf_sd_batch_headers_all_s.nextval INTO l_batch_id FROM dual;
1486:
1487: l_org_id := p_org_id;
1488: p_batch_id := l_batch_id;
1489: l_batch_threshold := p_batch_threshold;

Line 1556: INSERT INTO ozf_sd_batch_headers_all

1552: IF OZF_DEBUG_LOW_ON THEN
1553: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_ssd_imd_claim_flag : ' || l_ssd_imd_claim_flag);
1554: END IF;
1555:
1556: INSERT INTO ozf_sd_batch_headers_all
1557: (batch_id,
1558: object_version_number,
1559: batch_number,
1560: claim_number,

Line 1774: ozf_sd_batch_headers_all bh

1770: SELECT gs.currency_code
1771: INTO l_func_currency
1772: FROM gl_sets_of_books gs,
1773: ozf_sys_parameters_all org,
1774: ozf_sd_batch_headers_all bh
1775: WHERE org.set_of_books_id = gs.set_of_books_id
1776: AND org.org_id = bh.org_id
1777: AND bh.batch_id = p_batch_id;
1778:

Line 2643: ozf_sd_batch_headers_all bh

2639: SELECT gs.currency_code
2640: INTO l_func_currency
2641: FROM gl_sets_of_books gs,
2642: ozf_sys_parameters_all org,
2643: ozf_sd_batch_headers_all bh
2644: WHERE org.set_of_books_id = gs.set_of_books_id
2645: AND org.org_id = bh.org_id
2646: AND bh.batch_id = p_batch_id;
2647:

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

3432: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Start INVOKE_BATCH_AUTO_CLAIM ---');
3433: END IF;
3434:
3435: l_sql := 'SELECT HDR.BATCH_ID, HDR.vendor_site_id, HDR.BATCH_SUBMISSION_DATE '
3436: || ' FROM ozf_sd_batch_headers_all HDR, ozf_sd_batch_lines_all BLN '
3437: || ' WHERE HDR.batch_id = BLN.batch_id'
3438: || ' AND HDR.status_code = ''SUBMITTED'' ';
3439:
3440:

Line 3526: UPDATE OZF_SD_BATCH_HEADERS_ALL

3522:
3523: --Code added for Bug#6971836
3524: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.');
3525:
3526: UPDATE OZF_SD_BATCH_HEADERS_ALL
3527: SET status_code = 'CLOSED',
3528: claim_id = l_claim_id,
3529: last_update_date = sysdate,
3530: last_updated_by = FND_GLOBAL.USER_ID,

Line 3765: FROM ozf_sd_batch_headers_all HDR , ozf_sd_batch_lines_all BLN

3761: l_func_currency VARCHAR2(15);
3762:
3763: CURSOR get_sd_batches_pending_claim(c_org_id NUMBER,c_vendor_id NUMBER,c_vendor_site_id NUMBER,c_batch_id NUMBER) IS
3764: SELECT HDR.BATCH_ID batch_id, HDR.CURRENCY_CODE currency_code
3765: FROM ozf_sd_batch_headers_all HDR , ozf_sd_batch_lines_all BLN
3766: WHERE HDR.batch_id = BLN.batch_id
3767: AND HDR.status_code = 'PENDING_CLAIM'
3768: AND HDR.org_id = NVL(c_org_id,HDR.org_id)
3769: AND HDR.vendor_id = NVL(c_vendor_id,HDR.vendor_id)

Line 3788: ozf_sd_batch_headers_all bh

3784: SELECT gs.currency_code
3785: INTO l_func_currency
3786: FROM gl_sets_of_books gs,
3787: ozf_sys_parameters_all org,
3788: ozf_sd_batch_headers_all bh
3789: WHERE org.set_of_books_id = gs.set_of_books_id
3790: AND org.org_id = bh.org_id
3791: AND bh.batch_id = batch_rec.BATCH_ID;
3792:

Line 3885: UPDATE OZF_SD_BATCH_HEADERS_ALL

3881: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(batch_rec.BATCH_ID, 'F', l_ret_status, l_msg_count, l_msg_data);
3882:
3883: IF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN -- If adjustment is successful
3884:
3885: UPDATE OZF_SD_BATCH_HEADERS_ALL
3886: SET status_code = 'CLOSED',
3887: claim_id = l_claim_id,
3888: last_update_date = sysdate,
3889: last_updated_by = FND_GLOBAL.USER_ID,

Line 3899: UPDATE ozf_sd_batch_headers_all

3895:
3896: ELSE -- If adjustment is not successful
3897:
3898: ROLLBACK TO BEFORE_INVOKE_CLAIM;
3899: UPDATE ozf_sd_batch_headers_all
3900: SET status_code = 'PENDING_CLAIM',
3901: last_update_date = sysdate,
3902: last_updated_by = fnd_global.user_id,
3903: object_version_number = object_version_number + 1

Line 3913: UPDATE ozf_sd_batch_headers_all

3909: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim process failed.');
3910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim process failed.');
3911:
3912: ROLLBACK TO BEFORE_INVOKE_CLAIM;
3913: UPDATE ozf_sd_batch_headers_all
3914: SET status_code = 'PENDING_CLAIM',
3915: last_update_date = sysdate,
3916: last_updated_by = fnd_global.user_id,
3917: object_version_number = object_version_number + 1