6: -- Name : txn_source_rec
7: -- Description : To hold the source information of the txn details
8:
9: TYPE txn_source_rec IS RECORD(
10: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
11: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
12: INVENTORY_ITEM_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
14: SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
7: -- Description : To hold the source information of the txn details
8:
9: TYPE txn_source_rec IS RECORD(
10: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
11: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
12: INVENTORY_ITEM_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
14: SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15: SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
8:
9: TYPE txn_source_rec IS RECORD(
10: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
11: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
12: INVENTORY_ITEM_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
14: SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15: SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
16: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
9: TYPE txn_source_rec IS RECORD(
10: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
11: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
12: INVENTORY_ITEM_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
14: SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15: SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
16: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
10: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
11: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
12: INVENTORY_ITEM_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
14: SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15: SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
16: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
18: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
11: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
12: INVENTORY_ITEM_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
14: SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15: SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
16: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
18: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
19: PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
12: INVENTORY_ITEM_NAME VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
14: SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15: SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
16: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
18: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
19: PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
13: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
14: SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15: SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
16: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
18: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
19: PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
14: SOURCE_QUANTITY NUMBER := FND_API.G_MISS_NUM,
15: SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
16: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
18: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
19: PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
22: PRIMARY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
15: SOURCE_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
16: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
18: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
19: PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
22: PRIMARY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
23: SERIAL_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
18: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
19: PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
22: PRIMARY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
23: SERIAL_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
24: LOT_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
17: FULFILLED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
18: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
19: PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
22: PRIMARY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
23: SERIAL_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
24: LOT_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
18: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
19: PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
22: PRIMARY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
23: SERIAL_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
24: LOT_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
26:
19: PARTY_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
20: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
22: PRIMARY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
23: SERIAL_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
24: LOT_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
26:
27:
20: BILL_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
21: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
22: PRIMARY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
23: SERIAL_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
24: LOT_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
26:
27:
28: -- Name : txn_source_param_rec
21: SHIP_TO_ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
22: PRIMARY_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
23: SERIAL_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
24: LOT_CONTROL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR);
26:
27:
28: -- Name : txn_source_param_rec
29: -- Description : To hold the source information of the txn details
28: -- Name : txn_source_param_rec
29: -- Description : To hold the source information of the txn details
30:
31: TYPE txn_source_param_rec IS RECORD(
32: STANDALONE_MODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
33: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
36: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
29: -- Description : To hold the source information of the txn details
30:
31: TYPE txn_source_param_rec IS RECORD(
32: STANDALONE_MODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
33: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
36: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
37: INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
30:
31: TYPE txn_source_param_rec IS RECORD(
32: STANDALONE_MODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
33: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
36: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
37: INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
38: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
31: TYPE txn_source_param_rec IS RECORD(
32: STANDALONE_MODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
33: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
36: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
37: INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
38: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
32: STANDALONE_MODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
33: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
36: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
37: INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
38: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
33: SOURCE_TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
36: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
37: INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
38: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_TRANSACTION_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
35: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
36: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
37: INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
38: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
42: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
36: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
37: INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
38: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
42: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
43: SHIP_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
36: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
37: INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
38: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
42: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
43: SHIP_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
44: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
37: INV_ORGN_ID NUMBER := FND_API.G_MISS_NUM,
38: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
42: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
43: SHIP_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
44: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
45: INVOICE_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
38: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
39: TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
42: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
43: SHIP_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
44: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
45: INVOICE_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
46: INVOICE_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM);
39: TRANSACTED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
40: TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
42: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
43: SHIP_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
44: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
45: INVOICE_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
46: INVOICE_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM);
47:
40: TRANSACTED_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
42: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
43: SHIP_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
44: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
45: INVOICE_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
46: INVOICE_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM);
47:
48: FUNCTION g_miss_num RETURN number;
41: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
42: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
43: SHIP_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
44: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
45: INVOICE_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
46: INVOICE_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM);
47:
48: FUNCTION g_miss_num RETURN number;
49: FUNCTION g_miss_char RETURN varchar2;
42: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
43: SHIP_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
44: SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
45: INVOICE_TO_ORG_ID NUMBER := FND_API.G_MISS_NUM,
46: INVOICE_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM);
47:
48: FUNCTION g_miss_num RETURN number;
49: FUNCTION g_miss_char RETURN varchar2;
50: FUNCTION g_miss_date RETURN date;