DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on RCV_PARAMETERS

Line 5185: FROM rcv_parameters

5181:
5182: BEGIN
5183: SELECT (next_receipt_num + 1)
5184: INTO x_receipt_num
5185: FROM rcv_parameters
5186: WHERE organization_id = l_ship_to_org_id
5187: FOR UPDATE OF next_receipt_num;
5188:
5189: LOOP

Line 5197: UPDATE rcv_parameters

5193: WHERE receipt_num = x_receipt_num
5194: AND ship_to_org_id = l_ship_to_org_id;
5195:
5196: IF l_count = 0 THEN
5197: UPDATE rcv_parameters
5198: SET next_receipt_num = x_receipt_num
5199: WHERE organization_id = l_ship_to_org_id;
5200:
5201: EXIT;