APPS.CSM_HZ_LOCATION_PKG dependencies on CSM_REQ_HEADERS_INQ

Line 114: SELECT TASK_ASSIGNMENT_ID FROM CSM_REQ_HEADERS_INQ

110: AND fnd.USER_ID = asg.USER_ID;
111:
112: CURSOR c_req_hdr(b_uid VARCHAR2,tid number,lid number)
113: IS
114: SELECT TASK_ASSIGNMENT_ID FROM CSM_REQ_HEADERS_INQ
115: WHERE tranid$$ = tid AND clid$$cs = b_uid
116: AND SHIP_TO_LOCATION_ID = lid AND ADDRESS_TYPE='S';
117:
118: l_ta_id NUMBER:=NULL;

Line 247: UPDATE CSM_REQ_HEADERS_INQ --support for special address

243: END IF;
244:
245: CSM_UTIL_PKG.log( 'New HR Location_id: ' ||x_loc_id ,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
246:
247: UPDATE CSM_REQ_HEADERS_INQ --support for special address
248: SET SHIP_TO_LOCATION_ID = x_loc_id,
249: SHIP_TO_LOC_SRC='HR'
250: WHERE tranid$$ = p_record.tranid$$
251: AND clid$$cs = p_record.CLID$$CS

Line 354: FROM CSM_REQ_HEADERS_INQ

350: END LOOP;
351:
352: --Requirement lines/headers with special address
353: FOR rec in (SELECT REQUIREMENT_HEADER_ID ,SEQNO$$,DMLTYPE$$
354: FROM CSM_REQ_HEADERS_INQ
355: WHERE tranid$$ = p_tranid
356: AND clid$$cs = p_user_name
357: AND SHIP_TO_LOCATION_ID = p_loc_id
358: AND ADDRESS_TYPE='S')