eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_RS_CUST_RELATION_PUB 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 100: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

96: -- Pre-Req :
97: -- Parameters:
98: -- IN
99: -- p_api_version_number IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

97: -- Parameters:
98: -- IN
99: -- p_api_version_number IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_admin_group_id IN NUMBER Required

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

98: -- IN
99: -- p_api_version_number IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_admin_group_id IN NUMBER Required
106: -- P_RCR_Rec IN RCR_Rec_Type Required

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

99: -- p_api_version_number IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_admin_group_id IN NUMBER Required
106: -- P_RCR_Rec IN RCR_Rec_Type Required
107: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

100: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_admin_group_id IN NUMBER Required
106: -- P_RCR_Rec IN RCR_Rec_Type Required
107: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
108: --

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

117: -- End of Comments
118: --
119: PROCEDURE Create_rs_cust_relation(
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_RCR_Rec IN RCR_Rec_Type := G_MISS_RCR_REC,
124: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
125: X_RS_CUST_RELATION_ID OUT NOCOPY NUMBER,

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

118: --
119: PROCEDURE Create_rs_cust_relation(
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_RCR_Rec IN RCR_Rec_Type := G_MISS_RCR_REC,
124: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
125: X_RS_CUST_RELATION_ID OUT NOCOPY NUMBER,
126: X_Return_Status OUT NOCOPY VARCHAR2,

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

136: -- Pre-Req :
137: -- Parameters:
138: -- IN
139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

137: -- Parameters:
138: -- IN
139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_admin_group_id IN NUMBER Required

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

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

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

139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_admin_group_id IN NUMBER Required
146: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147: -- P_RCR_Rec IN RCR_Rec_Type Required

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

140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_admin_group_id IN NUMBER Required
146: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147: -- P_RCR_Rec IN RCR_Rec_Type Required
148: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

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

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

160: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
161: PROCEDURE Update_rs_cust_relation(
162: P_Api_Version_Number IN NUMBER,
163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165: P_Identity_Salesforce_Id IN NUMBER := NULL ,
166: P_RCR_Rec IN RCR_Rec_Type,
167: X_Return_Status OUT NOCOPY VARCHAR2,
168: X_Msg_Count OUT NOCOPY NUMBER,

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

177: -- Pre-Req :
178: -- Parameters:
179: -- IN
180: -- p_api_version_number IN NUMBER Required
181: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
182: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
183: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
184: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

178: -- Parameters:
179: -- IN
180: -- p_api_version_number IN NUMBER Required
181: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
182: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
183: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
184: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_admin_group_id IN NUMBER Required

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

179: -- IN
180: -- p_api_version_number IN NUMBER Required
181: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
182: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
183: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
184: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_admin_group_id IN NUMBER Required
187: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

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

180: -- p_api_version_number IN NUMBER Required
181: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
182: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
183: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
184: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_admin_group_id IN NUMBER Required
187: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
188: -- P_RCR_Rec IN RCR_Rec_Type Required

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

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

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

201: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
202: -- The Master delete procedure may not be needed depends on different business requirements.
203: PROCEDURE Delete_rs_cust_relation(
204: P_Api_Version_Number IN NUMBER,
205: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
206: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
207: P_Identity_Salesforce_Id IN NUMBER := NULL ,
208: P_RCR_Rec IN RCR_Rec_Type,
209: X_Return_Status OUT NOCOPY VARCHAR2,

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

202: -- The Master delete procedure may not be needed depends on different business requirements.
203: PROCEDURE Delete_rs_cust_relation(
204: P_Api_Version_Number IN NUMBER,
205: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
206: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
207: P_Identity_Salesforce_Id IN NUMBER := NULL ,
208: P_RCR_Rec IN RCR_Rec_Type,
209: X_Return_Status OUT NOCOPY VARCHAR2,
210: X_Msg_Count OUT NOCOPY NUMBER,

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

219: -- Pre-Req :
220: -- Parameters:
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
226: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_admin_group_id IN NUMBER Required

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

220: -- Parameters:
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
226: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_admin_group_id IN NUMBER Required
228: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

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

221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
226: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_admin_group_id IN NUMBER Required
228: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
229: -- P_RCR_Rec IN RCR_Rec_Type Required

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

222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
226: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_admin_group_id IN NUMBER Required
228: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
229: -- P_RCR_Rec IN RCR_Rec_Type Required
230: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

Line 238: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

234: --
235: -- Return Total Records Count Flag. This flag controls whether the total record count
236: -- and total record amount is returned.
237: --
238: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- Hint: User defined record type
240: -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
241: --
242: -- OUT:

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

256: -- End of Comments
257: --
258: PROCEDURE Get_rs_cust_relation(
259: P_Api_Version_Number IN NUMBER,
260: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
261: P_identity_salesforce_id IN NUMBER := NULL,
262: P_RCR_Rec IN CSP_rs_cust_relation_PUB.RCR_Rec_Type,
263: -- Hint: Add list of bind variables here
264: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

Line 266: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

262: P_RCR_Rec IN CSP_rs_cust_relation_PUB.RCR_Rec_Type,
263: -- Hint: Add list of bind variables here
264: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
265: p_start_rec_prt IN NUMBER := 1,
266: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
267: -- Hint: user defined record type
268: p_order_by_rec IN CSP_rs_cust_relation_PUB.RCR_sort_rec_type,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,