APPS.POR_RCV_ORD_SV dependencies on RCV_PARAMETERS

Line 1449: FROM rcv_parameters

1445:
1446:
1447: SELECT to_char(next_receipt_num + 1)
1448: INTO X_receipt_num
1449: FROM rcv_parameters
1450: WHERE organization_id = X_to_org_id
1451: FOR UPDATE OF next_receipt_num;
1452:
1453: LOOP

Line 1462: update rcv_parameters

1458: WHERE receipt_num = X_receipt_num and
1459: ship_to_org_id = X_to_org_id;
1460:
1461: IF (X_count = 0) THEN
1462: update rcv_parameters
1463: set next_receipt_num = X_receipt_num
1464: where organization_id = X_to_org_id;
1465:
1466: EXIT;

Line 1591: FROM rcv_parameters

1587: when no_data_found then
1588: /* Get the Receipt Number */
1589: SELECT to_char(next_receipt_num + 1)
1590: INTO X_receipt_num
1591: FROM rcv_parameters
1592: WHERE organization_id = X_to_org_id
1593: FOR UPDATE OF next_receipt_num;
1594:
1595: LOOP

Line 1604: update rcv_parameters

1600: WHERE receipt_num = X_receipt_num and
1601: ship_to_org_id = X_to_org_id;
1602:
1603: IF (X_count = 0) THEN
1604: update rcv_parameters
1605: set next_receipt_num = X_receipt_num
1606: where organization_id = X_to_org_id;
1607:
1608: EXIT;