APPS.WSH_INVOICE_UTILITIES dependencies on WSH_INVOICE_NUMBERS

Line 28: From wsh_invoice_numbers

24: inv_num_base := x_del_name;
25:
26: Select nvl((max(index_number)+1), 0)
27: Into inv_num_index
28: From wsh_invoice_numbers
29: Where delivery_id = x_del_id;
30:
31: If ( SQL%NOTFOUND ) Then
32: inv_num_index := 1;

Line 43: Insert Into Wsh_Invoice_Numbers

39: End If;
40:
41: --dbms_output.put_line('global user ' || fnd_global.user_id);
42: --dbms_output.put_line('inv num index ' || to_char(inv_num_index));
43: Insert Into Wsh_Invoice_Numbers
44: (INVOICE_NUMBER_ID, DELIVERY_ID, INDEX_NUMBER, LAST_UPDATE_DATE,
45: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
46: VALUES
47: (wsh_invoice_numbers_s.nextval, x_del_id, inv_num_index, SYSDATE,

Line 47: (wsh_invoice_numbers_s.nextval, x_del_id, inv_num_index, SYSDATE,

43: Insert Into Wsh_Invoice_Numbers
44: (INVOICE_NUMBER_ID, DELIVERY_ID, INDEX_NUMBER, LAST_UPDATE_DATE,
45: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
46: VALUES
47: (wsh_invoice_numbers_s.nextval, x_del_id, inv_num_index, SYSDATE,
48: fnd_global.user_id, SYSDATE, fnd_global.user_id);
49:
50: return 0;
51: