APPS.INV_RCV_COMMON_APIS dependencies on RCV_PARAMETERS

Line 1345: UPDATE rcv_parameters

1341: print_debug('Enter gen_receipt_num 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1342: END IF;
1343:
1344: /* Commented for bug 6014386
1345: UPDATE rcv_parameters
1346: SET next_receipt_num = next_receipt_num + 1
1347: WHERE organization_id = p_organization_id;
1348:
1349: COMMIT;

Line 1354: FROM rcv_parameters

1350: l_progress := '20';
1351:
1352: SELECT TO_CHAR(next_receipt_num)
1353: INTO x_receipt_num
1354: FROM rcv_parameters
1355: WHERE organization_id = p_organization_id;
1356:
1357: l_progress := '30';
1358:

Line 1387: FROM rcv_parameters

1383: and find a unique number instead of erroring the transaction. */
1384:
1385: SELECT to_char(next_receipt_num + 1)
1386: INTO l_temp_rcpt_num
1387: FROM rcv_parameters
1388: WHERE organization_id = p_organization_id
1389: FOR UPDATE OF next_receipt_num;
1390:
1391: l_progress := '20';

Line 1401: UPDATE rcv_parameters

1397: WHERE rsh.receipt_num = l_temp_rcpt_num
1398: AND rsh.ship_to_org_id = p_organization_id ;
1399:
1400: IF l_receipt_exists = 0 THEN
1401: UPDATE rcv_parameters
1402: SET next_receipt_num = l_temp_rcpt_num
1403: WHERE organization_id = p_organization_id ;
1404:
1405: COMMIT; --commit the autonomous transaction

Line 1672: FROM rcv_parameters

1668: SELECT user_defined_receipt_num_code
1669: , manual_receipt_num_type
1670: INTO x_receipt_num_code
1671: , x_receipt_num_type
1672: FROM rcv_parameters
1673: WHERE organization_id = p_org_id;
1674:
1675: l_progress := '60';
1676: fnd_profile.get('DISPLAY_INVERSE_RATE', x_display_inverse_rate);

Line 2591: FROM rcv_parameters

2587: */
2588: BEGIN
2589: SELECT NVL(x_default_routing_id, NVL(receiving_routing_id, 1))
2590: INTO x_default_routing_id
2591: FROM rcv_parameters
2592: WHERE organization_id = p_organization_id;
2593: EXCEPTION
2594: WHEN NO_DATA_FOUND THEN
2595: NULL;

Line 2803: -- Get the routing details from rcv parameters related po enhancement 3124881

2799: x_routing_id := 2;
2800: ELSE
2801: x_routing_id := NULL;
2802: -- Bug 3569361
2803: -- Get the routing details from rcv parameters related po enhancement 3124881
2804: Begin
2805: IF (l_debug = 1) THEN
2806: print_debug('get_routing_id 52.1 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
2807: END IF;

Line 2811: from rcv_parameters

2807: END IF;
2808:
2809: select rma_receipt_routing_id
2810: into x_routing_id
2811: from rcv_parameters
2812: where organization_id = p_organization_id;
2813: Exception
2814: When OTHERS then
2815: IF (l_debug = 1) THEN

Line 2816: print_debug('get_routing_id - can not fetch routing id from rcv parameters ', 4);

2812: where organization_id = p_organization_id;
2813: Exception
2814: When OTHERS then
2815: IF (l_debug = 1) THEN
2816: print_debug('get_routing_id - can not fetch routing id from rcv parameters ', 4);
2817: print_debug('get_routing_id 52.2 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
2818: END IF;
2819: End;
2820: END IF;