APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_BUS_CLASS_REQS

Line 655: (p_request_rec IN pos_bus_class_reqs%ROWTYPE,

651:
652: END approve_update_contact_req;
653:
654: PROCEDURE approve_new_bus_class_req
655: (p_request_rec IN pos_bus_class_reqs%ROWTYPE,
656: p_vendor_id IN NUMBER,
657: p_vendor_party_id IN NUMBER,
658: x_return_status OUT nocopy VARCHAR2,
659: x_msg_count OUT nocopy NUMBER,

Line 671: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

667: savepoint approve_new_bus_class_req;
668: -- Lock the rows: This is done as part of ECO 5209555
669: BEGIN
670:
671: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
672: WHERE bus_class_request_id = p_request_rec.bus_class_request_id for update nowait;
673:
674: EXCEPTION
675:

Line 727: UPDATE pos_bus_class_reqs

723: , fnd_global.login_id
724: , p_vendor_id
725: );
726:
727: UPDATE pos_bus_class_reqs
728: SET request_status = 'APPROVED',
729: last_update_date = Sysdate,
730: last_updated_by = fnd_global.user_id,
731: last_update_login = fnd_global.login_id

Line 748: (p_request_rec IN pos_bus_class_reqs%ROWTYPE,

744:
745: END approve_new_bus_class_req;
746:
747: PROCEDURE approve_update_bus_class_req
748: (p_request_rec IN pos_bus_class_reqs%ROWTYPE,
749: p_vendor_id IN NUMBER,
750: p_vendor_party_id IN NUMBER, x_return_status OUT nocopy VARCHAR2,
751: x_msg_count OUT nocopy NUMBER,
752: x_msg_data OUT nocopy VARCHAR2

Line 764: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

760:
761: -- Lock the rows: This is done as part of ECO 5209555
762: BEGIN
763:
764: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
765: WHERE bus_class_request_id = p_request_rec.bus_class_request_id for update nowait;
766:
767: select classification_id into l_lock_id from pos_bus_class_attr
768: WHERE classification_id = p_request_rec.classification_id for update nowait;

Line 791: UPDATE pos_bus_class_reqs

787: , last_update_date = Sysdate
788: , last_update_login = fnd_global.login_id
789: WHERE classification_id = p_request_rec.classification_id;
790:
791: UPDATE pos_bus_class_reqs
792: SET request_status = 'APPROVED',
793: last_update_date = Sysdate,
794: last_updated_by = fnd_global.user_id,
795: last_update_login = fnd_global.login_id

Line 1129: FROM pos_bus_class_reqs

1125: )
1126: IS
1127: CURSOR l_cur IS
1128: SELECT *
1129: FROM pos_bus_class_reqs
1130: WHERE bus_class_request_id = p_request_id FOR UPDATE NOWAIT;
1131: -- ECO 5209555 Add the nowait clause
1132:
1133: l_rec l_cur%ROWTYPE;

Line 1518: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

1514: savepoint reject_bus_class_req;
1515: -- Lock the rows: This is done as part of ECO 5209555
1516: BEGIN
1517:
1518: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
1519: WHERE bus_class_request_id = p_request_id for update nowait;
1520:
1521: EXCEPTION
1522:

Line 1532: UPDATE pos_bus_class_reqs

1528: END IF;
1529: raise_application_error(-20082, x_msg_data, true);
1530: END;
1531:
1532: UPDATE pos_bus_class_reqs
1533: SET request_status = 'REJECTED',
1534: last_update_date = Sysdate,
1535: last_updated_by = fnd_global.user_id,
1536: last_update_login = fnd_global.login_id

Line 1732: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

1728: BEGIN
1729:
1730: for i in 1..p_req_id_tbl.COUNT LOOP
1731:
1732: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
1733: where bus_class_request_id = p_req_id_tbl(i) for update nowait;
1734:
1735: END LOOP;
1736:

Line 2074: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

2070: BEGIN
2071:
2072: for i in 1..p_req_id_tbl.COUNT LOOP
2073:
2074: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
2075: where bus_class_request_id = p_req_id_tbl(i) for update nowait;
2076:
2077: END LOOP;
2078:

Line 2196: select BUS_CLASS_REQUEST_ID into l_lock_id from pos_bus_class_reqs

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:
2199: END LOOP;
2200:

Line 2216: UPDATE pos_bus_class_reqs

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,
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;