DBA Data[Home] [Help]

APPS.FLM_RECEIPT_PUB dependencies on RCV_PARAMETERS

Line 1060: FROM rcv_parameters

1056:
1057: -- Generate receipt number
1058: SELECT TO_CHAR(next_receipt_num + 1)
1059: INTO l_temp_receipt_num
1060: FROM rcv_parameters
1061: WHERE organization_id = l_ship_header_rec.ship_to_org_id
1062: FOR UPDATE OF next_receipt_num;
1063:
1064: LOOP

Line 1072: UPDATE rcv_parameters

1068: WHERE receipt_num = l_temp_receipt_num
1069: AND ship_to_org_id = l_ship_header_rec.ship_to_org_id;
1070:
1071: IF l_receipt_exists = 0 THEN
1072: UPDATE rcv_parameters
1073: SET next_receipt_num = l_temp_receipt_num
1074: WHERE organization_id = l_ship_header_rec.ship_to_org_id;
1075:
1076: EXIT;