APPS.ICX_REQ_SUBMIT dependencies on ICX_REQ_CART_ERRORS

Line 18: select icx_req_cart_errors_s.nextval into l_error_id from dual;

14: begin
15:
16: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
17:
18: select icx_req_cart_errors_s.nextval into l_error_id from dual;
19:
20: /* append new message to the error table for redisplay */
21: insert into icx_req_cart_errors
22: (error_id,cart_id,distribution_num,cart_line_id,last_updated_by,last_update_date,last_update_login,creation_date,created_by,error_text)

Line 21: insert into icx_req_cart_errors

17:
18: select icx_req_cart_errors_s.nextval into l_error_id from dual;
19:
20: /* append new message to the error table for redisplay */
21: insert into icx_req_cart_errors
22: (error_id,cart_id,distribution_num,cart_line_id,last_updated_by,last_update_date,last_update_login,creation_date,created_by,error_text)
23: values(l_error_id,v_cart_id,v_distribution_num,v_cart_line_id,null,sysdate,l_shopper_id,sysdate,l_shopper_id,v_message);
24:
25:

Line 140: delete icx_req_cart_errors

136: -- clean up errors
137: v_cart_id := cart_id;
138: v_index := 1;
139:
140: delete icx_req_cart_errors
141: where cart_id = v_cart_id;
142:
143: -- get shopper id
144: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

Line 1040: delete icx_req_cart_errors

1036: v_cart_id := icx_call.decrypt2(icx_cart_id);
1037:
1038:
1039: -- clear out all possible cart errors
1040: delete icx_req_cart_errors
1041: where cart_id = v_cart_id;
1042:
1043: n_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1044: v_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);