APPS.AS_ACCESS_PUB dependencies on FND_API

Line 86: ,last_update_date DATE := FND_API.G_MISS_DATE

82:
83: TYPE sales_team_rec_type IS RECORD
84: (
85: access_id NUMBER := NULL
86: ,last_update_date DATE := FND_API.G_MISS_DATE
87: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
88: ,creation_date DATE := FND_API.G_MISS_DATE
89: ,created_by NUMBER := FND_API.G_MISS_NUM
90: ,last_update_login NUMBER := FND_API.G_MISS_NUM

Line 87: ,last_updated_by NUMBER := FND_API.G_MISS_NUM

83: TYPE sales_team_rec_type IS RECORD
84: (
85: access_id NUMBER := NULL
86: ,last_update_date DATE := FND_API.G_MISS_DATE
87: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
88: ,creation_date DATE := FND_API.G_MISS_DATE
89: ,created_by NUMBER := FND_API.G_MISS_NUM
90: ,last_update_login NUMBER := FND_API.G_MISS_NUM
91: ,freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 88: ,creation_date DATE := FND_API.G_MISS_DATE

84: (
85: access_id NUMBER := NULL
86: ,last_update_date DATE := FND_API.G_MISS_DATE
87: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
88: ,creation_date DATE := FND_API.G_MISS_DATE
89: ,created_by NUMBER := FND_API.G_MISS_NUM
90: ,last_update_login NUMBER := FND_API.G_MISS_NUM
91: ,freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,reassign_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 89: ,created_by NUMBER := FND_API.G_MISS_NUM

85: access_id NUMBER := NULL
86: ,last_update_date DATE := FND_API.G_MISS_DATE
87: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
88: ,creation_date DATE := FND_API.G_MISS_DATE
89: ,created_by NUMBER := FND_API.G_MISS_NUM
90: ,last_update_login NUMBER := FND_API.G_MISS_NUM
91: ,freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,reassign_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,team_leader_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 90: ,last_update_login NUMBER := FND_API.G_MISS_NUM

86: ,last_update_date DATE := FND_API.G_MISS_DATE
87: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
88: ,creation_date DATE := FND_API.G_MISS_DATE
89: ,created_by NUMBER := FND_API.G_MISS_NUM
90: ,last_update_login NUMBER := FND_API.G_MISS_NUM
91: ,freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,reassign_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,team_leader_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
94: ,customer_id NUMBER := NULL

Line 91: ,freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

87: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
88: ,creation_date DATE := FND_API.G_MISS_DATE
89: ,created_by NUMBER := FND_API.G_MISS_NUM
90: ,last_update_login NUMBER := FND_API.G_MISS_NUM
91: ,freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,reassign_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,team_leader_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
94: ,customer_id NUMBER := NULL
95: ,address_id NUMBER := NULL

Line 92: ,reassign_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

88: ,creation_date DATE := FND_API.G_MISS_DATE
89: ,created_by NUMBER := FND_API.G_MISS_NUM
90: ,last_update_login NUMBER := FND_API.G_MISS_NUM
91: ,freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,reassign_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,team_leader_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
94: ,customer_id NUMBER := NULL
95: ,address_id NUMBER := NULL
96: ,salesforce_id NUMBER := NULL

Line 93: ,team_leader_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

89: ,created_by NUMBER := FND_API.G_MISS_NUM
90: ,last_update_login NUMBER := FND_API.G_MISS_NUM
91: ,freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,reassign_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,team_leader_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
94: ,customer_id NUMBER := NULL
95: ,address_id NUMBER := NULL
96: ,salesforce_id NUMBER := NULL
97: ,person_id NUMBER := NULL

Line 101: ,first_name VARCHAR2(150) := FND_API.G_MISS_CHAR

97: ,person_id NUMBER := NULL
98: ,job_title VARCHAR2(240) := NULL -- Only used for query
99: -- ,ptr_mgr_last_name VARCHAR2(40) := NULL -- Only used for query
100: -- ,ptr_mgr_first_name VARCHAR2(20) := NULL -- Only used for query
101: ,first_name VARCHAR2(150) := FND_API.G_MISS_CHAR
102: ,last_name VARCHAR2(150) := FND_API.G_MISS_CHAR
103: ,email_address VARCHAR2(240) := FND_API.G_MISS_CHAR
104: ,work_telephone VARCHAR2(60) := FND_API.G_MISS_CHAR
105: ,sales_group_id NUMBER := FND_API.G_MISS_NUM

Line 102: ,last_name VARCHAR2(150) := FND_API.G_MISS_CHAR

98: ,job_title VARCHAR2(240) := NULL -- Only used for query
99: -- ,ptr_mgr_last_name VARCHAR2(40) := NULL -- Only used for query
100: -- ,ptr_mgr_first_name VARCHAR2(20) := NULL -- Only used for query
101: ,first_name VARCHAR2(150) := FND_API.G_MISS_CHAR
102: ,last_name VARCHAR2(150) := FND_API.G_MISS_CHAR
103: ,email_address VARCHAR2(240) := FND_API.G_MISS_CHAR
104: ,work_telephone VARCHAR2(60) := FND_API.G_MISS_CHAR
105: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
106: ,sales_group_name VARCHAR2(60) := FND_API.G_MISS_CHAR

Line 103: ,email_address VARCHAR2(240) := FND_API.G_MISS_CHAR

99: -- ,ptr_mgr_last_name VARCHAR2(40) := NULL -- Only used for query
100: -- ,ptr_mgr_first_name VARCHAR2(20) := NULL -- Only used for query
101: ,first_name VARCHAR2(150) := FND_API.G_MISS_CHAR
102: ,last_name VARCHAR2(150) := FND_API.G_MISS_CHAR
103: ,email_address VARCHAR2(240) := FND_API.G_MISS_CHAR
104: ,work_telephone VARCHAR2(60) := FND_API.G_MISS_CHAR
105: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
106: ,sales_group_name VARCHAR2(60) := FND_API.G_MISS_CHAR
107: ,partner_customer_id NUMBER := NULL

Line 104: ,work_telephone VARCHAR2(60) := FND_API.G_MISS_CHAR

100: -- ,ptr_mgr_first_name VARCHAR2(20) := NULL -- Only used for query
101: ,first_name VARCHAR2(150) := FND_API.G_MISS_CHAR
102: ,last_name VARCHAR2(150) := FND_API.G_MISS_CHAR
103: ,email_address VARCHAR2(240) := FND_API.G_MISS_CHAR
104: ,work_telephone VARCHAR2(60) := FND_API.G_MISS_CHAR
105: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
106: ,sales_group_name VARCHAR2(60) := FND_API.G_MISS_CHAR
107: ,partner_customer_id NUMBER := NULL
108: ,partner_address_id NUMBER := NULL

Line 105: ,sales_group_id NUMBER := FND_API.G_MISS_NUM

101: ,first_name VARCHAR2(150) := FND_API.G_MISS_CHAR
102: ,last_name VARCHAR2(150) := FND_API.G_MISS_CHAR
103: ,email_address VARCHAR2(240) := FND_API.G_MISS_CHAR
104: ,work_telephone VARCHAR2(60) := FND_API.G_MISS_CHAR
105: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
106: ,sales_group_name VARCHAR2(60) := FND_API.G_MISS_CHAR
107: ,partner_customer_id NUMBER := NULL
108: ,partner_address_id NUMBER := NULL
109: ,partner_name VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 106: ,sales_group_name VARCHAR2(60) := FND_API.G_MISS_CHAR

102: ,last_name VARCHAR2(150) := FND_API.G_MISS_CHAR
103: ,email_address VARCHAR2(240) := FND_API.G_MISS_CHAR
104: ,work_telephone VARCHAR2(60) := FND_API.G_MISS_CHAR
105: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
106: ,sales_group_name VARCHAR2(60) := FND_API.G_MISS_CHAR
107: ,partner_customer_id NUMBER := NULL
108: ,partner_address_id NUMBER := NULL
109: ,partner_name VARCHAR2(50) := FND_API.G_MISS_CHAR
110: ,partner_number VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 109: ,partner_name VARCHAR2(50) := FND_API.G_MISS_CHAR

105: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
106: ,sales_group_name VARCHAR2(60) := FND_API.G_MISS_CHAR
107: ,partner_customer_id NUMBER := NULL
108: ,partner_address_id NUMBER := NULL
109: ,partner_name VARCHAR2(50) := FND_API.G_MISS_CHAR
110: ,partner_number VARCHAR2(30) := FND_API.G_MISS_CHAR
111: ,partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR
112: ,partner_phone_number VARCHAR2(25) := FND_API.G_MISS_CHAR
113: ,partner_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 110: ,partner_number VARCHAR2(30) := FND_API.G_MISS_CHAR

106: ,sales_group_name VARCHAR2(60) := FND_API.G_MISS_CHAR
107: ,partner_customer_id NUMBER := NULL
108: ,partner_address_id NUMBER := NULL
109: ,partner_name VARCHAR2(50) := FND_API.G_MISS_CHAR
110: ,partner_number VARCHAR2(30) := FND_API.G_MISS_CHAR
111: ,partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR
112: ,partner_phone_number VARCHAR2(25) := FND_API.G_MISS_CHAR
113: ,partner_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR
114: ,partner_extension VARCHAR2(20) := FND_API.G_MISS_CHAR

Line 111: ,partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR

107: ,partner_customer_id NUMBER := NULL
108: ,partner_address_id NUMBER := NULL
109: ,partner_name VARCHAR2(50) := FND_API.G_MISS_CHAR
110: ,partner_number VARCHAR2(30) := FND_API.G_MISS_CHAR
111: ,partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR
112: ,partner_phone_number VARCHAR2(25) := FND_API.G_MISS_CHAR
113: ,partner_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR
114: ,partner_extension VARCHAR2(20) := FND_API.G_MISS_CHAR
115: ,created_person_id NUMBER := NULL

Line 112: ,partner_phone_number VARCHAR2(25) := FND_API.G_MISS_CHAR

108: ,partner_address_id NUMBER := NULL
109: ,partner_name VARCHAR2(50) := FND_API.G_MISS_CHAR
110: ,partner_number VARCHAR2(30) := FND_API.G_MISS_CHAR
111: ,partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR
112: ,partner_phone_number VARCHAR2(25) := FND_API.G_MISS_CHAR
113: ,partner_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR
114: ,partner_extension VARCHAR2(20) := FND_API.G_MISS_CHAR
115: ,created_person_id NUMBER := NULL
116: ,lead_id NUMBER := NULL

Line 113: ,partner_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR

109: ,partner_name VARCHAR2(50) := FND_API.G_MISS_CHAR
110: ,partner_number VARCHAR2(30) := FND_API.G_MISS_CHAR
111: ,partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR
112: ,partner_phone_number VARCHAR2(25) := FND_API.G_MISS_CHAR
113: ,partner_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR
114: ,partner_extension VARCHAR2(20) := FND_API.G_MISS_CHAR
115: ,created_person_id NUMBER := NULL
116: ,lead_id NUMBER := NULL
117: ,freeze_date DATE := NULL

Line 114: ,partner_extension VARCHAR2(20) := FND_API.G_MISS_CHAR

110: ,partner_number VARCHAR2(30) := FND_API.G_MISS_CHAR
111: ,partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR
112: ,partner_phone_number VARCHAR2(25) := FND_API.G_MISS_CHAR
113: ,partner_area_code VARCHAR2(10) := FND_API.G_MISS_CHAR
114: ,partner_extension VARCHAR2(20) := FND_API.G_MISS_CHAR
115: ,created_person_id NUMBER := NULL
116: ,lead_id NUMBER := NULL
117: ,freeze_date DATE := NULL
118: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 118: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR

114: ,partner_extension VARCHAR2(20) := FND_API.G_MISS_CHAR
115: ,created_person_id NUMBER := NULL
116: ,lead_id NUMBER := NULL
117: ,freeze_date DATE := NULL
118: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
119: ,reassign_request_date DATE := FND_API.G_MISS_DATE
120: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
121: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 119: ,reassign_request_date DATE := FND_API.G_MISS_DATE

115: ,created_person_id NUMBER := NULL
116: ,lead_id NUMBER := NULL
117: ,freeze_date DATE := NULL
118: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
119: ,reassign_request_date DATE := FND_API.G_MISS_DATE
120: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
121: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 120: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM

116: ,lead_id NUMBER := NULL
117: ,freeze_date DATE := NULL
118: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
119: ,reassign_request_date DATE := FND_API.G_MISS_DATE
120: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
121: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 121: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

117: ,freeze_date DATE := NULL
118: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
119: ,reassign_request_date DATE := FND_API.G_MISS_DATE
120: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
121: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

118: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
119: ,reassign_request_date DATE := FND_API.G_MISS_DATE
120: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
121: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

119: ,reassign_request_date DATE := FND_API.G_MISS_DATE
120: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
121: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

120: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
121: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

121: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

122: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

123: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

124: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

125: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

126: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

127: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

128: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

129: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
137: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

130: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
137: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
138: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

131: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
137: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
138: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
139: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

132: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
137: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
138: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
139: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: ,salesforce_relationship VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 137: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

133: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
137: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
138: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
139: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: ,salesforce_relationship VARCHAR2(80) := FND_API.G_MISS_CHAR
141: --

Line 138: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR

134: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
137: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
138: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
139: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: ,salesforce_relationship VARCHAR2(80) := FND_API.G_MISS_CHAR
141: --
142: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM

Line 139: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR

135: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
137: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
138: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
139: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: ,salesforce_relationship VARCHAR2(80) := FND_API.G_MISS_CHAR
141: --
142: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
143: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM

Line 140: ,salesforce_relationship VARCHAR2(80) := FND_API.G_MISS_CHAR

136: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
137: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
138: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
139: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: ,salesforce_relationship VARCHAR2(80) := FND_API.G_MISS_CHAR
141: --
142: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
143: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
144: --

Line 142: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM

138: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
139: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: ,salesforce_relationship VARCHAR2(80) := FND_API.G_MISS_CHAR
141: --
142: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
143: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
144: --
145: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
146: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR

Line 143: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM

139: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140: ,salesforce_relationship VARCHAR2(80) := FND_API.G_MISS_CHAR
141: --
142: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
143: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
144: --
145: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
146: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
147: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR

Line 145: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR

141: --
142: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
143: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
144: --
145: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
146: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
147: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
148: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
149: );

Line 146: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR

142: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
143: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
144: --
145: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
146: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
147: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
148: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
149: );
150:

Line 147: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR

143: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
144: --
145: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
146: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
147: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
148: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
149: );
150:
151: G_MISS_SALES_TEAM_REC sales_team_rec_type;

Line 148: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB

144: --
145: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
146: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
147: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
148: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
149: );
150:
151: G_MISS_SALES_TEAM_REC sales_team_rec_type;
152:

Line 210: DEFAULT FND_API.G_FALSE,

206:
207: PROCEDURE Create_SalesTeam
208: ( p_api_version_number IN NUMBER,
209: p_init_msg_list IN VARCHAR2
210: DEFAULT FND_API.G_FALSE,
211: p_commit IN VARCHAR2
212: DEFAULT FND_API.G_FALSE,
213: p_validation_level IN NUMBER
214: DEFAULT FND_API.G_VALID_LEVEL_FULL,

Line 212: DEFAULT FND_API.G_FALSE,

208: ( p_api_version_number IN NUMBER,
209: p_init_msg_list IN VARCHAR2
210: DEFAULT FND_API.G_FALSE,
211: p_commit IN VARCHAR2
212: DEFAULT FND_API.G_FALSE,
213: p_validation_level IN NUMBER
214: DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: p_access_profile_rec IN access_profile_rec_type,
216: p_check_access_flag IN VARCHAR2,

Line 214: DEFAULT FND_API.G_VALID_LEVEL_FULL,

210: DEFAULT FND_API.G_FALSE,
211: p_commit IN VARCHAR2
212: DEFAULT FND_API.G_FALSE,
213: p_validation_level IN NUMBER
214: DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: p_access_profile_rec IN access_profile_rec_type,
216: p_check_access_flag IN VARCHAR2,
217: p_admin_flag IN VARCHAR2,
218: p_admin_group_id IN NUMBER,

Line 262: DEFAULT FND_API.G_FALSE,

258:
259: PROCEDURE Update_SalesTeam
260: ( p_api_version_number IN NUMBER,
261: p_init_msg_list IN VARCHAR2
262: DEFAULT FND_API.G_FALSE,
263: p_commit IN VARCHAR2
264: DEFAULT FND_API.G_FALSE,
265: p_validation_level IN NUMBER
266: DEFAULT FND_API.G_VALID_LEVEL_FULL,

Line 264: DEFAULT FND_API.G_FALSE,

260: ( p_api_version_number IN NUMBER,
261: p_init_msg_list IN VARCHAR2
262: DEFAULT FND_API.G_FALSE,
263: p_commit IN VARCHAR2
264: DEFAULT FND_API.G_FALSE,
265: p_validation_level IN NUMBER
266: DEFAULT FND_API.G_VALID_LEVEL_FULL,
267: p_access_profile_rec IN access_profile_rec_type,
268: p_check_access_flag IN VARCHAR2,

Line 266: DEFAULT FND_API.G_VALID_LEVEL_FULL,

262: DEFAULT FND_API.G_FALSE,
263: p_commit IN VARCHAR2
264: DEFAULT FND_API.G_FALSE,
265: p_validation_level IN NUMBER
266: DEFAULT FND_API.G_VALID_LEVEL_FULL,
267: p_access_profile_rec IN access_profile_rec_type,
268: p_check_access_flag IN VARCHAR2,
269: p_admin_flag IN VARCHAR2,
270: p_admin_group_id IN NUMBER,

Line 313: DEFAULT FND_API.G_FALSE,

309:
310: PROCEDURE Delete_SalesTeam
311: ( p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2
313: DEFAULT FND_API.G_FALSE,
314: p_commit IN VARCHAR2
315: DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER
317: DEFAULT FND_API.G_VALID_LEVEL_FULL,

Line 315: DEFAULT FND_API.G_FALSE,

311: ( p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2
313: DEFAULT FND_API.G_FALSE,
314: p_commit IN VARCHAR2
315: DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER
317: DEFAULT FND_API.G_VALID_LEVEL_FULL,
318: p_access_profile_rec IN access_profile_rec_type,
319: p_check_access_flag IN VARCHAR2,

Line 317: DEFAULT FND_API.G_VALID_LEVEL_FULL,

313: DEFAULT FND_API.G_FALSE,
314: p_commit IN VARCHAR2
315: DEFAULT FND_API.G_FALSE,
316: p_validation_level IN NUMBER
317: DEFAULT FND_API.G_VALID_LEVEL_FULL,
318: p_access_profile_rec IN access_profile_rec_type,
319: p_check_access_flag IN VARCHAR2,
320: p_admin_flag IN VARCHAR2,
321: p_admin_group_id IN NUMBER,

Line 331: ( p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

327: );
328:
329:
330: Procedure validate_accessProfiles
331: ( p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
332: p_access_profile_rec IN ACCESS_PROFILE_REC_TYPE,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2

Line 347: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

343: otherwise return 'N'. */
344:
345: procedure has_viewCustomerAccess
346: ( p_api_version_number IN NUMBER
347: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
348: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
349: ,p_access_profile_rec IN access_profile_rec_type
350: ,p_admin_flag IN VARCHAR2
351: ,p_admin_group_id IN NUMBER

Line 348: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

344:
345: procedure has_viewCustomerAccess
346: ( p_api_version_number IN NUMBER
347: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
348: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
349: ,p_access_profile_rec IN access_profile_rec_type
350: ,p_admin_flag IN VARCHAR2
351: ,p_admin_group_id IN NUMBER
352: ,p_person_id IN NUMBER

Line 365: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

361: );
362:
363: procedure has_updateCustomerAccess
364: ( p_api_version_number IN NUMBER
365: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
366: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
367: ,p_access_profile_rec IN access_profile_rec_type
368: ,p_admin_flag IN VARCHAR2
369: ,p_admin_group_id IN NUMBER

Line 366: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

362:
363: procedure has_updateCustomerAccess
364: ( p_api_version_number IN NUMBER
365: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
366: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
367: ,p_access_profile_rec IN access_profile_rec_type
368: ,p_admin_flag IN VARCHAR2
369: ,p_admin_group_id IN NUMBER
370: ,p_person_id IN NUMBER

Line 383: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

379: );
380:
381: procedure has_updateLeadAccess
382: ( p_api_version_number IN NUMBER
383: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
384: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
385: ,p_access_profile_rec IN access_profile_rec_type
386: ,p_admin_flag IN VARCHAR2
387: ,p_admin_group_id IN NUMBER

Line 384: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

380:
381: procedure has_updateLeadAccess
382: ( p_api_version_number IN NUMBER
383: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
384: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
385: ,p_access_profile_rec IN access_profile_rec_type
386: ,p_admin_flag IN VARCHAR2
387: ,p_admin_group_id IN NUMBER
388: ,p_person_id IN NUMBER

Line 401: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

397: );
398:
399: procedure has_updateOpportunityAccess
400: ( p_api_version_number IN NUMBER
401: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
402: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
403: ,p_access_profile_rec IN access_profile_rec_type
404: ,p_admin_flag IN VARCHAR2
405: ,p_admin_group_id IN NUMBER

Line 402: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

398:
399: procedure has_updateOpportunityAccess
400: ( p_api_version_number IN NUMBER
401: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
402: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
403: ,p_access_profile_rec IN access_profile_rec_type
404: ,p_admin_flag IN VARCHAR2
405: ,p_admin_group_id IN NUMBER
406: ,p_person_id IN NUMBER

Line 423: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

419: update access. To check consumer access, you can pass in null for
420: p_security_id and p_security_type */
421: procedure has_updatePersonAccess
422: ( p_api_version_number IN NUMBER
423: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
424: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
425: ,p_access_profile_rec IN access_profile_rec_type
426: ,p_admin_flag IN VARCHAR2
427: ,p_admin_group_id IN NUMBER

Line 424: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

420: p_security_id and p_security_type */
421: procedure has_updatePersonAccess
422: ( p_api_version_number IN NUMBER
423: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
424: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
425: ,p_access_profile_rec IN access_profile_rec_type
426: ,p_admin_flag IN VARCHAR2
427: ,p_admin_group_id IN NUMBER
428: ,p_person_id IN NUMBER

Line 443: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

439: );
440:
441: procedure has_viewPersonAccess
442: ( p_api_version_number IN NUMBER
443: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
444: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
445: ,p_access_profile_rec IN access_profile_rec_type
446: ,p_admin_flag IN VARCHAR2
447: ,p_admin_group_id IN NUMBER

Line 444: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

440:
441: procedure has_viewPersonAccess
442: ( p_api_version_number IN NUMBER
443: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
444: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
445: ,p_access_profile_rec IN access_profile_rec_type
446: ,p_admin_flag IN VARCHAR2
447: ,p_admin_group_id IN NUMBER
448: ,p_person_id IN NUMBER

Line 462: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

458: ,x_view_access_flag OUT NOCOPY VARCHAR2
459: );
460: procedure has_viewLeadAccess
461: ( p_api_version_number IN NUMBER
462: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
463: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
464: ,p_access_profile_rec IN access_profile_rec_type
465: ,p_admin_flag IN VARCHAR2
466: ,p_admin_group_id IN NUMBER

Line 463: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

459: );
460: procedure has_viewLeadAccess
461: ( p_api_version_number IN NUMBER
462: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
463: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
464: ,p_access_profile_rec IN access_profile_rec_type
465: ,p_admin_flag IN VARCHAR2
466: ,p_admin_group_id IN NUMBER
467: ,p_person_id IN NUMBER

Line 480: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

476: );
477:
478: procedure has_viewOpportunityAccess
479: ( p_api_version_number IN NUMBER
480: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
481: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
482: ,p_access_profile_rec IN access_profile_rec_type
483: ,p_admin_flag IN VARCHAR2
484: ,p_admin_group_id IN NUMBER

Line 481: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

477:
478: procedure has_viewOpportunityAccess
479: ( p_api_version_number IN NUMBER
480: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
481: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
482: ,p_access_profile_rec IN access_profile_rec_type
483: ,p_admin_flag IN VARCHAR2
484: ,p_admin_group_id IN NUMBER
485: ,p_person_id IN NUMBER

Line 504: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

500: */
501:
502: procedure has_organizationAccess
503: ( p_api_version_number IN NUMBER
504: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
505: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
506: ,p_access_profile_rec IN access_profile_rec_type
507: ,p_admin_flag IN VARCHAR2
508: ,p_admin_group_id IN NUMBER

Line 505: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

501:
502: procedure has_organizationAccess
503: ( p_api_version_number IN NUMBER
504: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
505: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
506: ,p_access_profile_rec IN access_profile_rec_type
507: ,p_admin_flag IN VARCHAR2
508: ,p_admin_group_id IN NUMBER
509: ,p_person_id IN NUMBER

Line 531: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

527: three values: 'N'(no access), 'R'(read only access) and 'F'(read/update access)
528: */
529: procedure has_personAccess
530: ( p_api_version_number IN NUMBER
531: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
532: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
533: ,p_access_profile_rec IN access_profile_rec_type
534: ,p_admin_flag IN VARCHAR2
535: ,p_admin_group_id IN NUMBER

Line 532: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

528: */
529: procedure has_personAccess
530: ( p_api_version_number IN NUMBER
531: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
532: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
533: ,p_access_profile_rec IN access_profile_rec_type
534: ,p_admin_flag IN VARCHAR2
535: ,p_admin_group_id IN NUMBER
536: ,p_person_id IN NUMBER

Line 556: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

552: three values: 'N'(no access), 'R'(read only access) and 'F'(read/update access)
553: */
554: procedure has_leadAccess
555: ( p_api_version_number IN NUMBER
556: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
557: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
558: ,p_access_profile_rec IN access_profile_rec_type
559: ,p_admin_flag IN VARCHAR2
560: ,p_admin_group_id IN NUMBER

Line 557: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

553: */
554: procedure has_leadAccess
555: ( p_api_version_number IN NUMBER
556: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
557: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
558: ,p_access_profile_rec IN access_profile_rec_type
559: ,p_admin_flag IN VARCHAR2
560: ,p_admin_group_id IN NUMBER
561: ,p_person_id IN NUMBER

Line 578: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

574: three values: 'N'(no access), 'R'(read only access) and 'F'(read/update access)
575: */
576: procedure has_opportunityAccess
577: ( p_api_version_number IN NUMBER
578: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
579: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
580: ,p_access_profile_rec IN access_profile_rec_type
581: ,p_admin_flag IN VARCHAR2
582: ,p_admin_group_id IN NUMBER

Line 579: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

575: */
576: procedure has_opportunityAccess
577: ( p_api_version_number IN NUMBER
578: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
579: ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
580: ,p_access_profile_rec IN access_profile_rec_type
581: ,p_admin_flag IN VARCHAR2
582: ,p_admin_group_id IN NUMBER
583: ,p_person_id IN NUMBER