APPS.CSP_RS_CUST_RELATION_PVT dependencies on FND_API

Line 53: RS_CUST_RELATION_ID NUMBER := FND_API.G_MISS_NUM,

49: -- End of Comments
50:
51: TYPE RCR_Rec_Type IS RECORD
52: (
53: RS_CUST_RELATION_ID NUMBER := FND_API.G_MISS_NUM,
54: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
56: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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

50:
51: TYPE RCR_Rec_Type IS RECORD
52: (
53: RS_CUST_RELATION_ID NUMBER := FND_API.G_MISS_NUM,
54: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
56: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 55: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,

51: TYPE RCR_Rec_Type IS RECORD
52: (
53: RS_CUST_RELATION_ID NUMBER := FND_API.G_MISS_NUM,
54: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
56: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 56: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,

52: (
53: RS_CUST_RELATION_ID NUMBER := FND_API.G_MISS_NUM,
54: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
56: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

53: RS_CUST_RELATION_ID NUMBER := FND_API.G_MISS_NUM,
54: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
56: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 58: CREATION_DATE DATE := FND_API.G_MISS_DATE,

54: RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
56: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

55: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
56: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

56: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

57: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

58: CREATION_DATE DATE := FND_API.G_MISS_DATE,
59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

59: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

60: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

61: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

62: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

63: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

64: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

65: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

66: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

67: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

68: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

69: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 74: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

70: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: );

Line 75: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

71: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: );
79:

Line 76: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

72: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: );
79:
80: G_MISS_RCR_REC RCR_Rec_Type;

Line 77: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

73: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: );
79:
80: G_MISS_RCR_REC RCR_Rec_Type;
81: TYPE RCR_Tbl_Type IS TABLE OF RCR_Rec_Type

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

90: -- Pre-Req :
91: -- Parameters:
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

91: -- Parameters:
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_admin_group_id IN NUMBER Required

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

92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_admin_group_id IN NUMBER Required
100: -- P_RCR_Rec IN RCR_Rec_Type Required

Line 97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_admin_group_id IN NUMBER Required
100: -- P_RCR_Rec IN RCR_Rec_Type Required
101: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

Line 98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- p_admin_group_id IN NUMBER Required
100: -- P_RCR_Rec IN RCR_Rec_Type Required
101: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
102: --

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

111: -- End of Comments
112: --
113: PROCEDURE Create_rs_cust_relation(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_RCR_Rec IN RCR_Rec_Type := G_MISS_RCR_REC,
119: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

112: --
113: PROCEDURE Create_rs_cust_relation(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_RCR_Rec IN RCR_Rec_Type := G_MISS_RCR_REC,
119: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120: X_RS_CUST_RELATION_ID OUT NOCOPY NUMBER,

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

113: PROCEDURE Create_rs_cust_relation(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: P_RCR_Rec IN RCR_Rec_Type := G_MISS_RCR_REC,
119: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120: X_RS_CUST_RELATION_ID OUT NOCOPY NUMBER,
121: X_Return_Status OUT NOCOPY VARCHAR2,

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

131: -- Pre-Req :
132: -- Parameters:
133: -- IN
134: -- p_api_version_number IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

132: -- Parameters:
133: -- IN
134: -- p_api_version_number IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_admin_group_id IN NUMBER Required

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

133: -- IN
134: -- p_api_version_number IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_admin_group_id IN NUMBER Required
141: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

Line 138: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

134: -- p_api_version_number IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_admin_group_id IN NUMBER Required
141: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
142: -- P_RCR_Rec IN RCR_Rec_Type Required

Line 139: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

135: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_admin_group_id IN NUMBER Required
141: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
142: -- P_RCR_Rec IN RCR_Rec_Type Required
143: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

154: --
155: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
156: PROCEDURE Update_rs_cust_relation(
157: P_Api_Version_Number IN NUMBER,
158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: P_Identity_Salesforce_Id IN NUMBER := NULL,
162: P_RCR_Rec IN RCR_Rec_Type,

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

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

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

156: PROCEDURE Update_rs_cust_relation(
157: P_Api_Version_Number IN NUMBER,
158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: P_Identity_Salesforce_Id IN NUMBER := NULL,
162: P_RCR_Rec IN RCR_Rec_Type,
163: X_Return_Status OUT NOCOPY VARCHAR2,
164: X_Msg_Count OUT NOCOPY NUMBER,

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

173: -- Pre-Req :
174: -- Parameters:
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

174: -- Parameters:
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_admin_group_id IN NUMBER Required

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

175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_admin_group_id IN NUMBER Required
183: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

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

176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_admin_group_id IN NUMBER Required
183: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
184: -- P_RCR_Rec IN RCR_Rec_Type Required

Line 181: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_admin_group_id IN NUMBER Required
183: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
184: -- P_RCR_Rec IN RCR_Rec_Type Required
185: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

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

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

198: -- The Master delete procedure may not be needed depends on different business requirements.
199: PROCEDURE Delete_rs_cust_relation(
200: P_Api_Version_Number IN NUMBER,
201: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
202: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: P_Identity_Salesforce_Id IN NUMBER := NULL,
205: P_RCR_Rec IN RCR_Rec_Type,
206: X_Return_Status OUT NOCOPY VARCHAR2,

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

199: PROCEDURE Delete_rs_cust_relation(
200: P_Api_Version_Number IN NUMBER,
201: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
202: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: P_Identity_Salesforce_Id IN NUMBER := NULL,
205: P_RCR_Rec IN RCR_Rec_Type,
206: X_Return_Status OUT NOCOPY VARCHAR2,
207: X_Msg_Count OUT NOCOPY NUMBER,

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

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

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

240: --
241: -- End of Comments
242:
243: PROCEDURE Validate_RESOURCE_TYPE (
244: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
245: P_Validation_mode IN VARCHAR2,
246: P_RESOURCE_TYPE IN VARCHAR2,
247: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
248: X_Return_Status OUT NOCOPY VARCHAR2,

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

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

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

283: --
284: -- End of Comments
285:
286: PROCEDURE Validate_CUSTOMER_ID (
287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288: P_Validation_mode IN VARCHAR2,
289: P_CUSTOMER_ID IN NUMBER,
290: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
291: X_Return_Status OUT NOCOPY VARCHAR2,

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

304: -- 2. Developer can manually added inter-field level validation.
305: -- End of Comments
306:
307: PROCEDURE Validate_RCR_rec(
308: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
309: P_Validation_mode IN VARCHAR2,
310: P_RCR_Rec IN RCR_Rec_Type,
311: X_Return_Status OUT NOCOPY VARCHAR2,
312: X_Msg_Count OUT NOCOPY NUMBER,

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

324: -- 2. We can also validate table instead of record. There will be an option for user to choose.
325: -- End of Comments
326:
327: PROCEDURE Validate_rs_cust_relation(
328: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
329: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: P_Validation_mode IN VARCHAR2,
331: P_RCR_Rec IN RCR_Rec_Type,
332: X_Return_Status OUT NOCOPY VARCHAR2,

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

325: -- End of Comments
326:
327: PROCEDURE Validate_rs_cust_relation(
328: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
329: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: P_Validation_mode IN VARCHAR2,
331: P_RCR_Rec IN RCR_Rec_Type,
332: X_Return_Status OUT NOCOPY VARCHAR2,
333: X_Msg_Count OUT NOCOPY NUMBER,