APPS.AS_SALES_ORG_MANAGER_PVT dependencies on AS_SALES_GROUP_PUB

Line 35: Function get_sales_group_gen_where(p_sales_group_rec IN AS_SALES_GROUP_PUB.Sales_Group_Rec_Type)

31:
32:
33: End get_sales_group_gen_select;
34:
35: Function get_sales_group_gen_where(p_sales_group_rec IN AS_SALES_GROUP_PUB.Sales_Group_Rec_Type)
36: return Varchar2 IS
37:
38: l_where_cl Varchar2(1000);
39:

Line 68: l_sales_group_rec AS_SALES_GROUP_PUB.Sales_Group_Rec_Type;

64: End get_sales_group_gen_where;
65:
66: Procedure get_sales_group_define_columns(p_cur_get_salesgroup IN Number) IS
67:
68: l_sales_group_rec AS_SALES_GROUP_PUB.Sales_Group_Rec_Type;
69:
70: Begin
71:
72: dbms_sql.define_column(p_cur_get_salesgroup, 1, l_sales_group_rec.sales_group_id);

Line 85: p_sales_group_rec IN AS_SALES_GROUP_PUB.Sales_Group_Rec_Type) IS

81:
82: End get_sales_group_define_columns;
83:
84: Procedure get_sales_group_bind_variables(p_cur_get_salesgroup IN Number,
85: p_sales_group_rec IN AS_SALES_GROUP_PUB.Sales_Group_Rec_Type) IS
86:
87: Begin
88: If (p_sales_group_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
89: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_sales_group_id',

Line 115: x_sales_group_rec OUT NOCOPY AS_SALES_GROUP_PUB.Sales_Group_Rec_Type) IS

111: End if;
112: End get_sales_group_bind_variables;
113:
114: Procedure get_sales_group_column_values(p_cur_get_salesgroup IN Number,
115: x_sales_group_rec OUT NOCOPY AS_SALES_GROUP_PUB.Sales_Group_Rec_Type) IS
116:
117: Begin
118:
119: dbms_sql.column_value(p_cur_get_salesgroup, 1, x_sales_group_rec.sales_group_id);

Line 425: p_SALES_GROUP_rec IN AS_SALES_GROUP_PUB.SALES_GROUP_rec_Type,

421: --
422: PROCEDURE Get_Sales_groups
423: ( p_api_version_number IN NUMBER,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
425: p_SALES_GROUP_rec IN AS_SALES_GROUP_PUB.SALES_GROUP_rec_Type,
426: x_return_status OUT NOCOPY VARCHAR2,
427: x_msg_count OUT NOCOPY NUMBER,
428: x_msg_data OUT NOCOPY VARCHAR2,
429: x_SALES_GROUP_tbl OUT NOCOPY AS_SALES_GROUP_PUB.SALES_GROUP_tbl_Type ) IS

Line 429: x_SALES_GROUP_tbl OUT NOCOPY AS_SALES_GROUP_PUB.SALES_GROUP_tbl_Type ) IS

425: p_SALES_GROUP_rec IN AS_SALES_GROUP_PUB.SALES_GROUP_rec_Type,
426: x_return_status OUT NOCOPY VARCHAR2,
427: x_msg_count OUT NOCOPY NUMBER,
428: x_msg_data OUT NOCOPY VARCHAR2,
429: x_SALES_GROUP_tbl OUT NOCOPY AS_SALES_GROUP_PUB.SALES_GROUP_tbl_Type ) IS
430:
431:
432: l_api_name CONSTANT VARCHAR2(30) := 'Get_Sales_groups';
433: l_api_version_number CONSTANT NUMBER := 2.0;

Line 435: l_SALES_GROUP_rec AS_SALES_GROUP_PUB.SALES_GROUP_rec_type;

431:
432: l_api_name CONSTANT VARCHAR2(30) := 'Get_Sales_groups';
433: l_api_version_number CONSTANT NUMBER := 2.0;
434:
435: l_SALES_GROUP_rec AS_SALES_GROUP_PUB.SALES_GROUP_rec_type;
436: l_rec_count Number := 0;
437: l_select_cl Varchar2(500);
438: l_where_cl Varchar2(1000);
439: l_cur_get_salesgroup Number;