APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_BUS_CLASS_REQS

Line 645: (p_request_rec IN pos_bus_class_reqs%ROWTYPE,

641:
642: END approve_update_contact_req;
643:
644: PROCEDURE approve_new_bus_class_req
645: (p_request_rec IN pos_bus_class_reqs%ROWTYPE,
646: p_vendor_id IN NUMBER,
647: p_vendor_party_id IN NUMBER,
648: x_return_status OUT nocopy VARCHAR2,
649: x_msg_count OUT nocopy NUMBER,

Line 661: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

657: savepoint approve_new_bus_class_req;
658: -- Lock the rows: This is done as part of ECO 5209555
659: BEGIN
660:
661: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
662: WHERE bus_class_request_id = p_request_rec.bus_class_request_id for update nowait;
663:
664: EXCEPTION
665:

Line 717: UPDATE pos_bus_class_reqs

713: , fnd_global.login_id
714: , p_vendor_id
715: );
716:
717: UPDATE pos_bus_class_reqs
718: SET request_status = 'APPROVED',
719: last_update_date = Sysdate,
720: last_updated_by = fnd_global.user_id,
721: last_update_login = fnd_global.login_id

Line 738: (p_request_rec IN pos_bus_class_reqs%ROWTYPE,

734:
735: END approve_new_bus_class_req;
736:
737: PROCEDURE approve_update_bus_class_req
738: (p_request_rec IN pos_bus_class_reqs%ROWTYPE,
739: p_vendor_id IN NUMBER,
740: p_vendor_party_id IN NUMBER, x_return_status OUT nocopy VARCHAR2,
741: x_msg_count OUT nocopy NUMBER,
742: x_msg_data OUT nocopy VARCHAR2

Line 754: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

750:
751: -- Lock the rows: This is done as part of ECO 5209555
752: BEGIN
753:
754: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
755: WHERE bus_class_request_id = p_request_rec.bus_class_request_id for update nowait;
756:
757: select classification_id into l_lock_id from pos_bus_class_attr
758: WHERE classification_id = p_request_rec.classification_id for update nowait;

Line 781: UPDATE pos_bus_class_reqs

777: , last_update_date = Sysdate
778: , last_update_login = fnd_global.login_id
779: WHERE classification_id = p_request_rec.classification_id;
780:
781: UPDATE pos_bus_class_reqs
782: SET request_status = 'APPROVED',
783: last_update_date = Sysdate,
784: last_updated_by = fnd_global.user_id,
785: last_update_login = fnd_global.login_id

Line 1075: FROM pos_bus_class_reqs

1071: )
1072: IS
1073: CURSOR l_cur IS
1074: SELECT *
1075: FROM pos_bus_class_reqs
1076: WHERE bus_class_request_id = p_request_id FOR UPDATE NOWAIT;
1077: -- ECO 5209555 Add the nowait clause
1078:
1079: l_rec l_cur%ROWTYPE;

Line 1464: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

1460: savepoint reject_bus_class_req;
1461: -- Lock the rows: This is done as part of ECO 5209555
1462: BEGIN
1463:
1464: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
1465: WHERE bus_class_request_id = p_request_id for update nowait;
1466:
1467: EXCEPTION
1468:

Line 1478: UPDATE pos_bus_class_reqs

1474: END IF;
1475: raise_application_error(-20082, x_msg_data, true);
1476: END;
1477:
1478: UPDATE pos_bus_class_reqs
1479: SET request_status = 'REJECTED',
1480: last_update_date = Sysdate,
1481: last_updated_by = fnd_global.user_id,
1482: last_update_login = fnd_global.login_id

Line 1678: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

1674: BEGIN
1675:
1676: for i in 1..p_req_id_tbl.COUNT LOOP
1677:
1678: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
1679: where bus_class_request_id = p_req_id_tbl(i) for update nowait;
1680:
1681: END LOOP;
1682:

Line 2020: select bus_class_request_id into l_lock_id from pos_bus_class_reqs

2016: BEGIN
2017:
2018: for i in 1..p_req_id_tbl.COUNT LOOP
2019:
2020: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
2021: where bus_class_request_id = p_req_id_tbl(i) for update nowait;
2022:
2023: END LOOP;
2024:

Line 2142: select BUS_CLASS_REQUEST_ID into l_lock_id from pos_bus_class_reqs

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:
2145: END LOOP;
2146:

Line 2162: UPDATE pos_bus_class_reqs

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