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.ICX_REQ_SUBMIT dependencies on ICX_SHOPPING_CARTS

Line 473: from icx_shopping_carts

469:
470:
471: cursor get_req_num(l_cart_id number) is
472: select REQ_NUMBER_SEGMENT1
473: from icx_shopping_carts
474: where CART_ID = l_cart_id;
475: begin
476: if (icx_sec.validatesession()) then
477:

Line 802: icx_shopping_carts isc,

798: select hecv.default_code_combination_id employee_default_account_id,
799: msi.expense_account
800: from hr_employees_current_v hecv,
801: mtl_system_items msi,
802: icx_shopping_carts isc,
803: icx_shopping_cart_lines iscl
804: where msi.INVENTORY_ITEM_ID (+) = iscl.ITEM_ID
805: and nvl(msi.ORGANIZATION_ID,
806: nvl(isc.DESTINATION_ORGANIZATION_ID,

Line 842: from icx_shopping_Carts

838: v_action varchar2(100);
839:
840: cursor check_cart_submitted(l_cart_id number, l_shopper number) is
841: select saved_flag
842: from icx_shopping_Carts
843: where cart_id = l_cart_id
844: and shopper_id = l_shopper;
845:
846: cursor get_head_date(l_cart_id number) is

Line 847: select need_by_date from icx_shopping_Carts

843: where cart_id = l_cart_id
844: and shopper_id = l_shopper;
845:
846: cursor get_head_date(l_cart_id number) is
847: select need_by_date from icx_shopping_Carts
848: where cart_id = l_cart_id;
849:
850: v_dcdName varchar2(100);
851:

Line 1009: from icx_shopping_carts

1005: l_po_number varchar2(1000);
1006:
1007: cursor get_reserved_po_number(cartId number,shopperId number) is
1008: select reserved_po_num
1009: from icx_shopping_carts
1010: where cart_id = cartId
1011: and shopper_id = shopperId;
1012:
1013:

Line 1128: update ICX_SHOPPING_CARTS

1124: commit;
1125: end if;
1126: end if;
1127:
1128: update ICX_SHOPPING_CARTS
1129: set APPROVER_ID = decode(icx_approver_id, FND_API.G_MISS_CHAR, APPROVER_ID,
1130: icx_approver_id),
1131: APPROVER_NAME = decode(icx_approver_name,
1132: FND_API.G_MISS_CHAR, APPROVER_NAME,

Line 1344: -- update icx_shopping_Carts

1340: else
1341: p_deliver_to_location := icx_deliver_to_location;
1342: end if;
1343: close get_loc_org_id;
1344: -- update icx_shopping_Carts
1345: -- set DELIVER_TO_LOCATION_ID = null,
1346: -- DESTINATION_ORGANIZATION_ID = d_org_id
1347: -- where CART_ID = v_cart_id
1348: -- and SHOPPER_ID = v_shopper_id;

Line 1351: update icx_shopping_carts

1347: -- where CART_ID = v_cart_id
1348: -- and SHOPPER_ID = v_shopper_id;
1349:
1350: --dc should user p_deliver_to_location_id etc instead
1351: update icx_shopping_carts
1352: set DELIVER_TO_LOCATION_ID = p_deliver_to_location_id,
1353: DELIVER_TO_LOCATIOn = p_deliver_to_location,
1354: DESTINATION_ORGANIZATION_ID = p_deliver_to_org_id
1355: where CART_ID = v_cart_id

Line 1369: update icx_shopping_Carts

1365: ' : ' || icx_deliver_to_location);
1366: v_error_message := FND_MESSAGE.GET;
1367: icx_util.add_error(v_error_message);
1368: storeerror(v_cart_id, v_error_message);
1369: update icx_shopping_Carts
1370: set DELIVER_TO_LOCATION_ID = null,
1371: DESTINATION_ORGANIZATION_ID = d_org_id,
1372: DELIVER_TO_LOCATION = null
1373: where CART_ID = v_cart_id

Line 1416: update icx_shopping_carts

1412: requesterID := -1;
1413: p_requester := null;
1414: end if;
1415: end if;
1416: update icx_shopping_carts
1417: set DELIVER_TO_REQUESTOR_ID = requesterID,
1418: DELIVER_TO_REQUESTOR = p_requester
1419: where CART_ID = v_cart_id
1420: and SHOPPER_ID = v_shopper_id;

Line 1427: update icx_shopping_Carts

1423: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_REQUESTER');
1424: v_error_message := FND_MESSAGE.GET;
1425: icx_util.add_error(v_error_message);
1426: storeerror(v_cart_id, v_error_message);
1427: update icx_shopping_Carts
1428: set DELIVER_TO_REQUESTOR_ID = null,
1429: DELIVER_TO_REQUESTOR = null
1430: where CART_ID = v_cart_id
1431: and SHOPPER_ID = v_shopper_id;

Line 1457: update icx_shopping_carts

1453: requesterID:= null;
1454: else
1455: p_requester := icx_approver_name;
1456: end if;
1457: update icx_shopping_carts
1458: set APPROVER_ID = requesterID,
1459: APPROVER_NAME = p_requester
1460: where cart_id = v_cart_id
1461: and shopper_id = v_shopper_id;

Line 1474: update icx_shopping_carts

1470: v_error_message := FND_MESSAGE.GET;
1471: icx_util.add_error(v_error_message);
1472: storeerror(v_cart_id,v_error_message);
1473: */
1474: update icx_shopping_carts
1475: set APPROVER_ID = null,
1476: APPROVER_NAME = null
1477: where cart_id = v_cart_id
1478: and shopper_id = v_shopper_id;

Line 2059: from icx_shopping_Carts

2055: DELIVER_TO_LOCATION) =
2056: (select DELIVER_TO_LOCATION_ID,
2057: DESTINATION_ORGANIZATION_ID,
2058: DELIVER_TO_LOCATION
2059: from icx_shopping_Carts
2060: where cart_id = v_cart_id)
2061: where cart_id = v_cart_id;
2062: end if;
2063: end if;

Line 2215: from icx_shopping_carts

2211: set (DELIVER_TO_LOCATION_ID,
2212: DESTINATION_ORGANIZATION_ID) =
2213: (select null,
2214: DESTINATION_ORGANIZATION_ID
2215: from icx_shopping_carts
2216: where cart_id = v_cart_id)
2217: where cart_id = v_cart_id
2218: and DELIVER_TO_LOCATION_ID is null;
2219: end if;

Line 2258: update icx_shopping_Carts

2254:
2255: if (icx_util.error_count = 0) then
2256: l_err_loadinterface := 'N';
2257: if user_action = 'SAVE' then
2258: update icx_shopping_Carts
2259: set saved_flag = 1
2260: where cart_id = v_cart_id
2261: and nvl(org_id,-9999) = nvl(n_org_id,-9999);
2262: elsif ((user_action = 'PLACE ORDER') and (supp_count > 0)) then

Line 2265: update icx_shopping_Carts

2261: and nvl(org_id,-9999) = nvl(n_org_id,-9999);
2262: elsif ((user_action = 'PLACE ORDER') and (supp_count > 0)) then
2263: -- Load the req interface table....
2264: -- in here
2265: update icx_shopping_Carts
2266: set saved_flag = 0
2267: where cart_id = v_cart_id
2268: and nvl(org_id, -9999) = nvl(n_org_id, -9999);
2269: begin

Line 2283: update icx_shopping_carts

2279:
2280: end;
2281:
2282: if l_err_loadinterface = 'N' then
2283: update icx_shopping_carts
2284: set saved_flag = '2'
2285: where saved_flag = '0'
2286: and cart_id = v_cart_id
2287: and nvl(org_id, -9999) = nvl(n_org_id, -9999);

Line 2292: update icx_shopping_carts

2288: end if;
2289: end if;
2290: else
2291: -- set saved_flag to 4 (error exists)
2292: update icx_shopping_carts
2293: set saved_flag = '4'
2294: where cart_id = v_cart_id
2295: and nvl(org_id, -9999) = nvl(n_org_id, -9999);
2296:

Line 2301: delete icx_shopping_carts

2297: end if;
2298:
2299: else
2300: -- delete the cart
2301: delete icx_shopping_carts
2302: where cart_id = v_cart_id
2303: and shopper_id = v_shopper_id;
2304:
2305: delete icx_cart_line_distributions