APPS.RCV_SHIPMENT_HEADERS_PKG dependencies on RCV_PARAMETERS

Line 74: from rcv_parameters

70:
71:
72: select user_defined_receipt_num_code
73: into x_receipt_code
74: from rcv_parameters
75: where organization_id = x_ship_to_org_id;
76:
77:
78: /* hvadlamu : to make the receipt numbers unique across orgs

Line 94: from rcv_parameters

90: */
91:
92: select to_char(next_receipt_num + 1)
93: into X_temp_receipt_num
94: from rcv_parameters
95: where organization_id = x_ship_to_org_id
96: FOR UPDATE OF next_receipt_num;
97:
98: LOOP

Line 107: update rcv_parameters

103: AND ship_to_org_id = x_ship_to_org_id;
104:
105: IF X_receipt_exists = 0 THEN
106:
107: update rcv_parameters
108: set next_receipt_num = X_temp_receipt_num
109: where organization_id = x_ship_to_org_id;
110:
111: EXIT;