APPS.AS_ACCESS_PVT dependencies on FND_API

Line 88: ,last_update_date DATE := FND_API.G_MISS_DATE

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

Line 89: ,last_updated_by NUMBER := FND_API.G_MISS_NUM

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

Line 90: ,creation_date DATE := FND_API.G_MISS_DATE

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

Line 91: ,created_by NUMBER := FND_API.G_MISS_NUM

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

Line 92: ,last_update_login NUMBER := FND_API.G_MISS_NUM

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

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

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

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

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

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

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

Line 104: ,freeze_date DATE := FND_API.G_MISS_DATE

100: ,partner_customer_id NUMBER := NULL
101: ,partner_address_id NUMBER := NULL
102: ,created_person_id NUMBER := NULL
103: ,lead_id NUMBER := NULL
104: ,freeze_date DATE := FND_API.G_MISS_DATE
105: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
106: ,reassign_request_date DATE := FND_API.G_MISS_DATE
107: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
108: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

101: ,partner_address_id NUMBER := NULL
102: ,created_person_id NUMBER := NULL
103: ,lead_id NUMBER := NULL
104: ,freeze_date DATE := FND_API.G_MISS_DATE
105: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
106: ,reassign_request_date DATE := FND_API.G_MISS_DATE
107: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
108: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
109: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 106: ,reassign_request_date DATE := FND_API.G_MISS_DATE

102: ,created_person_id NUMBER := NULL
103: ,lead_id NUMBER := NULL
104: ,freeze_date DATE := FND_API.G_MISS_DATE
105: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
106: ,reassign_request_date DATE := FND_API.G_MISS_DATE
107: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
108: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
109: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
110: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 107: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM

103: ,lead_id NUMBER := NULL
104: ,freeze_date DATE := FND_API.G_MISS_DATE
105: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
106: ,reassign_request_date DATE := FND_API.G_MISS_DATE
107: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
108: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
109: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
110: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
111: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

104: ,freeze_date DATE := FND_API.G_MISS_DATE
105: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
106: ,reassign_request_date DATE := FND_API.G_MISS_DATE
107: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
108: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
109: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
110: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
111: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

105: ,reassign_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
106: ,reassign_request_date DATE := FND_API.G_MISS_DATE
107: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
108: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
109: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
110: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
111: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

106: ,reassign_request_date DATE := FND_API.G_MISS_DATE
107: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
108: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
109: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
110: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
111: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

107: ,reassign_requested_person_id NUMBER := FND_API.G_MISS_NUM
108: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
109: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
110: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
111: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

108: ,downloadable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
109: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
110: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
111: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

109: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
110: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
111: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

110: ,attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
111: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

111: ,attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

112: ,attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

113: ,attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

114: ,attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

115: ,attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

116: ,attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

117: ,attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

118: ,attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
126: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

119: ,attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
126: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM

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

120: ,attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
126: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM

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

121: ,attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
126: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM

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

122: ,attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
126: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
130: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR

Line 127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM

123: ,attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
126: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
130: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
131: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR

Line 128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM

124: ,attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
126: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
130: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
131: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
132: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR

Line 129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM

125: ,salesforce_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR
126: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
130: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
131: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
132: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
133: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB

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

126: ,salesforce_relationship_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
130: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
131: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
132: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
133: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
134: );

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

127: ,sales_lead_id NUMBER := FND_API.G_MISS_NUM
128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
130: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
131: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
132: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
133: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
134: );
135:

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

128: ,sales_group_id NUMBER := FND_API.G_MISS_NUM
129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
130: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
131: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
132: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
133: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
134: );
135:
136: G_MISS_SALES_TEAM_REC sales_team_rec_type;

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

129: ,partner_cont_party_id NUMBER := FND_API.G_MISS_NUM
130: ,owner_flag varchar2(1) := FND_API.G_MISS_CHAR
131: ,created_by_tap_flag varchar2(1) := FND_API.G_MISS_CHAR
132: ,prm_keep_flag varchar2(1) := FND_API.G_MISS_CHAR
133: ,contributor_flag varchar2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
134: );
135:
136: G_MISS_SALES_TEAM_REC sales_team_rec_type;
137:

Line 184: := FND_API.G_FALSE,

180:
181: PROCEDURE Create_SalesTeam
182: ( p_api_version_number IN NUMBER,
183: p_init_msg_list IN VARCHAR2
184: := FND_API.G_FALSE,
185: p_commit IN VARCHAR2
186: := FND_API.G_FALSE,
187: p_validation_level IN NUMBER
188: := FND_API.G_VALID_LEVEL_FULL,

Line 186: := FND_API.G_FALSE,

182: ( p_api_version_number IN NUMBER,
183: p_init_msg_list IN VARCHAR2
184: := FND_API.G_FALSE,
185: p_commit IN VARCHAR2
186: := FND_API.G_FALSE,
187: p_validation_level IN NUMBER
188: := FND_API.G_VALID_LEVEL_FULL,
189: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
190: p_check_access_flag IN VARCHAR2,

Line 188: := FND_API.G_VALID_LEVEL_FULL,

184: := FND_API.G_FALSE,
185: p_commit IN VARCHAR2
186: := FND_API.G_FALSE,
187: p_validation_level IN NUMBER
188: := FND_API.G_VALID_LEVEL_FULL,
189: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
190: p_check_access_flag IN VARCHAR2,
191: p_admin_flag IN VARCHAR2,
192: p_admin_group_id IN NUMBER,

Line 235: := FND_API.G_FALSE,

231:
232: PROCEDURE Delete_SalesTeam
233: ( p_api_version_number IN NUMBER,
234: p_init_msg_list IN VARCHAR2
235: := FND_API.G_FALSE,
236: p_commit IN VARCHAR2
237: := FND_API.G_FALSE,
238: p_validation_level IN NUMBER
239: := FND_API.G_VALID_LEVEL_FULL,

Line 237: := FND_API.G_FALSE,

233: ( p_api_version_number IN NUMBER,
234: p_init_msg_list IN VARCHAR2
235: := FND_API.G_FALSE,
236: p_commit IN VARCHAR2
237: := FND_API.G_FALSE,
238: p_validation_level IN NUMBER
239: := FND_API.G_VALID_LEVEL_FULL,
240: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
241: p_check_access_flag IN VARCHAR2,

Line 239: := FND_API.G_VALID_LEVEL_FULL,

235: := FND_API.G_FALSE,
236: p_commit IN VARCHAR2
237: := FND_API.G_FALSE,
238: p_validation_level IN NUMBER
239: := FND_API.G_VALID_LEVEL_FULL,
240: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
241: p_check_access_flag IN VARCHAR2,
242: p_admin_flag IN VARCHAR2,
243: p_admin_group_id IN NUMBER,

Line 285: := FND_API.G_FALSE,

281:
282: PROCEDURE Update_SalesTeam
283: ( p_api_version_number IN NUMBER,
284: p_init_msg_list IN VARCHAR2
285: := FND_API.G_FALSE,
286: p_commit IN VARCHAR2
287: := FND_API.G_FALSE,
288: p_validation_level IN NUMBER
289: := FND_API.G_VALID_LEVEL_FULL,

Line 287: := FND_API.G_FALSE,

283: ( p_api_version_number IN NUMBER,
284: p_init_msg_list IN VARCHAR2
285: := FND_API.G_FALSE,
286: p_commit IN VARCHAR2
287: := FND_API.G_FALSE,
288: p_validation_level IN NUMBER
289: := FND_API.G_VALID_LEVEL_FULL,
290: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
291: p_check_access_flag IN VARCHAR2,

Line 289: := FND_API.G_VALID_LEVEL_FULL,

285: := FND_API.G_FALSE,
286: p_commit IN VARCHAR2
287: := FND_API.G_FALSE,
288: p_validation_level IN NUMBER
289: := FND_API.G_VALID_LEVEL_FULL,
290: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
291: p_check_access_flag IN VARCHAR2,
292: p_admin_flag IN VARCHAR2,
293: p_admin_group_id IN NUMBER,

Line 334: := FND_API.G_FALSE,

330:
331: PROCEDURE Validate_SalesTeamItems
332: ( p_api_version_number IN NUMBER,
333: p_init_msg_list IN VARCHAR2
334: := FND_API.G_FALSE,
335: p_validation_level IN NUMBER
336: := FND_API.G_VALID_LEVEL_FULL,
337: p_sales_team_rec IN SALES_TEAM_REC_TYPE,
338: x_return_status OUT NOCOPY VARCHAR2,

Line 336: := FND_API.G_VALID_LEVEL_FULL,

332: ( p_api_version_number IN NUMBER,
333: p_init_msg_list IN VARCHAR2
334: := FND_API.G_FALSE,
335: p_validation_level IN NUMBER
336: := FND_API.G_VALID_LEVEL_FULL,
337: p_sales_team_rec IN SALES_TEAM_REC_TYPE,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2

Line 359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

355: -- x_view_access_flag = 'Y', otherwise return 'N'.
356:
357: procedure has_viewCustomerAccess
358: ( p_api_version_number IN NUMBER
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
360: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
361: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
362: ,p_admin_flag IN VARCHAR2
363: ,p_admin_group_id IN NUMBER

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

356:
357: procedure has_viewCustomerAccess
358: ( p_api_version_number IN NUMBER
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
360: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
361: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
362: ,p_admin_flag IN VARCHAR2
363: ,p_admin_group_id IN NUMBER
364: ,p_person_id IN NUMBER

Line 388: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

384: -- A user can also update all addresses of the customer.
385:
386: procedure has_updateCustomerAccess
387: ( p_api_version_number IN NUMBER
388: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
389: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
390: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
391: ,p_admin_flag IN VARCHAR2
392: ,p_admin_group_id IN NUMBER

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

385:
386: procedure has_updateCustomerAccess
387: ( p_api_version_number IN NUMBER
388: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
389: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
390: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
391: ,p_admin_flag IN VARCHAR2
392: ,p_admin_group_id IN NUMBER
393: ,p_person_id IN NUMBER

Line 414: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

410: --
411:
412: procedure has_updateLeadAccess
413: ( p_api_version_number IN NUMBER
414: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
415: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
416: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
417: ,p_admin_flag IN VARCHAR2
418: ,p_admin_group_id IN NUMBER

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

411:
412: procedure has_updateLeadAccess
413: ( p_api_version_number IN NUMBER
414: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
415: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
416: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
417: ,p_admin_flag IN VARCHAR2
418: ,p_admin_group_id IN NUMBER
419: ,p_person_id IN NUMBER

Line 441: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

437: -- value. If user has update access, x_update_ access_flag = 'Y'.
438:
439: procedure has_updateOpportunityAccess
440: ( p_api_version_number IN NUMBER
441: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
442: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
443: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
444: ,p_admin_flag IN VARCHAR2
445: ,p_admin_group_id IN NUMBER

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

438:
439: procedure has_updateOpportunityAccess
440: ( p_api_version_number IN NUMBER
441: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
442: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
443: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
444: ,p_admin_flag IN VARCHAR2
445: ,p_admin_group_id IN NUMBER
446: ,p_person_id IN NUMBER

Line 459: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

455: );
456:
457: procedure has_leadOwnerAccess
458: ( p_api_version_number IN NUMBER
459: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
460: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
461: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
462: ,p_admin_flag IN VARCHAR2
463: ,p_admin_group_id IN NUMBER

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

456:
457: procedure has_leadOwnerAccess
458: ( p_api_version_number IN NUMBER
459: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
460: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
461: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
462: ,p_admin_flag IN VARCHAR2
463: ,p_admin_group_id IN NUMBER
464: ,p_person_id IN NUMBER

Line 478: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

474:
475:
476: procedure has_oppOwnerAccess
477: ( p_api_version_number IN NUMBER
478: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
479: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
480: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
481: ,p_admin_flag IN VARCHAR2
482: ,p_admin_group_id IN NUMBER

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

475:
476: procedure has_oppOwnerAccess
477: ( p_api_version_number IN NUMBER
478: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
479: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
480: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
481: ,p_admin_flag IN VARCHAR2
482: ,p_admin_group_id IN NUMBER
483: ,p_person_id IN NUMBER

Line 497: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

493:
494:
495: procedure has_viewLeadAccess
496: ( p_api_version_number IN NUMBER
497: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
498: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
499: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
500: ,p_admin_flag IN VARCHAR2
501: ,p_admin_group_id IN NUMBER

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

494:
495: procedure has_viewLeadAccess
496: ( p_api_version_number IN NUMBER
497: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
498: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
499: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
500: ,p_admin_flag IN VARCHAR2
501: ,p_admin_group_id IN NUMBER
502: ,p_person_id IN NUMBER

Line 515: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

511: );
512:
513: procedure has_viewOpportunityAccess
514: ( p_api_version_number IN NUMBER
515: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
516: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
517: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
518: ,p_admin_flag IN VARCHAR2
519: ,p_admin_group_id IN NUMBER

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

512:
513: procedure has_viewOpportunityAccess
514: ( p_api_version_number IN NUMBER
515: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
516: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
517: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
518: ,p_admin_flag IN VARCHAR2
519: ,p_admin_group_id IN NUMBER
520: ,p_person_id IN NUMBER