DBA Data[Home] [Help]

APPS.CSP_RESOURCE_PUB dependencies on FND_API

Line 42: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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,

Line 44: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 45: LAST_UPDATED_BY 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,

Line 46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 47: LAST_UPDATE_LOGIN 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,
51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

Line 48: RESOURCE_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,

Line 49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 50: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,

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,

Line 51: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 52: RESOURCE_TYPE 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: );

Line 53: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,

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:

Line 54: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,

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;

Line 55: DEFAULT_CODE VARCHAR2(30) := 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;
59: TYPE CSP_Tbl_Type IS TABLE OF CSP_Rec_Type

Line 78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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:

Line 79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 94: ,P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

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

Line 95: ,P_Commit IN VARCHAR2 := FND_API.G_FALSE

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

Line 96: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

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