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_FEED_PVT dependencies on OZF_SD_BATCH_HEADERS_ALL

Line 998: FROM ozf_sd_batch_headers_all

994: --Retreive batch id
995: BEGIN
996: SELECT batch_id, status_code, claim_minor_version, org_id, currency_code,NVL(imd_claim_flag,'N')
997: INTO l_batch_id, l_batch_status, l_claim_minor_version, l_org_id, l_batch_currency,l_imd_claim_flag
998: FROM ozf_sd_batch_headers_all
999: WHERE batch_number = p_batch_number;
1000: EXCEPTION
1001: WHEN NO_DATA_FOUND THEN
1002: UPDATE ozf_sd_batch_lines_int_all

Line 1062: ozf_sd_batch_headers_all bh

1058: SELECT gs.currency_code
1059: INTO l_func_currency
1060: FROM gl_sets_of_books gs,
1061: ozf_sys_parameters_all org,
1062: ozf_sd_batch_headers_all bh
1063: WHERE org.set_of_books_id = gs.set_of_books_id
1064: AND org.org_id = bh.org_id
1065: AND bh.batch_number = p_batch_number;
1066:

Line 1356: UPDATE ozf_sd_batch_headers_all

1352: IF ( NVL(l_cnt_comp_appr_lines,0) + NVL(l_cnt_over_appr_lines,0) = l_cnt_tot_line ) THEN
1353:
1354: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', ' In if block All lines are over approved or completely approved');
1355:
1356: UPDATE ozf_sd_batch_headers_all
1357: SET status_code = 'APPROVED',
1358: claim_minor_version = NULL,
1359: object_version_number = object_version_number + 1,
1360: last_update_date = sysdate,

Line 1490: UPDATE ozf_sd_batch_headers_all

1486: -- Invoke Child batch creation API
1487: PROCESS_CHILD_BATCH(l_batch_id,l_batch_appr_lines_tbl,l_batch_und_appr_lines_tbl,l_batch_over_appr_lines_tbl,l_batch_comp_appr_lines_tbl, x_return_status, x_msg_data);
1488:
1489: --set batch header as WIP for parent batch
1490: UPDATE ozf_sd_batch_headers_all
1491: SET status_code = 'WIP',
1492: object_version_number = object_version_number + 1,
1493: claim_minor_version = l_claim_minor_version + 1,
1494: last_update_date = sysdate,

Line 1695: UPDATE ozf_sd_batch_headers_all

1691: RETURN;
1692:
1693: ELSE
1694:
1695: UPDATE ozf_sd_batch_headers_all
1696: SET status_code = 'WIP',
1697: object_version_number = object_version_number + 1,
1698: last_update_date = sysdate,
1699: last_updated_by = fnd_global.user_id

Line 1719: UPDATE ozf_sd_batch_headers_all

1715:
1716: -- All lines APPROVED case
1717: IF l_cnt_approved_lines = l_cnt_tot_line THEN
1718:
1719: UPDATE ozf_sd_batch_headers_all
1720: SET status_code = 'APPROVED',
1721: claim_minor_version = NULL,
1722: object_version_number = object_version_number + 1,
1723: last_update_date = sysdate,

Line 1749: UPDATE ozf_sd_batch_headers_all

1745: -- This scenario is equivalent to all lines being approved.
1746: IF ( NVL( l_cnt_approved_lines,0) + NVL(l_cnt_comp_appr_lines,0) + NVL(l_cnt_over_appr_lines,0) = l_cnt_tot_line ) THEN
1747:
1748:
1749: UPDATE ozf_sd_batch_headers_all
1750: SET status_code = 'APPROVED',
1751: claim_minor_version = NULL,
1752: object_version_number = object_version_number + 1,
1753: last_update_date = sysdate,

Line 2000: UPDATE ozf_sd_batch_headers_all

1996:
1997: PROCESS_CHILD_BATCH(l_batch_id,l_batch_appr_lines_tbl,l_batch_und_appr_lines_tbl,l_batch_over_appr_lines_tbl,l_batch_comp_appr_lines_tbl, x_return_status, x_msg_data);
1998:
1999: --set batch header as WIP for parent batch
2000: UPDATE ozf_sd_batch_headers_all
2001: SET status_code = 'WIP',
2002: object_version_number = object_version_number + 1,
2003: claim_minor_version = l_claim_minor_version + 1,
2004: last_update_date = sysdate,

Line 2280: UPDATE ozf_sd_batch_headers_all

2276:
2277: IF ( ( l_cnt_rejected_lines = l_cnt_tot_line) OR ( l_cnt_approved_lines = 0 ) ) THEN
2278:
2279:
2280: UPDATE ozf_sd_batch_headers_all
2281: SET status_code = 'WIP',
2282: object_version_number = object_version_number + 1,
2283: last_update_date = sysdate,
2284: last_updated_by = fnd_global.user_id

Line 2302: UPDATE ozf_sd_batch_headers_all

2298:
2299: -- All lines APPROVED case
2300: IF l_cnt_approved_lines = l_cnt_tot_line THEN
2301:
2302: UPDATE ozf_sd_batch_headers_all
2303: SET status_code = 'APPROVED',
2304: claim_minor_version = NULL,
2305: object_version_number = object_version_number + 1,
2306: last_update_date = sysdate,

Line 2331: UPDATE ozf_sd_batch_headers_all

2327:
2328: PROCESS_CHILD_BATCH(l_batch_id, x_return_status, x_msg_data);
2329:
2330: --set batch header as WIP for parent batch
2331: UPDATE ozf_sd_batch_headers_all
2332: SET status_code = 'WIP',
2333: object_version_number = object_version_number + 1,
2334: claim_minor_version = l_claim_minor_version + 1,
2335: last_update_date = sysdate,

Line 2462: FROM ozf_sd_batch_headers_all

2458: SELECT batch_number, vendor_id, vendor_site_id, org_id,
2459: currency_code, batch_amount_threshold, batch_line_amount_threshold, claim_number, claim_minor_version,batch_type,owner_id,currency_code
2460: INTO l_batch_number, l_vendor_id, l_vendor_site_id, l_org_id,
2461: l_par_batch_curr_code, l_batch_threshold, l_line_threshold, l_claim_number, l_claim_minor_version,l_batch_type,l_par_batch_owner_id,l_batch_currency
2462: FROM ozf_sd_batch_headers_all
2463: WHERE batch_id = p_batch_id;
2464:
2465: SELECT gs.currency_code
2466: INTO l_func_currency

Line 2469: ozf_sd_batch_headers_all bh

2465: SELECT gs.currency_code
2466: INTO l_func_currency
2467: FROM gl_sets_of_books gs,
2468: ozf_sys_parameters_all org,
2469: ozf_sd_batch_headers_all bh
2470: WHERE org.set_of_books_id = gs.set_of_books_id
2471: AND org.org_id = bh.org_id
2472: AND bh.batch_id = p_batch_id;
2473:

Line 3186: FROM ozf_sd_batch_headers_all

3182: SELECT batch_number, vendor_id, vendor_site_id, org_id,
3183: currency_code, batch_amount_threshold, batch_line_amount_threshold, claim_number, claim_minor_version,batch_type,owner_id
3184: INTO l_batch_number, l_vendor_id, l_vendor_site_id, l_org_id,
3185: l_par_batch_curr_code, l_batch_threshold, l_line_threshold, l_claim_number, l_claim_minor_version,l_batch_type,l_par_batch_owner_id
3186: FROM ozf_sd_batch_headers_all
3187: WHERE batch_id = p_batch_id;
3188:
3189: ozf_sd_batch_pvt.create_batch_header(l_vendor_id,
3190: l_vendor_site_id,

Line 3259: UPDATE ozf_sd_batch_headers_all

3255:
3256: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::PROCESS_CHILD_BATCH',
3257: ' l_new_batch_id = ' || l_new_batch_id);
3258:
3259: UPDATE ozf_sd_batch_headers_all
3260: SET claim_number = l_claim_number
3261: WHERE batch_id = l_new_batch_id;
3262:
3263: END IF;

Line 3278: UPDATE ozf_sd_batch_headers_all

3274:
3275: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If adjustment is successful
3276: --raising business event
3277: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CLAIM', x_return_status);
3278: UPDATE ozf_sd_batch_headers_all
3279: SET status_code = 'CLOSED',
3280: claim_id = l_claim_id,
3281: last_update_date = sysdate,
3282: last_updated_by = fnd_global.user_id,

Line 3287: UPDATE ozf_sd_batch_headers_all

3283: object_version_number = object_version_number + 1
3284: WHERE batch_id = l_new_batch_id;
3285: ELSE
3286: ROLLBACK TO BEF_INVOKE_CLM_CHILD_BATCH;
3287: UPDATE ozf_sd_batch_headers_all
3288: SET status_code = 'PENDING_CLAIM',
3289: last_update_date = sysdate,
3290: last_updated_by = fnd_global.user_id,
3291: object_version_number = object_version_number + 1

Line 3297: UPDATE ozf_sd_batch_headers_all

3293: END IF; -- If adjustment is successful
3294:
3295: ELSE -- If claim is not successful
3296: ROLLBACK TO BEF_INVOKE_CLM_CHILD_BATCH;
3297: UPDATE ozf_sd_batch_headers_all
3298: SET status_code = 'PENDING_CLAIM',
3299: last_update_date = sysdate,
3300: last_updated_by = fnd_global.user_id,
3301: object_version_number = object_version_number + 1

Line 3384: UPDATE ozf_sd_batch_headers_all

3380:
3381: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::UPDATE_DATA',
3382: ' l_new_batch_id = ' || p_batch_id);
3383:
3384: UPDATE ozf_sd_batch_headers_all
3385: SET claim_number = l_claim_number
3386: WHERE batch_id = p_batch_id;
3387:
3388: END IF;

Line 3405: UPDATE ozf_sd_batch_headers_all

3401:
3402: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3403: --raising business event
3404: ozf_sd_util_pvt.sd_raise_event (p_batch_id, 'CLAIM', x_return_status);
3405: UPDATE ozf_sd_batch_headers_all
3406: SET status_code = 'CLOSED',
3407: claim_id = l_claim_id,
3408: last_update_date = sysdate,
3409: last_updated_by = fnd_global.user_id,

Line 3414: UPDATE ozf_sd_batch_headers_all

3410: object_version_number = object_version_number + 1
3411: WHERE batch_id = p_batch_id;
3412: ELSE -- If adjustment is not successful
3413: ROLLBACK TO BEFORE_INVOKING_CLAIM;
3414: UPDATE ozf_sd_batch_headers_all
3415: SET status_code = 'PENDING_CLAIM',
3416: last_update_date = sysdate,
3417: last_updated_by = fnd_global.user_id,
3418: object_version_number = object_version_number + 1

Line 3425: UPDATE ozf_sd_batch_headers_all

3421:
3422: ELSE -- If claim is not successful
3423:
3424: ROLLBACK TO BEFORE_INVOKING_CLAIM;
3425: UPDATE ozf_sd_batch_headers_all
3426: SET status_code = 'PENDING_CLAIM',
3427: last_update_date = sysdate,
3428: last_updated_by = fnd_global.user_id,
3429: object_version_number = object_version_number + 1