APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_BUS_REC

Line 2180: p_pos_bus_rec_tbl IN pos_bus_rec_tbl,

2176:
2177:
2178: PROCEDURE approve_update_mult_bc_reqs
2179: (
2180: p_pos_bus_rec_tbl IN pos_bus_rec_tbl,
2181: x_return_status OUT NOCOPY VARCHAR2,
2182: x_msg_count OUT NOCOPY NUMBER,
2183: x_msg_data OUT NOCOPY VARCHAR2
2184: )

Line 2194: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP

2190:
2191: -- Lock the rows: This is done as part of ECO 5209555
2192: BEGIN
2193:
2194: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2195:
2196: select BUS_CLASS_REQUEST_ID into l_lock_id from pos_bus_class_reqs
2197: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID for update nowait;
2198:

Line 2197: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID for update nowait;

2193:
2194: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2195:
2196: select BUS_CLASS_REQUEST_ID into l_lock_id from pos_bus_class_reqs
2197: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID for update nowait;
2198:
2199: END LOOP;
2200:
2201: EXCEPTION

Line 2214: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP

2210: END;
2211:
2212: l_req_id_tbl := PO_TBL_NUMBER();
2213:
2214: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2215:
2216: UPDATE pos_bus_class_reqs
2217: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2218: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,

Line 2217: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,

2213:
2214: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2215:
2216: UPDATE pos_bus_class_reqs
2217: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2218: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,
2219: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2220: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2221:

Line 2218: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,

2214: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2215:
2216: UPDATE pos_bus_class_reqs
2217: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2218: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,
2219: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2220: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2221:
2222: l_req_id_tbl.extend;

Line 2219: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE

2215:
2216: UPDATE pos_bus_class_reqs
2217: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2218: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,
2219: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2220: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2221:
2222: l_req_id_tbl.extend;
2223: l_req_id_tbl(i) := p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;

Line 2220: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;

2216: UPDATE pos_bus_class_reqs
2217: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2218: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,
2219: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2220: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2221:
2222: l_req_id_tbl.extend;
2223: l_req_id_tbl(i) := p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2224:

Line 2223: l_req_id_tbl(i) := p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;

2219: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2220: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2221:
2222: l_req_id_tbl.extend;
2223: l_req_id_tbl(i) := p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2224:
2225: END LOOP;
2226:
2227: approve_mult_bus_class_reqs