APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_BUS_REC

Line 2126: p_pos_bus_rec_tbl IN pos_bus_rec_tbl,

2122:
2123:
2124: PROCEDURE approve_update_mult_bc_reqs
2125: (
2126: p_pos_bus_rec_tbl IN pos_bus_rec_tbl,
2127: x_return_status OUT NOCOPY VARCHAR2,
2128: x_msg_count OUT NOCOPY NUMBER,
2129: x_msg_data OUT NOCOPY VARCHAR2
2130: )

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

2136:
2137: -- Lock the rows: This is done as part of ECO 5209555
2138: BEGIN
2139:
2140: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2141:
2142: select BUS_CLASS_REQUEST_ID into l_lock_id from pos_bus_class_reqs
2143: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID for update nowait;
2144:

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

2139:
2140: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2141:
2142: select BUS_CLASS_REQUEST_ID into l_lock_id from pos_bus_class_reqs
2143: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID for update nowait;
2144:
2145: END LOOP;
2146:
2147: EXCEPTION

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

2156: END;
2157:
2158: l_req_id_tbl := PO_TBL_NUMBER();
2159:
2160: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2161:
2162: UPDATE pos_bus_class_reqs
2163: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2164: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,

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

2159:
2160: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2161:
2162: UPDATE pos_bus_class_reqs
2163: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2164: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,
2165: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2166: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2167:

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

2160: for i in 1..p_pos_bus_rec_tbl.COUNT LOOP
2161:
2162: UPDATE pos_bus_class_reqs
2163: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2164: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,
2165: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2166: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2167:
2168: l_req_id_tbl.extend;

Line 2165: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE

2161:
2162: UPDATE pos_bus_class_reqs
2163: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2164: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,
2165: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2166: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2167:
2168: l_req_id_tbl.extend;
2169: l_req_id_tbl(i) := p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;

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

2162: UPDATE pos_bus_class_reqs
2163: SET CERTIFICATION_NO = p_pos_bus_rec_tbl(i).CERTIFICATION_NO,
2164: CERTIFICATION_AGENCY = p_pos_bus_rec_tbl(i).CERTIFICATION_AGENCY,
2165: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2166: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2167:
2168: l_req_id_tbl.extend;
2169: l_req_id_tbl(i) := p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2170:

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

2165: EXPIRATION_DATE = p_pos_bus_rec_tbl(i).EXPIRATION_DATE
2166: WHERE BUS_CLASS_REQUEST_ID = p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2167:
2168: l_req_id_tbl.extend;
2169: l_req_id_tbl(i) := p_pos_bus_rec_tbl(i).BUS_CLASS_REQUEST_ID;
2170:
2171: END LOOP;
2172:
2173: approve_mult_bus_class_reqs