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_CART_LINES

Line 150: v_lines_region := 'ICX_SHOPPING_CART_LINES_EMG_R';

146: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
147:
148: if p_emergency = 'YES' then
149: v_header_region := 'ICX_SHOPPING_CART_HEADER_EMG_R';
150: v_lines_region := 'ICX_SHOPPING_CART_LINES_EMG_R';
151: else
152: v_header_region := 'ICX_SHOPPING_CART_HEADER_R';
153: v_lines_region := 'ICX_SHOPPING_CART_LINES_R';
154: end if;

Line 153: v_lines_region := 'ICX_SHOPPING_CART_LINES_R';

149: v_header_region := 'ICX_SHOPPING_CART_HEADER_EMG_R';
150: v_lines_region := 'ICX_SHOPPING_CART_LINES_EMG_R';
151: else
152: v_header_region := 'ICX_SHOPPING_CART_HEADER_R';
153: v_lines_region := 'ICX_SHOPPING_CART_LINES_R';
154: end if;
155:
156:
157: -- Where clause

Line 791: FROM icx_shopping_cart_lines

787: where employee_id = v_preparer_id;
788:
789: cursor get_line_count(v_cart_id number) is
790: SELECT count(1)
791: FROM icx_shopping_cart_lines
792: WHERE cart_id = v_cart_id;
793:
794: i BINARY_INTEGER;
795:

Line 803: icx_shopping_cart_lines iscl

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,
807: iscl.DESTINATION_ORGANIZATION_ID)) =

Line 823: from icx_shopping_cart_lines

819: where gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
820:
821: cursor invalid_locations(l_cart_id number, v_oo_id number) is
822: select cart_line_number, DELIVER_TO_LOCATION
823: from icx_shopping_cart_lines
824: where DELIVER_TO_LOCATION_ID is null
825: and cart_id = v_cart_id
826: and nvl(org_id, -9999) = nvl(v_oo_id, -9999);
827:

Line 834: select cart_line_id from icx_shopping_cart_lines

830: FROM HR_EMPLOYEES_CURRENT_V
831: where full_name = approver;
832:
833: cursor line_ids(v_cart_id number) is
834: select cart_line_id from icx_shopping_cart_lines
835: where (quantity is null
836: OR quantity = 0);
837:
838: v_action varchar2(100);

Line 994: icx_shopping_cart_lines

990:
991:
992: cursor cart_lines(v_cart_id number) is
993: select cart_line_id from
994: icx_shopping_cart_lines
995: where cart_id = v_cart_id;
996:
997: d_shopper_name varchar2(100);
998: d_location_id number;

Line 1834: update icx_shopping_cart_lines

1830: end if;
1831:
1832:
1833:
1834: update icx_shopping_cart_lines
1835: set LAST_UPDATE_DATE = sysdate,
1836: LAST_UPDATED_BY = v_shopper_id,
1837: CATEGORY_ID = decode(c_category_id, 0, CATEGORY_ID,
1838: a_category_id(i)),

Line 2037: update icx_shopping_cart_lines

2033: -- LOcation Location Location
2034:
2035: if (c_DELIVER_TO_LOCATION_L > 0) then
2036: --Location was on
2037: update icx_shopping_cart_lines
2038: set (DELIVER_TO_LOCATION_ID, DESTINATION_ORGANIZATION_ID) =
2039: (select hrl.location_id,
2040: nvl(hrl.inventory_organization_id,
2041: fsp.inventory_organization_id)

Line 2046: icx_shopping_cart_lines.DELIVER_TO_LOCATION)

2042: from hr_locations hrl,
2043: financials_system_parameters fsp
2044: where sysdate < nvl(hrl.inactive_date, sysdate + 1)
2045: and hrl.location_code =
2046: icx_shopping_cart_lines.DELIVER_TO_LOCATION)
2047: where DELIVER_TO_LOCATION_ID is null
2048: and CART_ID = v_cart_id;
2049:
2050: else

Line 2053: update icx_shopping_cart_lines

2049:
2050: else
2051: -- if location on at parent copy org from the parent
2052: if (icx_deliver_to_location <> FND_API.G_MISS_CHAR) then
2053: update icx_shopping_cart_lines
2054: set (DELIVER_TO_LOCATION_ID, DESTINATION_ORGANIZATION_ID,
2055: DELIVER_TO_LOCATION) =
2056: (select DELIVER_TO_LOCATION_ID,
2057: DESTINATION_ORGANIZATION_ID,

Line 2068: update icx_shopping_cart_lines

2064:
2065: -- If supplier can be entered and the field is blank, set to the first line
2066:
2067: if (c_suggested_vendor_namea > 0) then
2068: update icx_shopping_cart_lines
2069: set (SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE,
2070: SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_SITE) =
2071: (select SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE,
2072: SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_SITE

Line 2073: from icx_shopping_cart_lines

2069: set (SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE,
2070: SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_SITE) =
2071: (select SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE,
2072: SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_SITE
2073: from icx_shopping_cart_lines
2074: where cart_id = v_cart_id
2075: and cart_line_number = (select min(cart_line_number)
2076: from icx_shopping_cart_lines
2077: where cart_id = v_cart_id

Line 2076: from icx_shopping_cart_lines

2072: SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_SITE
2073: from icx_shopping_cart_lines
2074: where cart_id = v_cart_id
2075: and cart_line_number = (select min(cart_line_number)
2076: from icx_shopping_cart_lines
2077: where cart_id = v_cart_id
2078: and suggested_vendor_name is not NULL))
2079:
2080: where cart_id = v_cart_id

Line 2182: delete icx_shopping_cart_lines

2178: for prec in line_ids(v_cart_id) loop
2179: delete icx_cart_line_distributions
2180: where cart_line_id = prec.cart_line_id;
2181: end loop;
2182: delete icx_shopping_cart_lines
2183: where (quantity is null
2184: or quantity = 0)
2185: and cart_id = v_cart_id;
2186:

Line 2210: update icx_shopping_cart_lines

2206: v_error_message := FND_MESSAGE.GET || ': ' || v_error_message;
2207: icx_util.add_error(v_error_message);
2208: storeerror(v_cart_id,v_error_message);
2209: end loop;
2210: update icx_shopping_cart_lines
2211: set (DELIVER_TO_LOCATION_ID,
2212: DESTINATION_ORGANIZATION_ID) =
2213: (select null,
2214: DESTINATION_ORGANIZATION_ID

Line 2224: FROM icx_shopping_cart_lines

2220:
2221: if (emergency = 'YES') then
2222: -- in an emergency, you can only have one supplier
2223: SELECT count(distinct(SUGGESTED_VENDOR_NAME)) into supp_count
2224: FROM icx_shopping_cart_lines
2225: where cart_id = v_cart_id;
2226:
2227: if (supp_count > 1) then
2228: FND_MESSAGE.SET_NAME('ICX','ICX_EMERGENCY_PO_VENDOR');

Line 2233: v_error_message := icx_util.getPrompt(601,'ICX_SHOPPING_CART_LINES_EMG_R',178,'ICX_SUGGESTED_VENDOR_NAME');

2229: v_error_message := FND_MESSAGE.GET;
2230: icx_util.add_error(v_error_message);
2231: storeerror(v_cart_id,v_error_message);
2232: elsif (supp_count = 0) then
2233: v_error_message := icx_util.getPrompt(601,'ICX_SHOPPING_CART_LINES_EMG_R',178,'ICX_SUGGESTED_VENDOR_NAME');
2234: FND_MESSAGE.SET_NAME('ICX','ICX_REQUIRED_FIELD');
2235: FND_MESSAGE.SET_TOKEN('FIELD_NAME_TOKEN',v_error_message);
2236: v_error_message := FND_MESSAGE.GET;
2237:

Line 2308: delete icx_shopping_cart_lines

2304:
2305: delete icx_cart_line_distributions
2306: where cart_id = v_cart_id;
2307:
2308: delete icx_shopping_cart_lines
2309: where cart_id = v_cart_id;
2310:
2311: delete icx_cart_distributions
2312: where cart_id = v_cart_id;