38: -- End of Comments
39:
40: TYPE CSP_Rec_Type IS RECORD
41: (
42: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
39:
40: TYPE CSP_Rec_Type IS RECORD
41: (
42: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
40: TYPE CSP_Rec_Type IS RECORD
41: (
42: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
41: (
42: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
42: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
52: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
52: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
52: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
54: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
52: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
54: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
55: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
48: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
52: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
54: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
55: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
56: );
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
52: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
54: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
55: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
56: );
57:
50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
52: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
54: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
55: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
56: );
57:
58: G_MISS_CSP_REC CSP_Rec_Type;
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
52: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
54: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
55: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
56: );
57:
58: G_MISS_CSP_REC CSP_Rec_Type;
59: TYPE CSP_Tbl_Type IS TABLE OF CSP_Rec_Type
74: -- Pre-Req :
75: -- Parameters:
76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- P_CSP_Rec IN CSP_Rec_Type Required
81: --
82: -- OUT:
75: -- Parameters:
76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- P_CSP_Rec IN CSP_Rec_Type Required
81: --
82: -- OUT:
83: -- x_return_status OUT NOCOPY VARCHAR2
90: -- End of Comments
91: --
92: Procedure ASSIGN_RESOURCE_INV_LOC (
93: P_Api_Version_Number IN NUMBER
94: ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
95: ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_action_code IN NUMBER
98: ,px_CSP_INV_LOC_ASSIGNMENT_ID IN OUT NOCOPY NUMBER
91: --
92: Procedure ASSIGN_RESOURCE_INV_LOC (
93: P_Api_Version_Number IN NUMBER
94: ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
95: ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_action_code IN NUMBER
98: ,px_CSP_INV_LOC_ASSIGNMENT_ID IN OUT NOCOPY NUMBER
99: ,p_CREATED_BY IN NUMBER
92: Procedure ASSIGN_RESOURCE_INV_LOC (
93: P_Api_Version_Number IN NUMBER
94: ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
95: ,P_Commit IN VARCHAR2 := FND_API.G_FALSE
96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97: ,p_action_code IN NUMBER
98: ,px_CSP_INV_LOC_ASSIGNMENT_ID IN OUT NOCOPY NUMBER
99: ,p_CREATED_BY IN NUMBER
100: ,p_CREATION_DATE IN DATE