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_LINES_INT_ALL

Line 33: UPDATE ozf_sd_batch_lines_int_all

29:
30: BEGIN
31: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_stale_data_batch_line', 'Procedure Starts');
32:
33: UPDATE ozf_sd_batch_lines_int_all
34: SET processed_flag = 'S',
35: last_update_date = sysdate,
36: last_updated_by = fnd_global.user_id
37: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 321: INSERT INTO ozf_sd_batch_lines_int_all

317: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::populate_interface',
318: 'WebADI Batch - before inserting into interface table');
319:
320: BEGIN
321: INSERT INTO ozf_sd_batch_lines_int_all
322: (batch_line_int_id,
323: frm_contact1_name,
324: frm_contact1_email,
325: frm_contact1_fax,

Line 583: (ozf_sd_batch_lines_int_all_s.nextval,

579: line_attribute29,
580: line_attribute30
581: )
582: VALUES
583: (ozf_sd_batch_lines_int_all_s.nextval,
584: p_to_cntct1_name,
585: p_to_cntct1_email,
586: p_to_cntct1_fax,
587: p_to_cntct1_phone,

Line 980: FROM ozf_sd_batch_lines_int_all bint, ozf_sd_batch_lines_all lines, ozf_claim_types_all_vl clm

976: WHERE fu.utilization_id = lines.utilization_id
977: AND lines.batch_id = p_batch_number),
978: lines.claim_amount)
979: END computed_batch_curr_claim_amt
980: FROM ozf_sd_batch_lines_int_all bint, ozf_sd_batch_lines_all lines, ozf_claim_types_all_vl clm
981: WHERE ship_frm_sd_claim_request_id = p_batch_number
982: AND processed_flag = 'N'
983: AND bint.ship_frm_sd_claim_request_id = lines.batch_id
984: AND bint.batch_line_number = lines.batch_line_number

Line 1002: UPDATE ozf_sd_batch_lines_int_all

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
1003: SET validation_txt = 'Batch ID does not exist',
1004: last_update_date = sysdate,
1005: last_updated_by = fnd_global.user_id
1006: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 1025: UPDATE ozf_sd_batch_lines_int_all

1021: --raising business event
1022: ozf_sd_util_pvt.sd_raise_event (l_batch_id, 'RESPONSE', x_return_status);
1023:
1024: IF l_batch_status NOT IN ('WIP','SUBMITTED' ) THEN
1025: UPDATE ozf_sd_batch_lines_int_all
1026: SET processed_flag = 'E',
1027: validation_txt = 'Batch not in WIP or SUBMITTED status',
1028: last_update_date = sysdate,
1029: last_updated_by = fnd_global.user_id

Line 1041: FROM ozf_sd_batch_lines_int_all

1037:
1038: --check whether lines exist for given batch id
1039: SELECT COUNT(1)
1040: INTO l_cnt_line
1041: FROM ozf_sd_batch_lines_int_all
1042: WHERE ship_frm_sd_claim_request_id = p_batch_number
1043: AND processed_flag = 'N';
1044:
1045: IF l_cnt_line = 0 THEN

Line 1046: UPDATE ozf_sd_batch_lines_int_all

1042: WHERE ship_frm_sd_claim_request_id = p_batch_number
1043: AND processed_flag = 'N';
1044:
1045: IF l_cnt_line = 0 THEN
1046: UPDATE ozf_sd_batch_lines_int_all
1047: SET validation_txt = 'There are no Lines for this Batch ID',
1048: last_update_date = sysdate,
1049: last_updated_by = fnd_global.user_id
1050: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 1072: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr

1068: BEGIN
1069: DELETE ozf_sd_batch_line_disputes
1070: WHERE batch_id = l_batch_id
1071: AND batch_line_id IN (SELECT bl.batch_line_id
1072: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr
1073: WHERE bl.batch_id = l_batch_id
1074: AND bl.batch_id = intr.ship_frm_sd_claim_request_id
1075: AND bl.batch_line_number = intr.batch_line_number
1076: AND intr.processed_flag = 'N'

Line 1126: FROM ozf_sd_batch_lines_int_all intr,

1122: FROM -- No rejection code for rejected line
1123: ( SELECT intr.batch_id,
1124: intr.batch_line_id,
1125: 'OZF_SD_MISSING_REJ_CODE' dispute_code
1126: FROM ozf_sd_batch_lines_int_all intr,
1127: ozf_sd_batch_lines_all bl
1128: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1129: AND intr.processed_flag = 'N'
1130: AND bl.purge_flag <> 'Y'

Line 1150: FROM ozf_sd_batch_lines_int_all intr

1146:
1147: SELECT intr.batch_id,
1148: intr.batch_line_id,
1149: 'OZF_SD_NO_RESPONSE' dispute_code
1150: FROM ozf_sd_batch_lines_int_all intr
1151: WHERE ship_frm_sd_claim_request_id = p_batch_number
1152: AND processed_flag = 'N'
1153: AND ( (gbl_claim_disposition_code IS NULL) OR ( gbl_claim_disposition_code NOT IN ('APPROVED', 'REJECTED') ) )
1154:

Line 1161: FROM ozf_sd_batch_lines_int_all intr,

1157:
1158: SELECT intr.batch_id,
1159: intr.batch_line_id,
1160: 'OZF_SD_CURR_CODE_MISMATCH' dispute_code
1161: FROM ozf_sd_batch_lines_int_all intr,
1162: ozf_sd_batch_lines_all bl
1163: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1164: AND intr.processed_flag = 'N'
1165: AND bl.purge_flag <> 'Y'

Line 1176: FROM ozf_sd_batch_lines_int_all intr,

1172:
1173: SELECT intr.batch_id,
1174: intr.batch_line_id,
1175: 'OZF_SD_VENDOR_AUTH_AMT_NGTVE' dispute_code
1176: FROM ozf_sd_batch_lines_int_all intr,
1177: ozf_sd_batch_lines_all bl
1178: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1179: AND intr.processed_flag = 'N'
1180: AND bl.purge_flag <> 'Y'

Line 1191: FROM ozf_sd_batch_lines_int_all intr,

1187:
1188: SELECT intr.batch_id,
1189: intr.batch_line_id,
1190: 'OZF_SD_VENDOR_AUTH_QTY_NGTVE' dispute_code
1191: FROM ozf_sd_batch_lines_int_all intr,
1192: ozf_sd_batch_lines_all bl
1193: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1194: AND intr.processed_flag = 'N'
1195: AND bl.purge_flag <> 'Y'

Line 1207: FROM ozf_sd_batch_lines_int_all intr,

1203:
1204: SELECT intr.batch_id,
1205: intr.batch_line_id,
1206: 'OZF_SD_AUTH_AMT_QTY_NULL' dispute_code
1207: FROM ozf_sd_batch_lines_int_all intr,
1208: ozf_sd_batch_lines_all bl
1209: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1210: AND intr.processed_flag = 'N'
1211: AND bl.purge_flag <> 'Y'

Line 1365: UPDATE ozf_sd_batch_lines_int_all

1361: last_updated_by = fnd_global.user_id
1362: WHERE batch_id = l_batch_id;
1363:
1364: --Mark all rows as processed
1365: UPDATE ozf_sd_batch_lines_int_all
1366: SET processed_flag = 'Y',
1367: last_update_date = sysdate,
1368: last_updated_by = fnd_global.user_id
1369: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 1499: UPDATE ozf_sd_batch_lines_int_all

1495: last_updated_by = fnd_global.user_id
1496: WHERE batch_id = l_batch_id;
1497:
1498: --Mark all rows as processed
1499: UPDATE ozf_sd_batch_lines_int_all
1500: SET processed_flag = 'Y',
1501: last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id
1503: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 1702: UPDATE ozf_sd_batch_lines_int_all

1698: last_update_date = sysdate,
1699: last_updated_by = fnd_global.user_id
1700: WHERE batch_id = l_batch_id;
1701:
1702: UPDATE ozf_sd_batch_lines_int_all
1703: SET processed_flag = 'Y',
1704: last_update_date = sysdate,
1705: last_updated_by = fnd_global.user_id
1706: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 1728: UPDATE ozf_sd_batch_lines_int_all

1724: last_updated_by = fnd_global.user_id
1725: WHERE batch_id = l_batch_id;
1726:
1727: --Mark all rows as processed
1728: UPDATE ozf_sd_batch_lines_int_all
1729: SET processed_flag = 'Y',
1730: last_update_date = sysdate,
1731: last_updated_by = fnd_global.user_id
1732: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 1758: UPDATE ozf_sd_batch_lines_int_all

1754: last_updated_by = fnd_global.user_id
1755: WHERE batch_id = l_batch_id;
1756:
1757: --Mark all rows as processed
1758: UPDATE ozf_sd_batch_lines_int_all
1759: SET processed_flag = 'Y',
1760: last_update_date = sysdate,
1761: last_updated_by = fnd_global.user_id
1762: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 2009: UPDATE ozf_sd_batch_lines_int_all

2005: last_updated_by = fnd_global.user_id
2006: WHERE batch_id = l_batch_id;
2007:
2008: --Mark all rows as processed
2009: UPDATE ozf_sd_batch_lines_int_all
2010: SET processed_flag = 'Y',
2011: last_update_date = sysdate,
2012: last_updated_by = fnd_global.user_id
2013: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 2287: UPDATE ozf_sd_batch_lines_int_all

2283: last_update_date = sysdate,
2284: last_updated_by = fnd_global.user_id
2285: WHERE batch_id = l_batch_id;
2286:
2287: UPDATE ozf_sd_batch_lines_int_all
2288: SET processed_flag = 'Y',
2289: last_update_date = sysdate,
2290: last_updated_by = fnd_global.user_id
2291: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 2311: UPDATE ozf_sd_batch_lines_int_all

2307: last_updated_by = fnd_global.user_id
2308: WHERE batch_id = l_batch_id;
2309:
2310: --Mark all rows as processed
2311: UPDATE ozf_sd_batch_lines_int_all
2312: SET processed_flag = 'Y',
2313: last_update_date = sysdate,
2314: last_updated_by = fnd_global.user_id
2315: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 2340: UPDATE ozf_sd_batch_lines_int_all

2336: last_updated_by = fnd_global.user_id
2337: WHERE batch_id = l_batch_id;
2338:
2339: --Mark all rows as processed
2340: UPDATE ozf_sd_batch_lines_int_all
2341: SET processed_flag = 'Y',
2342: last_update_date = sysdate,
2343: last_updated_by = fnd_global.user_id
2344: WHERE ship_frm_sd_claim_request_id = p_batch_number

Line 3463: ozf_sd_batch_lines_int_all bint

3459: bint.gbl_claim_rej_code8,
3460: bint.gbl_claim_rej_code9,
3461: bint.gbl_claim_rej_code10
3462: FROM ozf_sd_batch_lines_all bl,
3463: ozf_sd_batch_lines_int_all bint
3464: WHERE bl.batch_id = bint.ship_frm_sd_claim_request_id
3465: AND bl.batch_line_number = bint.batch_line_number
3466: AND bint.GBL_CLAIM_DISPOSITION_CODE = 'REJECTED'
3467: AND bint.ship_frm_sd_claim_request_id = p_batch_number