APPS.CSP_RESOURCE_PVT dependencies on FND_API

Line 58: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,

54: -- End of Comments
55:
56: TYPE CSP_Rec_Type IS RECORD
57: (
58: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

55:
56: TYPE CSP_Rec_Type IS RECORD
57: (
58: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 60: CREATION_DATE DATE := FND_API.G_MISS_DATE,

56: TYPE CSP_Rec_Type IS RECORD
57: (
58: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

Line 61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

57: (
58: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

58: CSP_INV_LOC_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
66: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,

Line 63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
66: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

Line 64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
66: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
66: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,

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

62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
66: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,

Line 67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,

63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
66: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

64: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
66: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,

65: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
66: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,

66: SUBINVENTORY_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

67: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

68: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

69: EFFECTIVE_DATE_START DATE := FND_API.G_MISS_DATE,
70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

70: EFFECTIVE_DATE_END DATE := FND_API.G_MISS_DATE,
71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

71: DEFAULT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

73: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

74: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

75: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

76: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

77: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

78: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

79: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 84: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

80: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: );

Line 85: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

81: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: );
89:

Line 86: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

82: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: );
89:
90: G_MISS_CSP_REC CSP_Rec_Type;

Line 87: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR

83: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: );
89:
90: G_MISS_CSP_REC CSP_Rec_Type;
91: TYPE CSP_Tbl_Type IS TABLE OF CSP_Rec_Type

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

100: -- Pre-Req :
101: -- Parameters:
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- P_CSP_Rec IN CSP_Rec_Type Required
108: --

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

101: -- Parameters:
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- P_CSP_Rec IN CSP_Rec_Type Required
108: --
109: -- OUT:

Line 106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- P_CSP_Rec IN CSP_Rec_Type Required
108: --
109: -- OUT:
110: -- x_return_status OUT NOCOPY VARCHAR2

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

117: -- End of Comments
118: --
119: PROCEDURE Create_resource(
120: P_Api_Version_Number IN NUMBER,
121: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
122: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: P_CSP_Rec IN CSP_Rec_Type := G_MISS_CSP_REC,
125: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

118: --
119: PROCEDURE Create_resource(
120: P_Api_Version_Number IN NUMBER,
121: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
122: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: P_CSP_Rec IN CSP_Rec_Type := G_MISS_CSP_REC,
125: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
126: X_CSP_INV_LOC_ASSIGNMENT_ID OUT NOCOPY NUMBER,

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

119: PROCEDURE Create_resource(
120: P_Api_Version_Number IN NUMBER,
121: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
122: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: P_CSP_Rec IN CSP_Rec_Type := G_MISS_CSP_REC,
125: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
126: X_CSP_INV_LOC_ASSIGNMENT_ID OUT NOCOPY NUMBER,
127: X_Return_Status OUT NOCOPY VARCHAR2,

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

137: -- Pre-Req :
138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
145: -- P_CSP_Rec IN CSP_Rec_Type Required

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

138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
145: -- P_CSP_Rec IN CSP_Rec_Type Required
146: --

Line 143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
145: -- P_CSP_Rec IN CSP_Rec_Type Required
146: --
147: -- OUT:

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

156: --
157: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
158: PROCEDURE Update_resource(
159: P_Api_Version_Number IN NUMBER,
160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: P_Identity_Salesforce_Id IN NUMBER := NULL,
164: P_CSP_Rec IN CSP_Rec_Type,

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

157: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
158: PROCEDURE Update_resource(
159: P_Api_Version_Number IN NUMBER,
160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: P_Identity_Salesforce_Id IN NUMBER := NULL,
164: P_CSP_Rec IN CSP_Rec_Type,
165: X_Return_Status OUT NOCOPY VARCHAR2,

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

158: PROCEDURE Update_resource(
159: P_Api_Version_Number IN NUMBER,
160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: P_Identity_Salesforce_Id IN NUMBER := NULL,
164: P_CSP_Rec IN CSP_Rec_Type,
165: X_Return_Status OUT NOCOPY VARCHAR2,
166: X_Msg_Count OUT NOCOPY NUMBER,

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

175: -- Pre-Req :
176: -- Parameters:
177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
183: -- P_CSP_Rec IN CSP_Rec_Type Required

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

176: -- Parameters:
177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
183: -- P_CSP_Rec IN CSP_Rec_Type Required
184: --

Line 181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
183: -- P_CSP_Rec IN CSP_Rec_Type Required
184: --
185: -- OUT:

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

195: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
196: -- The Master delete procedure may not be needed depends on different business requirements.
197: PROCEDURE Delete_resource(
198: P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: P_identity_salesforce_id IN NUMBER := NULL,
203: P_CSP_Rec IN CSP_Rec_Type,

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

196: -- The Master delete procedure may not be needed depends on different business requirements.
197: PROCEDURE Delete_resource(
198: P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: P_identity_salesforce_id IN NUMBER := NULL,
203: P_CSP_Rec IN CSP_Rec_Type,
204: X_Return_Status OUT NOCOPY VARCHAR2,

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

197: PROCEDURE Delete_resource(
198: P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: P_identity_salesforce_id IN NUMBER := NULL,
203: P_CSP_Rec IN CSP_Rec_Type,
204: X_Return_Status OUT NOCOPY VARCHAR2,
205: X_Msg_Count OUT NOCOPY NUMBER,

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

217: --
218: -- End of Comments
219:
220: PROCEDURE Validate_CILA (
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Validation_mode IN VARCHAR2,
223: P_CSP_INV_LOC_ASSIGNMENT_ID IN NUMBER,
224: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
225: X_Return_Status OUT NOCOPY VARCHAR2,

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

238: --
239: -- End of Comments
240:
241: PROCEDURE Validate_RESOURCE_ID (
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Validation_mode IN VARCHAR2,
244: P_RESOURCE_ID IN NUMBER,
245: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
246: X_Return_Status OUT NOCOPY VARCHAR2,

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

259: --
260: -- End of Comments
261:
262: PROCEDURE Validate_ORGANIZATION_ID (
263: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
264: P_Validation_mode IN VARCHAR2,
265: P_ORGANIZATION_ID IN NUMBER,
266: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
267: X_Return_Status OUT NOCOPY VARCHAR2,

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

280: --
281: -- End of Comments
282:
283: PROCEDURE Validate_SUBINVENTORY_CODE (
284: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285: P_Validation_mode IN VARCHAR2,
286: P_SUBINVENTORY_CODE IN VARCHAR2,
287: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
288: X_Return_Status OUT NOCOPY VARCHAR2,

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

301: --
302: -- End of Comments
303:
304: PROCEDURE Validate_LOCATOR_ID (
305: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
306: P_Validation_mode IN VARCHAR2,
307: P_LOCATOR_ID IN NUMBER,
308: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
309: X_Return_Status OUT NOCOPY VARCHAR2,

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

322: --
323: -- End of Comments
324:
325: PROCEDURE Validate_RESOURCE_TYPE (
326: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327: P_Validation_mode IN VARCHAR2,
328: P_RESOURCE_TYPE IN VARCHAR2,
329: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
330: X_Return_Status OUT NOCOPY VARCHAR2,

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

343: --
344: -- End of Comments
345:
346: PROCEDURE Validate_EFFECTIVE_DATE_START (
347: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
348: P_Validation_mode IN VARCHAR2,
349: P_EFFECTIVE_DATE_START IN DATE,
350: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
351: X_Return_Status OUT NOCOPY VARCHAR2,

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

364: --
365: -- End of Comments
366:
367: PROCEDURE Validate_EFFECTIVE_DATE_END (
368: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
369: P_Validation_mode IN VARCHAR2,
370: P_EFFECTIVE_DATE_END IN DATE,
371: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
372: X_Return_Status OUT NOCOPY VARCHAR2,

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

385: --
386: -- End of Comments
387:
388: PROCEDURE Validate_DEFAULT_CODE (
389: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
390: P_Validation_mode IN VARCHAR2,
391: P_DEFAULT_CODE IN VARCHAR2,
392: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
393: X_Return_Status OUT NOCOPY VARCHAR2,

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

406: -- 2. Developer can manually added inter-field level validation.
407: -- End of Comments
408:
409: PROCEDURE Validate_CSP_rec(
410: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
411: P_Validation_mode IN VARCHAR2,
412: P_CSP_Rec IN CSP_Rec_Type,
413: X_Return_Status OUT NOCOPY VARCHAR2,
414: X_Msg_Count OUT NOCOPY NUMBER,

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

426: -- 2. We can also validate table instead of record. There will be an option for user to choose.
427: -- End of Comments
428:
429: PROCEDURE Validate_resource(
430: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
431: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: P_Validation_mode IN VARCHAR2,
433: P_CSP_Rec IN CSP_Rec_Type,
434: X_Return_Status OUT NOCOPY VARCHAR2,

Line 431: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

427: -- End of Comments
428:
429: PROCEDURE Validate_resource(
430: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
431: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: P_Validation_mode IN VARCHAR2,
433: P_CSP_Rec IN CSP_Rec_Type,
434: X_Return_Status OUT NOCOPY VARCHAR2,
435: X_Msg_Count OUT NOCOPY NUMBER,