18: -- Procedure name : Validate_And_Write
19: -- Purpose : A wrapper to prepare data to call the update, delete and insert procedures of the
20: -- CSP_Material_Transaactions_PVT.
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: p_action_code IN NUMBER,
26: p_TRANSACTION_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
19: -- Purpose : A wrapper to prepare data to call the update, delete and insert procedures of the
20: -- CSP_Material_Transaactions_PVT.
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: p_action_code IN NUMBER,
26: p_TRANSACTION_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
27: px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
20: -- CSP_Material_Transaactions_PVT.
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: p_action_code IN NUMBER,
26: p_TRANSACTION_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
27: px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
28: p_SOURCE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: p_action_code IN NUMBER,
26: p_TRANSACTION_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
27: px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
28: p_SOURCE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
30: p_TRANSACTION_MODE IN NUMBER := FND_API.G_MISS_NUM,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: p_action_code IN NUMBER,
26: p_TRANSACTION_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
27: px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
28: p_SOURCE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
30: p_TRANSACTION_MODE IN NUMBER := FND_API.G_MISS_NUM,
31: p_LOCK_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
25: p_action_code IN NUMBER,
26: p_TRANSACTION_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
27: px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
28: p_SOURCE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
30: p_TRANSACTION_MODE IN NUMBER := FND_API.G_MISS_NUM,
31: p_LOCK_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
26: p_TRANSACTION_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
27: px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
28: p_SOURCE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
30: p_TRANSACTION_MODE IN NUMBER := FND_API.G_MISS_NUM,
31: p_LOCK_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
27: px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
28: p_SOURCE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
30: p_TRANSACTION_MODE IN NUMBER := FND_API.G_MISS_NUM,
31: p_LOCK_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
35: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
28: p_SOURCE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
30: p_TRANSACTION_MODE IN NUMBER := FND_API.G_MISS_NUM,
31: p_LOCK_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
35: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
36: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
29: p_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
30: p_TRANSACTION_MODE IN NUMBER := FND_API.G_MISS_NUM,
31: p_LOCK_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
35: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
36: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
37: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
30: p_TRANSACTION_MODE IN NUMBER := FND_API.G_MISS_NUM,
31: p_LOCK_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
35: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
36: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
37: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
38: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
31: p_LOCK_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
35: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
36: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
37: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
38: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
39: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
35: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
36: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
37: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
38: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
39: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
40: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
34: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
35: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
36: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
37: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
38: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
39: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
40: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
41: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
34: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
35: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
36: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
37: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
38: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
39: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
40: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
41: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
42: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
36: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
37: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
38: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
39: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
40: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
41: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
42: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
36: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
37: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
38: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
39: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
40: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
41: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
42: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
44: p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
38: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
39: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
40: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
41: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
42: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
44: p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
38: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
39: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
40: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
41: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
42: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
44: p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
46: p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
39: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
40: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
41: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
42: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
44: p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
46: p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
47: p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
40: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
41: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
42: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
44: p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
46: p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
47: p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
48: p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
42: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
44: p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
46: p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
47: p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
48: p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
42: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
44: p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
46: p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
47: p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
48: p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
50: p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
43: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
44: p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
46: p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
47: p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
48: p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
50: p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
51: p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
44: p_SUBINVENTORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
46: p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
47: p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
48: p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
50: p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
51: p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
52: p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
45: p_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
46: p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
47: p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
48: p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
50: p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
51: p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
52: p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
46: p_TRANSACTION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
47: p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
48: p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
50: p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
51: p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
52: p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_PRIMARY_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
48: p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
50: p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
51: p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
52: p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
48: p_TRANSACTION_UOM IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
50: p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
51: p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
52: p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
56: p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
49: p_TRANSACTION_COST IN NUMBER := FND_API.G_MISS_NUM,
50: p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
51: p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
52: p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
56: p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
57: p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
50: p_TRANSACTION_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
51: p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
52: p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
56: p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
57: p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_TRANSACTION_ACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
52: p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
56: p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
57: p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
52: p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
56: p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
57: p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_TRANSACTION_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
56: p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
57: p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
61: p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_TRANSACTION_SOURCE_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
56: p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
57: p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
61: p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
62: p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_TRANSACTION_DATE IN DATE := FND_API.G_MISS_DATE,
56: p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
57: p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
61: p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
62: p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
56: p_ACCT_PERIOD_ID IN NUMBER := FND_API.G_MISS_NUM,
57: p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
61: p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
62: p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
64: p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_DISTRIBUTION_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
61: p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
62: p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
64: p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_TRANSACTION_REFERENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
61: p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
62: p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
64: p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
59: p_REQUISITION_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
61: p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
62: p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
64: p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
67: p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
60: p_REQUISITION_DISTRIBUTION_ID IN NUMBER := FND_API.G_MISS_NUM,
61: p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
62: p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
64: p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
67: p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
68: p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
61: p_REASON_ID IN NUMBER := FND_API.G_MISS_NUM,
62: p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
64: p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
67: p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
68: p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
69: p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
62: p_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
64: p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
67: p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
68: p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
69: p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
70: p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
63: p_LOT_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
64: p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
67: p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
68: p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
69: p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
70: p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
71: p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
64: p_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
67: p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
68: p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
69: p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
70: p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
71: p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
72: p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
65: p_RECEIVING_DOCUMENT IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
67: p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
68: p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
69: p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
70: p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
71: p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
72: p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_DEMAND_ID IN NUMBER := FND_API.G_MISS_NUM,
67: p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
68: p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
69: p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
70: p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
71: p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
72: p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
67: p_RCV_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
68: p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
69: p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
70: p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
71: p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
72: p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
75: p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
68: p_MOVE_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
69: p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
70: p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
71: p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
72: p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
75: p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
76: p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
69: p_COMPLETION_TRANSACTION_ID IN NUMBER := FND_API.G_MISS_NUM,
70: p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
71: p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
72: p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
75: p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
76: p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
77: p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
70: p_WIP_ENTITY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
71: p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
72: p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
75: p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
76: p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
77: p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
78: p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
71: p_SCHEDULE_ID IN NUMBER := FND_API.G_MISS_NUM,
72: p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
75: p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
76: p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
77: p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
78: p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
79: p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
72: p_REPETITIVE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
75: p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
76: p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
77: p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
78: p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
79: p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
80: p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
73: p_EMPLOYEE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
75: p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
76: p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
77: p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
78: p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
79: p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
80: p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
81: p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
74: p_PRIMARY_SWITCH IN NUMBER := FND_API.G_MISS_NUM,
75: p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
76: p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
77: p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
78: p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
79: p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
80: p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
81: p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
82: p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
75: p_SCHEDULE_UPDATE_CODE IN NUMBER := FND_API.G_MISS_NUM,
76: p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
77: p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
78: p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
79: p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
80: p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
81: p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
82: p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
83: p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
76: p_SETUP_TEARDOWN_CODE IN NUMBER := FND_API.G_MISS_NUM,
77: p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
78: p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
79: p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
80: p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
81: p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
82: p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
83: p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
84: p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
77: p_ITEM_ORDERING IN NUMBER := FND_API.G_MISS_NUM,
78: p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
79: p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
80: p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
81: p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
82: p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
83: p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
84: p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
85: p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
78: p_NEGATIVE_REQ_FLAG IN NUMBER := FND_API.G_MISS_NUM,
79: p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
80: p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
81: p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
82: p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
83: p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
84: p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
85: p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
86: p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
79: p_OPERATION_SEQ_NUM IN NUMBER := FND_API.G_MISS_NUM,
80: p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
81: p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
82: p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
83: p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
84: p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
85: p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
86: p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
87: p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_PICKING_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
81: p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
82: p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
83: p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
84: p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
85: p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
86: p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
87: p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
81: p_TRX_SOURCE_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
82: p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
83: p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
84: p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
85: p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
86: p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
87: p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
89: p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_TRX_SOURCE_DELIVERY_ID IN NUMBER := FND_API.G_MISS_NUM,
83: p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
84: p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
85: p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
86: p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
87: p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
89: p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
83: p_PHYSICAL_ADJUSTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
84: p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
85: p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
86: p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
87: p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
89: p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
91: p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_CYCLE_COUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
85: p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
86: p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
87: p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
89: p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
91: p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
86: p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
87: p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
89: p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
91: p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
86: p_CUSTOMER_SHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
87: p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
89: p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
91: p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
94: p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
87: p_CURRENCY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
89: p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
91: p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
94: p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
95: p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
88: p_CURRENCY_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
89: p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
91: p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
94: p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
95: p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
96: p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_CURRENCY_CONVERSION_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
91: p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
94: p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
95: p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
96: p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
90: p_CURRENCY_CONVERSION_DATE IN DATE := FND_API.G_MISS_DATE,
91: p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
94: p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
95: p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
96: p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
98: p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
91: p_USSGL_TRANSACTION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
94: p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
95: p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
96: p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
98: p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
99: p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
92: p_VENDOR_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
94: p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
95: p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
96: p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
98: p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
99: p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
100: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_ENCUMBRANCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
94: p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
95: p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
96: p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
98: p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
99: p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
100: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
94: p_ENCUMBRANCE_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
95: p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
96: p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
98: p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
99: p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
100: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
102: p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_SHIP_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
96: p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
98: p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
99: p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
100: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
102: p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
96: p_SHIPMENT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
98: p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
99: p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
100: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
102: p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
104: p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_TRANSFER_COST IN NUMBER := FND_API.G_MISS_NUM,
98: p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
99: p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
100: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
102: p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
104: p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
98: p_TRANSPORTATION_COST IN NUMBER := FND_API.G_MISS_NUM,
99: p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
100: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
102: p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
104: p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
106: p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
99: p_TRANSPORTATION_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
100: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
102: p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
104: p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
106: p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
107: p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
100: p_FREIGHT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
102: p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
104: p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
106: p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
107: p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
108: p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
101: p_CONTAINERS IN NUMBER := FND_API.G_MISS_NUM,
102: p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
104: p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
106: p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
107: p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
108: p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
109: p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
102: p_WAYBILL_AIRBILL IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
104: p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
106: p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
107: p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
108: p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
109: p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
110: p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
103: p_EXPECTED_ARRIVAL_DATE IN DATE := FND_API.G_MISS_DATE,
104: p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
106: p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
107: p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
108: p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
109: p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
110: p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
104: p_TRANSFER_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
106: p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
107: p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
108: p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
109: p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
110: p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_TRANSFER_ORGANIZATION IN NUMBER := FND_API.G_MISS_NUM,
106: p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
107: p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
108: p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
109: p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
110: p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_TRANSFER_TO_LOCATION IN NUMBER := FND_API.G_MISS_NUM,
107: p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
108: p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
109: p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
110: p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_NEW_AVERAGE_COST IN NUMBER := FND_API.G_MISS_NUM,
108: p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
109: p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
110: p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_VALUE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
109: p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
110: p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_PERCENTAGE_CHANGE IN NUMBER := FND_API.G_MISS_NUM,
110: p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
110: p_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
118: p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
111: p_DEMAND_SOURCE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
118: p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
119: p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
112: p_DEMAND_SOURCE_LINE IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
118: p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
119: p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
120: p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
113: p_DEMAND_SOURCE_DELIVERY IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
118: p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
119: p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
120: p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
121: p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_ITEM_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
118: p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
119: p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
120: p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
121: p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_ITEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
118: p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
119: p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
120: p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
121: p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
116: p_ITEM_TRX_ENABLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
118: p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
119: p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
120: p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
121: p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
124: p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
117: p_ITEM_LOCATION_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
118: p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
119: p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
120: p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
121: p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
124: p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
125: p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
118: p_ITEM_RESTRICT_SUBINV_CODE IN NUMBER := FND_API.G_MISS_NUM,
119: p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
120: p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
121: p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
124: p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
125: p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
126: p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
119: p_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER := FND_API.G_MISS_NUM,
120: p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
121: p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
124: p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
125: p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
126: p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
127: p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_ITEM_REV_QTY_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
121: p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
124: p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
125: p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
126: p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
127: p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
121: p_ITEM_PRIMARY_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
124: p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
125: p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
126: p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
127: p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
129: p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
122: p_ITEM_UOM_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
124: p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
125: p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
126: p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
127: p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
129: p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
130: p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_ITEM_SHELF_LIFE_CODE IN NUMBER := FND_API.G_MISS_NUM,
124: p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
125: p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
126: p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
127: p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
129: p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
130: p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
124: p_ITEM_SHELF_LIFE_DAYS IN NUMBER := FND_API.G_MISS_NUM,
125: p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
126: p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
127: p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
129: p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
130: p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
132: p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_ITEM_LOT_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
126: p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
127: p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
129: p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
130: p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
132: p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
126: p_ITEM_SERIAL_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
127: p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
129: p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
130: p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
132: p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
134: p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
129: p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
130: p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
132: p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
134: p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER := FND_API.G_MISS_NUM,
129: p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
130: p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
132: p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
134: p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_DEPARTMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
130: p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
132: p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
134: p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
130: p_DEPARTMENT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
132: p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
134: p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
138: p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
131: p_WIP_SUPPLY_TYPE IN NUMBER := FND_API.G_MISS_NUM,
132: p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
134: p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
138: p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
139: p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_SUPPLY_SUBINVENTORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
134: p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
138: p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
139: p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_SUPPLY_LOCATOR_ID IN NUMBER := FND_API.G_MISS_NUM,
134: p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
138: p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
139: p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_VALID_SUBINVENTORY_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
138: p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
139: p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_VALID_LOCATOR_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
138: p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
139: p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_LOCATOR_SEGMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
138: p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
139: p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER := FND_API.G_MISS_NUM,
138: p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
139: p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_NUMBER_OF_LOTS_ENTERED IN NUMBER := FND_API.G_MISS_NUM,
139: p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_WIP_COMMIT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_NEXT_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_LOT_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_NEXT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_SERIAL_ALPHA_PREFIX IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_SHIPPABLE_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_POSTING_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_REQUIRED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_PROCESS_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_ERROR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_ERROR_EXPLANATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
159: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
167: p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
160: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
167: p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
168: p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
161: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
167: p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
168: p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
169: p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
162: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
167: p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
168: p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
169: p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
170: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
163: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
167: p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
168: p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
169: p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
170: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
171: p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
164: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
167: p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
168: p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
169: p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
170: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
171: p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
172: p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
165: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
166: p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
167: p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
168: p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
169: p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
170: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
171: p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
172: p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
173: p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
166: p_MOVEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
167: p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
168: p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
169: p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
170: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
171: p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
172: p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
173: p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
174: p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
167: p_RESERVATION_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
168: p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
169: p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
170: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
171: p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
172: p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
173: p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
174: p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
175: p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
168: p_SHIPPED_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
169: p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
170: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
171: p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
172: p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
173: p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
174: p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
175: p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
176: p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
169: p_TRANSACTION_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
170: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
171: p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
172: p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
173: p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
174: p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
175: p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
176: p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
177: p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
170: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
171: p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
172: p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
173: p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
174: p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
175: p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
176: p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
177: p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
171: p_TO_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
172: p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
173: p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
174: p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
175: p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
176: p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
177: p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
172: p_SOURCE_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
173: p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
174: p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
175: p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
176: p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
177: p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
180: p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
173: p_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
174: p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
175: p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
176: p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
177: p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
180: p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
181: p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
174: p_SOURCE_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
175: p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
176: p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
177: p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
180: p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
181: p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
182: p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
175: p_PA_EXPENDITURE_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
176: p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
177: p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
180: p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
181: p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
182: p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
183: p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
176: p_TO_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
177: p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
180: p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
181: p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
182: p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
183: p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
184: p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
177: p_EXPENDITURE_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
180: p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
181: p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
182: p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
183: p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
184: p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
185: p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
178: p_FINAL_COMPLETION_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
180: p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
181: p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
182: p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
183: p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
184: p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
185: p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
186: p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_TRANSFER_PERCENTAGE IN NUMBER := FND_API.G_MISS_NUM,
180: p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
181: p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
182: p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
183: p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
184: p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
185: p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
186: p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
180: p_TRANSACTION_SEQUENCE_ID IN NUMBER := FND_API.G_MISS_NUM,
181: p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
182: p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
183: p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
184: p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
185: p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
186: p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
188: p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_MATERIAL_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
182: p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
183: p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
184: p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
185: p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
186: p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
188: p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
182: p_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
183: p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
184: p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
185: p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
186: p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
188: p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
190: p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
183: p_RESOURCE_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
184: p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
185: p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
186: p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
188: p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
190: p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
191: p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
184: p_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
185: p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
186: p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
188: p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
190: p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
191: p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
192: p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
185: p_OVERHEAD_ACCOUNT IN NUMBER := FND_API.G_MISS_NUM,
186: p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
188: p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
190: p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
191: p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
192: p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
193: p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
186: p_FLOW_SCHEDULE IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
188: p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
190: p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
191: p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
192: p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
193: p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
194: --p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
187: p_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
188: p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
190: p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
191: p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
192: p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
193: p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
194: --p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
195: p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_DEMAND_CLASS IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
190: p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
191: p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
192: p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
193: p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
194: --p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
195: p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
189: p_QA_COLLECTION_ID IN NUMBER := FND_API.G_MISS_NUM,
190: p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
191: p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
192: p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
193: p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
194: --p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
195: p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
197: p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
190: p_KANBAN_CARD_ID IN NUMBER := FND_API.G_MISS_NUM,
191: p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
192: p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
193: p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
194: --p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
195: p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
197: p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
198: p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
191: p_OVERCOMPLETION_TXN_ID IN NUMBER := FND_API.G_MISS_NUM,
192: p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
193: p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
194: --p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
195: p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
197: p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
198: p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
199: p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
192: p_OVERCOMPLETION_PRIMARY_QTY IN NUMBER := FND_API.G_MISS_NUM,
193: p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
194: --p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
195: p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
197: p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
198: p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
199: p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
200: p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
193: p_OVERCOMPLETION_TXN_QTY IN NUMBER := FND_API.G_MISS_NUM,
194: --p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
195: p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
197: p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
198: p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
199: p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
200: p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
201: p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
194: --p_PROCESS_TYPE IN NUMBER := FND_API.G_MISS_NUM,
195: p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
197: p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
198: p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
199: p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
200: p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
201: p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
202: p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
195: p_END_ITEM_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
197: p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
198: p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
199: p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
200: p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
201: p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
202: p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
203: p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
196: p_SCHEDULED_PAYBACK_DATE IN DATE := FND_API.G_MISS_DATE,
197: p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
198: p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
199: p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
200: p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
201: p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
202: p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
203: p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
204: p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
197: p_LINE_TYPE_CODE IN NUMBER := FND_API.G_MISS_NUM,
198: p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
199: p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
200: p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
201: p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
202: p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
203: p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
204: p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
205: p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
198: p_PARENT_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
199: p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
200: p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
201: p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
202: p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
203: p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
204: p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
205: p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
206: p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
199: p_PUT_AWAY_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
200: p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
201: p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
202: p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
203: p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
204: p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
205: p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
206: p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
207: p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
200: p_PUT_AWAY_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
201: p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
202: p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
203: p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
204: p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
205: p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
206: p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
207: p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
201: p_PICK_STRATEGY_ID IN NUMBER := FND_API.G_MISS_NUM,
202: p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
203: p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
204: p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
205: p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
206: p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
207: p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
202: p_PICK_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
203: p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
204: p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
205: p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
206: p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
207: p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
203: p_COMMON_BOM_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
204: p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
205: p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
206: p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
207: p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
204: p_COMMON_ROUTING_SEQ_ID IN NUMBER := FND_API.G_MISS_NUM,
205: p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
206: p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
207: p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
205: p_COST_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
206: p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
207: p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
213: P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
206: p_ORG_COST_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
207: p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
213: P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
214: P_WMS_TASK_TYPE IN NUMBER := FND_API.G_MISS_NUM,
207: p_MOVE_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
213: P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
214: P_WMS_TASK_TYPE IN NUMBER := FND_API.G_MISS_NUM,
215: P_PARENT_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
213: P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
214: P_WMS_TASK_TYPE IN NUMBER := FND_API.G_MISS_NUM,
215: P_PARENT_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
216: -- P_SOURCE_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
213: P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
214: P_WMS_TASK_TYPE IN NUMBER := FND_API.G_MISS_NUM,
215: P_PARENT_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
216: -- P_SOURCE_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: X_Return_Status OUT NOCOPY VARCHAR2,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
213: P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
214: P_WMS_TASK_TYPE IN NUMBER := FND_API.G_MISS_NUM,
215: P_PARENT_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
216: -- P_SOURCE_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: X_Return_Status OUT NOCOPY VARCHAR2,
218: X_Msg_Count OUT NOCOPY NUMBER,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
213: P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
214: P_WMS_TASK_TYPE IN NUMBER := FND_API.G_MISS_NUM,
215: P_PARENT_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
216: -- P_SOURCE_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: X_Return_Status OUT NOCOPY VARCHAR2,
218: X_Msg_Count OUT NOCOPY NUMBER,
219: X_Msg_Data OUT NOCOPY VARCHAR2
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
213: P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
214: P_WMS_TASK_TYPE IN NUMBER := FND_API.G_MISS_NUM,
215: P_PARENT_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
216: -- P_SOURCE_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: X_Return_Status OUT NOCOPY VARCHAR2,
218: X_Msg_Count OUT NOCOPY NUMBER,
219: X_Msg_Data OUT NOCOPY VARCHAR2
220: )
226: l_check_existence NUMBER := 0;
227: l_return_status VARCHAR2(1);
228: l_msg_count NUMBER := 0;
229: l_pick_list_header_id NUMBER;
230: l_commit VARCHAR2(1) := FND_API.G_FALSE;
231: l_creation_date DATE := p_creation_date;
232: l_last_update_date DATE := p_last_update_date;
233: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
234:
233: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
234:
235: -- for inserting data, the validation_level should be none
236: -- because we do not want to call core apps standard validations.
237: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
238: l_transaction_temp_id NUMBER;
239:
240:
241: BEGIN
239:
240:
241: BEGIN
242: SAVEPOINT Validate_And_Write_PUB;
243: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
244: -- initialize message list
245: FND_MSG_PUB.initialize;
246: END IF;
247:
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248: -- Standard call to check for call compatibility.
249: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
250: p_api_version_number,
251: l_api_name,
252: G_PKG_NAME)
253: THEN
250: p_api_version_number,
251: l_api_name,
252: G_PKG_NAME)
253: THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: -- validate p_organization_id
258: IF p_organization_id IS NULL THEN
603: X_Msg_Data => l_msg_data
604: );
605: END IF;
606:
607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSE
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611: IF fnd_api.to_boolean(p_commit) THEN
604: );
605: END IF;
606:
607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSE
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611: IF fnd_api.to_boolean(p_commit) THEN
612: commit work;
606:
607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSE
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611: IF fnd_api.to_boolean(p_commit) THEN
612: commit work;
613: END IF;
614: END IF;
607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSE
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611: IF fnd_api.to_boolean(p_commit) THEN
612: commit work;
613: END IF;
614: END IF;
615:
616:
617: EXCEPTION
618: WHEN EXCP_USER_DEFINED THEN
619: Rollback to Validate_And_Write_PUB;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: fnd_msg_pub.count_and_get
622: ( p_count => x_msg_count
623: , p_data => x_msg_data);
624:
621: fnd_msg_pub.count_and_get
622: ( p_count => x_msg_count
623: , p_data => x_msg_data);
624:
625: WHEN FND_API.G_EXC_ERROR THEN
626: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
627: P_API_NAME => L_API_NAME
628: ,P_PKG_NAME => G_PKG_NAME
629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
630: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
631: ,X_MSG_COUNT => X_MSG_COUNT
632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get
650: ( p_count => x_msg_count
651: , p_data => x_msg_data);
652: x_return_status := fnd_api.g_ret_sts_error;
653:
654: END Validate_and_Write;
655:
656: PROCEDURE CSP_MO_LINES_MANUAL_RECEIPT (
663: -- 27-Dec-99, Vernon Lou.
664: --
665: -- NOTES: If validations have been done in the precedent procedure from which this one is being called, doing a
666: -- full validation here is unnecessary. To avoid repeating the same validations, you can set the
667: -- p_validation_level to fnd_api.g_valid_level_none when making the procedure call. However, it is your
668: -- responsibility to make sure all proper validations have been done before calling this procedure.
669: -- You are recommended to let this procedure handle the validations if you are not sure.
670: -- CAUTIONS: This procedure *ALWAYS* calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.
671: -- If you do not do your own validations before calling this procedure, you should set the p_validation_level
666: -- full validation here is unnecessary. To avoid repeating the same validations, you can set the
667: -- p_validation_level to fnd_api.g_valid_level_none when making the procedure call. However, it is your
668: -- responsibility to make sure all proper validations have been done before calling this procedure.
669: -- You are recommended to let this procedure handle the validations if you are not sure.
670: -- CAUTIONS: This procedure *ALWAYS* calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.
671: -- If you do not do your own validations before calling this procedure, you should set the p_validation_level
672: -- to FND_API.G_VALID_LEVEL_FULL when making the call.
673: -- End of Comments
674:
668: -- responsibility to make sure all proper validations have been done before calling this procedure.
669: -- You are recommended to let this procedure handle the validations if you are not sure.
670: -- CAUTIONS: This procedure *ALWAYS* calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.
671: -- If you do not do your own validations before calling this procedure, you should set the p_validation_level
672: -- to FND_API.G_VALID_LEVEL_FULL when making the call.
673: -- End of Comments
674:
675: P_Api_Version_Number IN NUMBER,
676: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
672: -- to FND_API.G_VALID_LEVEL_FULL when making the call.
673: -- End of Comments
674:
675: P_Api_Version_Number IN NUMBER,
676: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
677: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
679: p_organization_id IN NUMBER,
680: p_transaction_temp_id IN NUMBER,
673: -- End of Comments
674:
675: P_Api_Version_Number IN NUMBER,
676: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
677: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
679: p_organization_id IN NUMBER,
680: p_transaction_temp_id IN NUMBER,
681: px_transaction_header_id IN OUT NOCOPY NUMBER,
674:
675: P_Api_Version_Number IN NUMBER,
676: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
677: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
679: p_organization_id IN NUMBER,
680: p_transaction_temp_id IN NUMBER,
681: px_transaction_header_id IN OUT NOCOPY NUMBER,
682: p_process_flag IN VARCHAR2 := FND_API.G_FALSE,
678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
679: p_organization_id IN NUMBER,
680: p_transaction_temp_id IN NUMBER,
681: px_transaction_header_id IN OUT NOCOPY NUMBER,
682: p_process_flag IN VARCHAR2 := FND_API.G_FALSE,
683: X_Return_Status OUT NOCOPY VARCHAR2,
684: X_Msg_Count OUT NOCOPY NUMBER,
685: X_Msg_Data OUT NOCOPY VARCHAR2)
686: IS
690:
691: l_check_existence NUMBER := 0;
692: l_return_status VARCHAR2(1);
693: l_msg_count NUMBER := 0;
694: l_commit VARCHAR2(1) := FND_API.G_FALSE;
695: l_creation_date DATE;
696: l_last_update_date DATE;
697: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
698: l_csp_mtltxn_new_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
698: l_csp_mtltxn_new_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
699:
700: -- for inserting data, the validation_level should be none
701: -- because we do not want to call core apps standard validations.
702: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
703:
704: l_csp_intransit_subinventory VARCHAR2(20);
705: l_profile_option_id NUMBER;
706: l_to_subinventory VARCHAR2(20);
919:
920: BEGIN
921: SAVEPOINT CSP_MO_LINES_MANUAL_PUB;
922:
923: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
924: -- initialize message list
925: FND_MSG_PUB.initialize;
926: END IF;
927:
925: FND_MSG_PUB.initialize;
926: END IF;
927:
928: -- Standard call to check for call compatibility.
929: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
930: p_api_version_number,
931: l_api_name,
932: G_PKG_NAME)
933: THEN
930: p_api_version_number,
931: l_api_name,
932: G_PKG_NAME)
933: THEN
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;
936:
937: IF p_validation_level = fnd_api.g_valid_level_full THEN
938: -- Notes: if validations have been done in the precedence procedure which this one is being from, doing a full
933: THEN
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;
936:
937: IF p_validation_level = fnd_api.g_valid_level_full THEN
938: -- Notes: if validations have been done in the precedence procedure which this one is being from, doing a full
939: -- validation here is not necessary. The users can set the p_validation_level to fnd_api.g_valid_level_none
940: -- if they do not want to repeat the same validations. However, it is their responsibility to make sure
941: -- all proper validations have been done before calling this procedure. It is recommended that they let
935: END IF;
936:
937: IF p_validation_level = fnd_api.g_valid_level_full THEN
938: -- Notes: if validations have been done in the precedence procedure which this one is being from, doing a full
939: -- validation here is not necessary. The users can set the p_validation_level to fnd_api.g_valid_level_none
940: -- if they do not want to repeat the same validations. However, it is their responsibility to make sure
941: -- all proper validations have been done before calling this procedure. It is recommended that they let
942: -- this procedure handle the validations except that they know what they are doing.
943:
1039: -- This section should be evaluated again when the CSP decides to create the
1040: -- material_tranaction_temp record at the packaging stage instead of the
1041: -- confirm picking stage.
1042: close c_ml_records;
1043: x_return_status := fnd_api.g_ret_sts_success;
1044: return;
1045: END IF;
1046: l_csp_mtltxn_new_rec.transfer_subinventory := l_csp_intransit_subinventory;
1047: l_csp_mtltxn_new_rec.transfer_to_location := NULL;
1157: X_Msg_Data => l_msg_data
1158: );
1159:
1160:
1161: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1162: fnd_message.set_name ('CSP', 'CSP_SUB_TXFER_ERROR');
1163: fnd_msg_pub.add;
1164: IF c_ml_records%ISOPEN THEN
1165: close c_ml_records;
1163: fnd_msg_pub.add;
1164: IF c_ml_records%ISOPEN THEN
1165: close c_ml_records;
1166: END IF;
1167: RAISE FND_API.G_EXC_ERROR;
1168: END IF;
1169:
1170: -- creating a transaction_header_id for inserting into the interface table
1171: IF l_transaction_header_id is null THEN
1175: END IF;
1176:
1177: csp_transactions_pub.transact_temp_record (
1178: P_Api_Version_Number => l_api_version_number,
1179: P_Init_Msg_List => FND_API.G_true,
1180: P_Commit => fnd_api.g_false,
1181: p_validation_level => l_validation_level,
1182: p_transaction_temp_id => l_csp_mtltxn_new_rec.transaction_temp_id,
1183: px_transaction_header_id => l_transaction_header_id,
1176:
1177: csp_transactions_pub.transact_temp_record (
1178: P_Api_Version_Number => l_api_version_number,
1179: P_Init_Msg_List => FND_API.G_true,
1180: P_Commit => fnd_api.g_false,
1181: p_validation_level => l_validation_level,
1182: p_transaction_temp_id => l_csp_mtltxn_new_rec.transaction_temp_id,
1183: px_transaction_header_id => l_transaction_header_id,
1184: p_online_process_flag => FALSE,
1185: X_Return_Status => l_return_status,
1186: X_Msg_Count => l_msg_count,
1187: X_Msg_Data => l_msg_data );
1188:
1189: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: END IF;
1192:
1193: /* DO NOT CLEAN UP THE TEMP RECORDS. OTHERWISE, THE FOLLOWING API WILL ERROR OUT.
1186: X_Msg_Count => l_msg_count,
1187: X_Msg_Data => l_msg_data );
1188:
1189: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: END IF;
1192:
1193: /* DO NOT CLEAN UP THE TEMP RECORDS. OTHERWISE, THE FOLLOWING API WILL ERROR OUT.
1194: Theory: We copy the existing record to the interface table so that we can initialize the
1215:
1216: CSP_Material_Transactions_PVT.Update_material_transactions(
1217: P_Api_Version_Number => p_api_version_number,
1218: P_Init_Msg_List => p_init_msg_list,
1219: P_Commit => fnd_api.g_false,
1220: p_validation_level => l_validation_level,
1221: P_CSP_Rec => l_csp_mtltxn_rec,
1222: X_Return_Status => l_return_status,
1223: X_Msg_Count => l_msg_count,
1223: X_Msg_Count => l_msg_count,
1224: X_Msg_Data => l_msg_data
1225: );
1226:
1227: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1228: fnd_message.set_name ('CSP', 'CSP_SUB_TXFER_ERROR');
1229: fnd_msg_pub.add;
1230: IF c_ml_records%ISOPEN THEN
1231: close c_ml_records;
1229: fnd_msg_pub.add;
1230: IF c_ml_records%ISOPEN THEN
1231: close c_ml_records;
1232: END IF;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235:
1236: -- If it gets to here, processing the mtl_material_transactions_temp should complete successfully.
1237: IF c_ml_records%ISOPEN THEN
1241: /*
1242: -- Finally, call the process_online to perform the underneath material transactions
1243: IF NOT CSP_Mo_Mtltxns_Util.Call_Online (p_transaction_header_id => l_transaction_header_id) THEN
1244: l_outcome := FALSE;
1245: x_return_status := FND_API.G_RET_STS_ERROR;
1246: fnd_msg_pub.count_and_get
1247: ( p_count => x_msg_count
1248: , p_data => x_msg_data);
1249: Return;
1249: Return;
1250: END IF;
1251: */
1252: px_transaction_header_id := l_transaction_header_id;
1253: IF fnd_api.to_boolean(p_commit) THEN
1254: commit work;
1255: END IF;
1256:
1257: x_return_status := fnd_api.g_ret_sts_success;
1253: IF fnd_api.to_boolean(p_commit) THEN
1254: commit work;
1255: END IF;
1256:
1257: x_return_status := fnd_api.g_ret_sts_success;
1258:
1259: EXCEPTION
1260: WHEN EXCP_USER_DEFINED THEN
1261: Rollback to CSP_MO_LINES_MANUAL_PUB;
1258:
1259: EXCEPTION
1260: WHEN EXCP_USER_DEFINED THEN
1261: Rollback to CSP_MO_LINES_MANUAL_PUB;
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: fnd_msg_pub.count_and_get
1264: ( p_count => x_msg_count
1265: , p_data => x_msg_data);
1266: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: fnd_msg_pub.count_and_get
1264: ( p_count => x_msg_count
1265: , p_data => x_msg_data);
1266: WHEN FND_API.G_EXC_ERROR THEN
1267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1268: P_API_NAME => L_API_NAME
1269: ,P_PKG_NAME => G_PKG_NAME
1270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1272: ,X_MSG_COUNT => X_MSG_COUNT
1273: ,X_MSG_DATA => X_MSG_DATA
1274: ,X_RETURN_STATUS => X_RETURN_STATUS);
1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1277: P_API_NAME => L_API_NAME
1278: ,P_PKG_NAME => G_PKG_NAME
1279: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1289: fnd_msg_pub.add;
1290: fnd_msg_pub.count_and_get
1291: ( p_count => x_msg_count
1292: , p_data => x_msg_data);
1293: x_return_status := fnd_api.g_ret_sts_error;
1294:
1295: END CSP_MO_LINES_MANUAL_RECEIPT;
1296:
1297:
1304: -- 29-Dec-99, Vernon Lou.
1305: --
1306: -- NOTES: If validations have been done in the precedent procedure from which this one is being called, doing a
1307: -- full validation here is unnecessary. To avoid repeating the same validations, you can set the
1308: -- p_validation_level to fnd_api.g_valid_level_none when making the procedure call. However, it is your
1309: -- responsibility to make sure all proper validations have been done before calling this procedure.
1310: -- You are recommended to let this procedure handle the validations if you are not sure.
1311: -- CAUTIONS: This procedure *ALWAYS* calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.
1312: -- If you do not do your own validations before calling this procedure, you should set the p_validation_level
1307: -- full validation here is unnecessary. To avoid repeating the same validations, you can set the
1308: -- p_validation_level to fnd_api.g_valid_level_none when making the procedure call. However, it is your
1309: -- responsibility to make sure all proper validations have been done before calling this procedure.
1310: -- You are recommended to let this procedure handle the validations if you are not sure.
1311: -- CAUTIONS: This procedure *ALWAYS* calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.
1312: -- If you do not do your own validations before calling this procedure, you should set the p_validation_level
1313: -- to FND_API.G_VALID_LEVEL_FULL when making the call.
1314: -- End of Comments
1315:
1309: -- responsibility to make sure all proper validations have been done before calling this procedure.
1310: -- You are recommended to let this procedure handle the validations if you are not sure.
1311: -- CAUTIONS: This procedure *ALWAYS* calls other procedures with validation_level set to FND_API.G_VALID_LEVEL_NONE.
1312: -- If you do not do your own validations before calling this procedure, you should set the p_validation_level
1313: -- to FND_API.G_VALID_LEVEL_FULL when making the call.
1314: -- End of Comments
1315:
1316: P_Api_Version_Number IN NUMBER,
1317: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1313: -- to FND_API.G_VALID_LEVEL_FULL when making the call.
1314: -- End of Comments
1315:
1316: P_Api_Version_Number IN NUMBER,
1317: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1318: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1320: p_organization_id IN NUMBER,
1321: p_transaction_temp_id IN NUMBER,
1314: -- End of Comments
1315:
1316: P_Api_Version_Number IN NUMBER,
1317: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1318: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1320: p_organization_id IN NUMBER,
1321: p_transaction_temp_id IN NUMBER,
1322: X_Return_Status OUT NOCOPY VARCHAR2,
1315:
1316: P_Api_Version_Number IN NUMBER,
1317: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1318: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1320: p_organization_id IN NUMBER,
1321: p_transaction_temp_id IN NUMBER,
1322: X_Return_Status OUT NOCOPY VARCHAR2,
1323: X_Msg_Count OUT NOCOPY NUMBER,
1329:
1330: l_check_existence NUMBER := 0;
1331: l_return_status VARCHAR2(1);
1332: l_msg_count NUMBER := 0;
1333: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1334: l_creation_date DATE;
1335: l_last_update_date DATE;
1336: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
1337:
1336: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
1337:
1338: -- for inserting data, the validation_level should be none
1339: -- because we do not want to call core apps standard validations.
1340: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
1341: l_transaction_temp_id NUMBER;
1342:
1343: EXCP_USER_DEFINED EXCEPTION;
1344:
1542: AND organization_id = p_organization_id;
1543: BEGIN
1544: SAVEPOINT CSP_MO_Lines_Auto_PUB;
1545:
1546: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1547: -- initialize message list
1548: FND_MSG_PUB.initialize;
1549: END IF;
1550:
1548: FND_MSG_PUB.initialize;
1549: END IF;
1550:
1551: -- Standard call to check for call compatibility.
1552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1553: p_api_version_number,
1554: l_api_name,
1555: G_PKG_NAME)
1556: THEN
1553: p_api_version_number,
1554: l_api_name,
1555: G_PKG_NAME)
1556: THEN
1557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1558: END IF;
1559:
1560: IF p_validation_level = fnd_api.g_valid_level_full THEN
1561: -- Notes: if validations have been done in the precedence procedure which this one is being from, doing a full
1556: THEN
1557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1558: END IF;
1559:
1560: IF p_validation_level = fnd_api.g_valid_level_full THEN
1561: -- Notes: if validations have been done in the precedence procedure which this one is being from, doing a full
1562: -- validation here is not necessary. The users can set the p_validation_level to fnd_api.g_valid_level_none
1563: -- if they do not want to repeat the same validations. However, it is their responsibility to make sure
1564: -- all proper validations have been done before calling this procedure. It is recommended that they let
1558: END IF;
1559:
1560: IF p_validation_level = fnd_api.g_valid_level_full THEN
1561: -- Notes: if validations have been done in the precedence procedure which this one is being from, doing a full
1562: -- validation here is not necessary. The users can set the p_validation_level to fnd_api.g_valid_level_none
1563: -- if they do not want to repeat the same validations. However, it is their responsibility to make sure
1564: -- all proper validations have been done before calling this procedure. It is recommended that they let
1565: -- this procedure handle the validations except that they know what they are doing.
1566:
1665:
1666: CSP_Material_Transactions_PVT.Update_material_transactions(
1667: P_Api_Version_Number => p_api_version_number,
1668: P_Init_Msg_List => p_init_msg_list,
1669: P_Commit => fnd_api.g_false,
1670: p_validation_level => l_validation_level,
1671: P_CSP_Rec => l_csp_mtltxn_rec,
1672: X_Return_Status => l_return_status,
1673: X_Msg_Count => l_msg_count,
1673: X_Msg_Count => l_msg_count,
1674: X_Msg_Data => l_msg_data
1675: );
1676:
1677: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1678: IF c_ml_records%ISOPEN THEN
1679: close c_ml_records;
1680: END IF;
1681: RAISE FND_API.G_EXC_ERROR;
1677: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1678: IF c_ml_records%ISOPEN THEN
1679: close c_ml_records;
1680: END IF;
1681: RAISE FND_API.G_EXC_ERROR;
1682: END IF;
1683:
1684: END LOOP;
1685:
1689: END IF;
1690:
1691: -- update orderline
1692:
1693: IF fnd_api.to_boolean(p_commit) THEN
1694: commit work;
1695: END IF;
1696:
1697: x_return_status := fnd_api.g_ret_sts_success;
1693: IF fnd_api.to_boolean(p_commit) THEN
1694: commit work;
1695: END IF;
1696:
1697: x_return_status := fnd_api.g_ret_sts_success;
1698:
1699: EXCEPTION
1700: WHEN EXCP_USER_DEFINED THEN
1701: Rollback to CSP_MO_Lines_Auto_PUB;
1698:
1699: EXCEPTION
1700: WHEN EXCP_USER_DEFINED THEN
1701: Rollback to CSP_MO_Lines_Auto_PUB;
1702: x_return_status := FND_API.G_RET_STS_ERROR;
1703: fnd_msg_pub.count_and_get
1704: ( p_count => x_msg_count
1705: , p_data => x_msg_data);
1706:
1703: fnd_msg_pub.count_and_get
1704: ( p_count => x_msg_count
1705: , p_data => x_msg_data);
1706:
1707: WHEN FND_API.G_EXC_ERROR THEN
1708: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1709: P_API_NAME => L_API_NAME
1710: ,P_PKG_NAME => G_PKG_NAME
1711: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1712: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1713: ,X_MSG_COUNT => X_MSG_COUNT
1714: ,X_MSG_DATA => X_MSG_DATA
1715: ,X_RETURN_STATUS => X_RETURN_STATUS);
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1718: P_API_NAME => L_API_NAME
1719: ,P_PKG_NAME => G_PKG_NAME
1720: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1730: fnd_msg_pub.add;
1731: fnd_msg_pub.count_and_get
1732: ( p_count => x_msg_count
1733: , p_data => x_msg_data);
1734: x_return_status := fnd_api.g_ret_sts_error;
1735:
1736:
1737: END CSP_MO_Lines_Auto_Receipt;
1738: