APPS.AS_SALES_ORG_MANAGER_PVT dependencies on AS_SALES_MEMBER_PUB

Line 168: Function get_salesmem_gen_where(p_sales_member_rec IN AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type)

164: return l_select_cl;
165:
166: End get_salesmem_gen_select_w_grp;
167:
168: Function get_salesmem_gen_where(p_sales_member_rec IN AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type)
169: return Varchar2 IS
170:
171: l_where_cl Varchar2(1000);
172:

Line 236: Function get_salesmem_gen_where_w_grp(p_sales_member_rec IN AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type)

232: return l_where_cl;
233:
234: End get_salesmem_gen_where;
235:
236: Function get_salesmem_gen_where_w_grp(p_sales_member_rec IN AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type)
237: return Varchar2 IS
238:
239: l_where_cl Varchar2(1000);
240:

Line 300: l_sales_member_rec AS_sales_member_PUB.sales_member_Rec_Type;

296: End get_salesmem_gen_where_w_grp;
297:
298: Procedure get_salesmem_define_cols(p_cur_get_salesmember IN Number) IS
299:
300: l_sales_member_rec AS_sales_member_PUB.sales_member_Rec_Type;
301:
302: Begin
303:
304: dbms_sql.define_column(p_cur_get_salesmember, 1, l_sales_member_rec.salesforce_id);

Line 324: p_sales_member_rec IN AS_sales_member_PUB.sales_member_Rec_Type) IS

320: dbms_sql.define_column(p_cur_get_salesmember, 16, l_sales_member_rec.managing_sales_grp_name, 60);
321: End get_salesmem_define_cols;
322:
323: Procedure get_salesmem_bind_vars(p_cur_get_salesmember IN Number,
324: p_sales_member_rec IN AS_sales_member_PUB.sales_member_Rec_Type) IS
325:
326: Begin
327: If (p_sales_member_rec.user_id <> FND_API.G_MISS_NUM) Then
328: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_user_id',

Line 381: x_sales_member_rec OUT NOCOPY AS_sales_member_PUB.sales_member_Rec_Type) IS

377:
378: End get_salesmem_bind_vars;
379:
380: Procedure get_salesmem_column_values(p_cur_get_salesmember IN Number,
381: x_sales_member_rec OUT NOCOPY AS_sales_member_PUB.sales_member_Rec_Type) IS
382:
383: Begin
384:
385: dbms_sql.column_value(p_cur_get_salesmember, 1, x_sales_member_rec.salesforce_id);

Line 670: x_sales_member_rec OUT NOCOPY AS_SALES_MEMBER_PUB.Sales_member_rec_Type ) IS

666: p_admin_group_id IN NUMBER,
667: x_return_status OUT NOCOPY VARCHAR2,
668: x_msg_count OUT NOCOPY NUMBER,
669: x_msg_data OUT NOCOPY VARCHAR2,
670: x_sales_member_rec OUT NOCOPY AS_SALES_MEMBER_PUB.Sales_member_rec_Type ) IS
671:
672:
673: Cursor C_GetIdentity_FndUser(p_user_id Number) IS
674: Select force.resource_id,

Line 941: p_sales_member_rec IN AS_SALES_MEMBER_PUB.Sales_member_rec_Type,

937: PROCEDURE Get_Sales_members
938: ( p_api_version_number IN NUMBER,
939: p_init_msg_list IN VARCHAR2
940: := FND_API.G_FALSE,
941: p_sales_member_rec IN AS_SALES_MEMBER_PUB.Sales_member_rec_Type,
942: x_return_status OUT NOCOPY VARCHAR2,
943: x_msg_count OUT NOCOPY NUMBER,
944: x_msg_data OUT NOCOPY VARCHAR2,
945: x_sales_member_tbl OUT NOCOPY AS_SALES_MEMBER_PUB.Sales_member_tbl_Type ) IS

Line 945: x_sales_member_tbl OUT NOCOPY AS_SALES_MEMBER_PUB.Sales_member_tbl_Type ) IS

941: p_sales_member_rec IN AS_SALES_MEMBER_PUB.Sales_member_rec_Type,
942: x_return_status OUT NOCOPY VARCHAR2,
943: x_msg_count OUT NOCOPY NUMBER,
944: x_msg_data OUT NOCOPY VARCHAR2,
945: x_sales_member_tbl OUT NOCOPY AS_SALES_MEMBER_PUB.Sales_member_tbl_Type ) IS
946:
947: l_api_name CONSTANT VARCHAR2(30) := 'Get_Sales_members';
948: l_api_version_number CONSTANT NUMBER := 2.0;
949:

Line 950: l_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_type;

946:
947: l_api_name CONSTANT VARCHAR2(30) := 'Get_Sales_members';
948: l_api_version_number CONSTANT NUMBER := 2.0;
949:
950: l_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_type;
951: l_rec_count Number := 1;
952:
953: Cursor C_GetGroupExist(p_salesforce_id NUMBER) IS
954: select 1