DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on RCV_PARAMETERS

Line 4858: FROM rcv_parameters

4854:
4855: BEGIN
4856: SELECT (next_receipt_num + 1)
4857: INTO x_receipt_num
4858: FROM rcv_parameters
4859: WHERE organization_id = l_ship_to_org_id
4860: FOR UPDATE OF next_receipt_num;
4861:
4862: LOOP

Line 4870: UPDATE rcv_parameters

4866: WHERE receipt_num = x_receipt_num
4867: AND ship_to_org_id = l_ship_to_org_id;
4868:
4869: IF l_count = 0 THEN
4870: UPDATE rcv_parameters
4871: SET next_receipt_num = x_receipt_num
4872: WHERE organization_id = l_ship_to_org_id;
4873:
4874: EXIT;