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.AS_SALES_ORG_MANAGER_PVT dependencies on DBMS_SQL

Line 72: dbms_sql.define_column(p_cur_get_salesgroup, 1, l_sales_group_rec.sales_group_id);

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);
73: dbms_sql.define_column(p_cur_get_salesgroup, 2, l_sales_group_rec.name, 60);
74: dbms_sql.define_column(p_cur_get_salesgroup, 3, l_sales_group_rec.start_date_active);
75: dbms_sql.define_column(p_cur_get_salesgroup, 4, l_sales_group_rec.end_date_active);
76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);

Line 73: dbms_sql.define_column(p_cur_get_salesgroup, 2, l_sales_group_rec.name, 60);

69:
70: Begin
71:
72: dbms_sql.define_column(p_cur_get_salesgroup, 1, l_sales_group_rec.sales_group_id);
73: dbms_sql.define_column(p_cur_get_salesgroup, 2, l_sales_group_rec.name, 60);
74: dbms_sql.define_column(p_cur_get_salesgroup, 3, l_sales_group_rec.start_date_active);
75: dbms_sql.define_column(p_cur_get_salesgroup, 4, l_sales_group_rec.end_date_active);
76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);
77: dbms_sql.define_column(p_cur_get_salesgroup, 6, l_sales_group_rec.parent_sales_group_id);

Line 74: dbms_sql.define_column(p_cur_get_salesgroup, 3, l_sales_group_rec.start_date_active);

70: Begin
71:
72: dbms_sql.define_column(p_cur_get_salesgroup, 1, l_sales_group_rec.sales_group_id);
73: dbms_sql.define_column(p_cur_get_salesgroup, 2, l_sales_group_rec.name, 60);
74: dbms_sql.define_column(p_cur_get_salesgroup, 3, l_sales_group_rec.start_date_active);
75: dbms_sql.define_column(p_cur_get_salesgroup, 4, l_sales_group_rec.end_date_active);
76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);
77: dbms_sql.define_column(p_cur_get_salesgroup, 6, l_sales_group_rec.parent_sales_group_id);
78: dbms_sql.define_column(p_cur_get_salesgroup, 7, l_sales_group_rec.manager_person_id);

Line 75: dbms_sql.define_column(p_cur_get_salesgroup, 4, l_sales_group_rec.end_date_active);

71:
72: dbms_sql.define_column(p_cur_get_salesgroup, 1, l_sales_group_rec.sales_group_id);
73: dbms_sql.define_column(p_cur_get_salesgroup, 2, l_sales_group_rec.name, 60);
74: dbms_sql.define_column(p_cur_get_salesgroup, 3, l_sales_group_rec.start_date_active);
75: dbms_sql.define_column(p_cur_get_salesgroup, 4, l_sales_group_rec.end_date_active);
76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);
77: dbms_sql.define_column(p_cur_get_salesgroup, 6, l_sales_group_rec.parent_sales_group_id);
78: dbms_sql.define_column(p_cur_get_salesgroup, 7, l_sales_group_rec.manager_person_id);
79: dbms_sql.define_column(p_cur_get_salesgroup, 8, l_sales_group_rec.manager_salesforce_id);

Line 76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);

72: dbms_sql.define_column(p_cur_get_salesgroup, 1, l_sales_group_rec.sales_group_id);
73: dbms_sql.define_column(p_cur_get_salesgroup, 2, l_sales_group_rec.name, 60);
74: dbms_sql.define_column(p_cur_get_salesgroup, 3, l_sales_group_rec.start_date_active);
75: dbms_sql.define_column(p_cur_get_salesgroup, 4, l_sales_group_rec.end_date_active);
76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);
77: dbms_sql.define_column(p_cur_get_salesgroup, 6, l_sales_group_rec.parent_sales_group_id);
78: dbms_sql.define_column(p_cur_get_salesgroup, 7, l_sales_group_rec.manager_person_id);
79: dbms_sql.define_column(p_cur_get_salesgroup, 8, l_sales_group_rec.manager_salesforce_id);
80: dbms_sql.define_column(p_cur_get_salesgroup, 9, l_sales_group_rec.accounting_code, 80);

Line 77: dbms_sql.define_column(p_cur_get_salesgroup, 6, l_sales_group_rec.parent_sales_group_id);

73: dbms_sql.define_column(p_cur_get_salesgroup, 2, l_sales_group_rec.name, 60);
74: dbms_sql.define_column(p_cur_get_salesgroup, 3, l_sales_group_rec.start_date_active);
75: dbms_sql.define_column(p_cur_get_salesgroup, 4, l_sales_group_rec.end_date_active);
76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);
77: dbms_sql.define_column(p_cur_get_salesgroup, 6, l_sales_group_rec.parent_sales_group_id);
78: dbms_sql.define_column(p_cur_get_salesgroup, 7, l_sales_group_rec.manager_person_id);
79: dbms_sql.define_column(p_cur_get_salesgroup, 8, l_sales_group_rec.manager_salesforce_id);
80: dbms_sql.define_column(p_cur_get_salesgroup, 9, l_sales_group_rec.accounting_code, 80);
81:

Line 78: dbms_sql.define_column(p_cur_get_salesgroup, 7, l_sales_group_rec.manager_person_id);

74: dbms_sql.define_column(p_cur_get_salesgroup, 3, l_sales_group_rec.start_date_active);
75: dbms_sql.define_column(p_cur_get_salesgroup, 4, l_sales_group_rec.end_date_active);
76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);
77: dbms_sql.define_column(p_cur_get_salesgroup, 6, l_sales_group_rec.parent_sales_group_id);
78: dbms_sql.define_column(p_cur_get_salesgroup, 7, l_sales_group_rec.manager_person_id);
79: dbms_sql.define_column(p_cur_get_salesgroup, 8, l_sales_group_rec.manager_salesforce_id);
80: dbms_sql.define_column(p_cur_get_salesgroup, 9, l_sales_group_rec.accounting_code, 80);
81:
82: End get_sales_group_define_columns;

Line 79: dbms_sql.define_column(p_cur_get_salesgroup, 8, l_sales_group_rec.manager_salesforce_id);

75: dbms_sql.define_column(p_cur_get_salesgroup, 4, l_sales_group_rec.end_date_active);
76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);
77: dbms_sql.define_column(p_cur_get_salesgroup, 6, l_sales_group_rec.parent_sales_group_id);
78: dbms_sql.define_column(p_cur_get_salesgroup, 7, l_sales_group_rec.manager_person_id);
79: dbms_sql.define_column(p_cur_get_salesgroup, 8, l_sales_group_rec.manager_salesforce_id);
80: dbms_sql.define_column(p_cur_get_salesgroup, 9, l_sales_group_rec.accounting_code, 80);
81:
82: End get_sales_group_define_columns;
83:

Line 80: dbms_sql.define_column(p_cur_get_salesgroup, 9, l_sales_group_rec.accounting_code, 80);

76: dbms_sql.define_column(p_cur_get_salesgroup, 5, l_sales_group_rec.description, 240);
77: dbms_sql.define_column(p_cur_get_salesgroup, 6, l_sales_group_rec.parent_sales_group_id);
78: dbms_sql.define_column(p_cur_get_salesgroup, 7, l_sales_group_rec.manager_person_id);
79: dbms_sql.define_column(p_cur_get_salesgroup, 8, l_sales_group_rec.manager_salesforce_id);
80: dbms_sql.define_column(p_cur_get_salesgroup, 9, l_sales_group_rec.accounting_code, 80);
81:
82: End get_sales_group_define_columns;
83:
84: Procedure get_sales_group_bind_variables(p_cur_get_salesgroup IN Number,

Line 89: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_sales_group_id',

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',
90: p_sales_group_rec.sales_group_id);
91: End if;
92:
93: If (p_sales_group_rec.name <> FND_API.G_MISS_CHAR) Then

Line 94: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_name',

90: p_sales_group_rec.sales_group_id);
91: End if;
92:
93: If (p_sales_group_rec.name <> FND_API.G_MISS_CHAR) Then
94: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_name',
95: p_sales_group_rec.name);
96: End if;
97:
98: If (p_sales_group_rec.parent_sales_group_id <> FND_API.G_MISS_NUM) Then

Line 99: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_parent_sales_group_id',

95: p_sales_group_rec.name);
96: End if;
97:
98: If (p_sales_group_rec.parent_sales_group_id <> FND_API.G_MISS_NUM) Then
99: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_parent_sales_group_id',
100: p_sales_group_rec.parent_sales_group_id);
101: End if;
102:
103: If (p_sales_group_rec.manager_person_id <> FND_API.G_MISS_NUM) Then

Line 104: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_manager_person_id',

100: p_sales_group_rec.parent_sales_group_id);
101: End if;
102:
103: If (p_sales_group_rec.manager_person_id <> FND_API.G_MISS_NUM) Then
104: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_manager_person_id',
105: p_sales_group_rec.manager_person_id);
106: End if;
107:
108: If (p_sales_group_rec.manager_salesforce_id <> FND_API.G_MISS_NUM) Then

Line 109: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_manager_salesforce_id',

105: p_sales_group_rec.manager_person_id);
106: End if;
107:
108: If (p_sales_group_rec.manager_salesforce_id <> FND_API.G_MISS_NUM) Then
109: dbms_sql.bind_variable(p_cur_get_salesgroup, 'p_manager_salesforce_id',
110: p_sales_group_rec.manager_salesforce_id);
111: End if;
112: End get_sales_group_bind_variables;
113:

Line 119: dbms_sql.column_value(p_cur_get_salesgroup, 1, x_sales_group_rec.sales_group_id);

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);
120: dbms_sql.column_value(p_cur_get_salesgroup, 2, x_sales_group_rec.name);
121: dbms_sql.column_value(p_cur_get_salesgroup, 3, x_sales_group_rec.start_date_active);
122: dbms_sql.column_value(p_cur_get_salesgroup, 4, x_sales_group_rec.end_date_active);
123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);

Line 120: dbms_sql.column_value(p_cur_get_salesgroup, 2, x_sales_group_rec.name);

116:
117: Begin
118:
119: dbms_sql.column_value(p_cur_get_salesgroup, 1, x_sales_group_rec.sales_group_id);
120: dbms_sql.column_value(p_cur_get_salesgroup, 2, x_sales_group_rec.name);
121: dbms_sql.column_value(p_cur_get_salesgroup, 3, x_sales_group_rec.start_date_active);
122: dbms_sql.column_value(p_cur_get_salesgroup, 4, x_sales_group_rec.end_date_active);
123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);
124: dbms_sql.column_value(p_cur_get_salesgroup, 6, x_sales_group_rec.parent_sales_group_id);

Line 121: dbms_sql.column_value(p_cur_get_salesgroup, 3, x_sales_group_rec.start_date_active);

117: Begin
118:
119: dbms_sql.column_value(p_cur_get_salesgroup, 1, x_sales_group_rec.sales_group_id);
120: dbms_sql.column_value(p_cur_get_salesgroup, 2, x_sales_group_rec.name);
121: dbms_sql.column_value(p_cur_get_salesgroup, 3, x_sales_group_rec.start_date_active);
122: dbms_sql.column_value(p_cur_get_salesgroup, 4, x_sales_group_rec.end_date_active);
123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);
124: dbms_sql.column_value(p_cur_get_salesgroup, 6, x_sales_group_rec.parent_sales_group_id);
125: dbms_sql.column_value(p_cur_get_salesgroup, 7, x_sales_group_rec.manager_person_id);

Line 122: dbms_sql.column_value(p_cur_get_salesgroup, 4, x_sales_group_rec.end_date_active);

118:
119: dbms_sql.column_value(p_cur_get_salesgroup, 1, x_sales_group_rec.sales_group_id);
120: dbms_sql.column_value(p_cur_get_salesgroup, 2, x_sales_group_rec.name);
121: dbms_sql.column_value(p_cur_get_salesgroup, 3, x_sales_group_rec.start_date_active);
122: dbms_sql.column_value(p_cur_get_salesgroup, 4, x_sales_group_rec.end_date_active);
123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);
124: dbms_sql.column_value(p_cur_get_salesgroup, 6, x_sales_group_rec.parent_sales_group_id);
125: dbms_sql.column_value(p_cur_get_salesgroup, 7, x_sales_group_rec.manager_person_id);
126: dbms_sql.column_value(p_cur_get_salesgroup, 8, x_sales_group_rec.manager_salesforce_id);

Line 123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);

119: dbms_sql.column_value(p_cur_get_salesgroup, 1, x_sales_group_rec.sales_group_id);
120: dbms_sql.column_value(p_cur_get_salesgroup, 2, x_sales_group_rec.name);
121: dbms_sql.column_value(p_cur_get_salesgroup, 3, x_sales_group_rec.start_date_active);
122: dbms_sql.column_value(p_cur_get_salesgroup, 4, x_sales_group_rec.end_date_active);
123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);
124: dbms_sql.column_value(p_cur_get_salesgroup, 6, x_sales_group_rec.parent_sales_group_id);
125: dbms_sql.column_value(p_cur_get_salesgroup, 7, x_sales_group_rec.manager_person_id);
126: dbms_sql.column_value(p_cur_get_salesgroup, 8, x_sales_group_rec.manager_salesforce_id);
127: dbms_sql.column_value(p_cur_get_salesgroup, 9, x_sales_group_rec.accounting_code);

Line 124: dbms_sql.column_value(p_cur_get_salesgroup, 6, x_sales_group_rec.parent_sales_group_id);

120: dbms_sql.column_value(p_cur_get_salesgroup, 2, x_sales_group_rec.name);
121: dbms_sql.column_value(p_cur_get_salesgroup, 3, x_sales_group_rec.start_date_active);
122: dbms_sql.column_value(p_cur_get_salesgroup, 4, x_sales_group_rec.end_date_active);
123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);
124: dbms_sql.column_value(p_cur_get_salesgroup, 6, x_sales_group_rec.parent_sales_group_id);
125: dbms_sql.column_value(p_cur_get_salesgroup, 7, x_sales_group_rec.manager_person_id);
126: dbms_sql.column_value(p_cur_get_salesgroup, 8, x_sales_group_rec.manager_salesforce_id);
127: dbms_sql.column_value(p_cur_get_salesgroup, 9, x_sales_group_rec.accounting_code);
128:

Line 125: dbms_sql.column_value(p_cur_get_salesgroup, 7, x_sales_group_rec.manager_person_id);

121: dbms_sql.column_value(p_cur_get_salesgroup, 3, x_sales_group_rec.start_date_active);
122: dbms_sql.column_value(p_cur_get_salesgroup, 4, x_sales_group_rec.end_date_active);
123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);
124: dbms_sql.column_value(p_cur_get_salesgroup, 6, x_sales_group_rec.parent_sales_group_id);
125: dbms_sql.column_value(p_cur_get_salesgroup, 7, x_sales_group_rec.manager_person_id);
126: dbms_sql.column_value(p_cur_get_salesgroup, 8, x_sales_group_rec.manager_salesforce_id);
127: dbms_sql.column_value(p_cur_get_salesgroup, 9, x_sales_group_rec.accounting_code);
128:
129: End get_sales_group_column_values;

Line 126: dbms_sql.column_value(p_cur_get_salesgroup, 8, x_sales_group_rec.manager_salesforce_id);

122: dbms_sql.column_value(p_cur_get_salesgroup, 4, x_sales_group_rec.end_date_active);
123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);
124: dbms_sql.column_value(p_cur_get_salesgroup, 6, x_sales_group_rec.parent_sales_group_id);
125: dbms_sql.column_value(p_cur_get_salesgroup, 7, x_sales_group_rec.manager_person_id);
126: dbms_sql.column_value(p_cur_get_salesgroup, 8, x_sales_group_rec.manager_salesforce_id);
127: dbms_sql.column_value(p_cur_get_salesgroup, 9, x_sales_group_rec.accounting_code);
128:
129: End get_sales_group_column_values;
130:

Line 127: dbms_sql.column_value(p_cur_get_salesgroup, 9, x_sales_group_rec.accounting_code);

123: dbms_sql.column_value(p_cur_get_salesgroup, 5, x_sales_group_rec.description);
124: dbms_sql.column_value(p_cur_get_salesgroup, 6, x_sales_group_rec.parent_sales_group_id);
125: dbms_sql.column_value(p_cur_get_salesgroup, 7, x_sales_group_rec.manager_person_id);
126: dbms_sql.column_value(p_cur_get_salesgroup, 8, x_sales_group_rec.manager_salesforce_id);
127: dbms_sql.column_value(p_cur_get_salesgroup, 9, x_sales_group_rec.accounting_code);
128:
129: End get_sales_group_column_values;
130:
131: -- Following are private procedures and functions used by get_salesmem

Line 304: dbms_sql.define_column(p_cur_get_salesmember, 1, l_sales_member_rec.salesforce_id);

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);
305: dbms_sql.define_column(p_cur_get_salesmember, 2, l_sales_member_rec.type, 30);
306: dbms_sql.define_column(p_cur_get_salesmember, 3, l_sales_member_rec.start_date_active);
307: dbms_sql.define_column(p_cur_get_salesmember, 4, l_sales_member_rec.end_date_active);
308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);

Line 305: dbms_sql.define_column(p_cur_get_salesmember, 2, l_sales_member_rec.type, 30);

301:
302: Begin
303:
304: dbms_sql.define_column(p_cur_get_salesmember, 1, l_sales_member_rec.salesforce_id);
305: dbms_sql.define_column(p_cur_get_salesmember, 2, l_sales_member_rec.type, 30);
306: dbms_sql.define_column(p_cur_get_salesmember, 3, l_sales_member_rec.start_date_active);
307: dbms_sql.define_column(p_cur_get_salesmember, 4, l_sales_member_rec.end_date_active);
308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);
309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);

Line 306: dbms_sql.define_column(p_cur_get_salesmember, 3, l_sales_member_rec.start_date_active);

302: Begin
303:
304: dbms_sql.define_column(p_cur_get_salesmember, 1, l_sales_member_rec.salesforce_id);
305: dbms_sql.define_column(p_cur_get_salesmember, 2, l_sales_member_rec.type, 30);
306: dbms_sql.define_column(p_cur_get_salesmember, 3, l_sales_member_rec.start_date_active);
307: dbms_sql.define_column(p_cur_get_salesmember, 4, l_sales_member_rec.end_date_active);
308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);
309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);
310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);

Line 307: dbms_sql.define_column(p_cur_get_salesmember, 4, l_sales_member_rec.end_date_active);

303:
304: dbms_sql.define_column(p_cur_get_salesmember, 1, l_sales_member_rec.salesforce_id);
305: dbms_sql.define_column(p_cur_get_salesmember, 2, l_sales_member_rec.type, 30);
306: dbms_sql.define_column(p_cur_get_salesmember, 3, l_sales_member_rec.start_date_active);
307: dbms_sql.define_column(p_cur_get_salesmember, 4, l_sales_member_rec.end_date_active);
308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);
309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);
310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);
311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);

Line 308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);

304: dbms_sql.define_column(p_cur_get_salesmember, 1, l_sales_member_rec.salesforce_id);
305: dbms_sql.define_column(p_cur_get_salesmember, 2, l_sales_member_rec.type, 30);
306: dbms_sql.define_column(p_cur_get_salesmember, 3, l_sales_member_rec.start_date_active);
307: dbms_sql.define_column(p_cur_get_salesmember, 4, l_sales_member_rec.end_date_active);
308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);
309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);
310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);
311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);
312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);

Line 309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);

305: dbms_sql.define_column(p_cur_get_salesmember, 2, l_sales_member_rec.type, 30);
306: dbms_sql.define_column(p_cur_get_salesmember, 3, l_sales_member_rec.start_date_active);
307: dbms_sql.define_column(p_cur_get_salesmember, 4, l_sales_member_rec.end_date_active);
308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);
309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);
310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);
311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);
312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);
313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);

Line 310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);

306: dbms_sql.define_column(p_cur_get_salesmember, 3, l_sales_member_rec.start_date_active);
307: dbms_sql.define_column(p_cur_get_salesmember, 4, l_sales_member_rec.end_date_active);
308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);
309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);
310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);
311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);
312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);
313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);
314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);

Line 311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);

307: dbms_sql.define_column(p_cur_get_salesmember, 4, l_sales_member_rec.end_date_active);
308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);
309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);
310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);
311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);
312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);
313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);
314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);
315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);

Line 312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);

308: dbms_sql.define_column(p_cur_get_salesmember, 5, l_sales_member_rec.employee_person_id);
309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);
310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);
311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);
312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);
313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);
314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);
315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);
316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);

Line 313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);

309: dbms_sql.define_column(p_cur_get_salesmember, 6, l_sales_member_rec.sales_group_id);
310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);
311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);
312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);
313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);
314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);
315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);
316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);
317: dbms_sql.define_column(p_cur_get_salesmember, 13, l_sales_member_rec.job_title, 240);

Line 314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);

310: dbms_sql.define_column(p_cur_get_salesmember, 7, l_sales_member_rec.partner_address_id);
311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);
312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);
313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);
314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);
315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);
316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);
317: dbms_sql.define_column(p_cur_get_salesmember, 13, l_sales_member_rec.job_title, 240);
318: dbms_sql.define_column(p_cur_get_salesmember, 14, l_sales_member_rec.sales_group_name, 60);

Line 315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);

311: dbms_sql.define_column(p_cur_get_salesmember, 8, l_sales_member_rec.partner_customer_id);
312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);
313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);
314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);
315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);
316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);
317: dbms_sql.define_column(p_cur_get_salesmember, 13, l_sales_member_rec.job_title, 240);
318: dbms_sql.define_column(p_cur_get_salesmember, 14, l_sales_member_rec.sales_group_name, 60);
319: dbms_sql.define_column(p_cur_get_salesmember, 15, l_sales_member_rec.managing_sales_grp_id);

Line 316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);

312: --dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.partner_contact_id);
313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);
314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);
315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);
316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);
317: dbms_sql.define_column(p_cur_get_salesmember, 13, l_sales_member_rec.job_title, 240);
318: dbms_sql.define_column(p_cur_get_salesmember, 14, l_sales_member_rec.sales_group_name, 60);
319: dbms_sql.define_column(p_cur_get_salesmember, 15, l_sales_member_rec.managing_sales_grp_id);
320: dbms_sql.define_column(p_cur_get_salesmember, 16, l_sales_member_rec.managing_sales_grp_name, 60);

Line 317: dbms_sql.define_column(p_cur_get_salesmember, 13, l_sales_member_rec.job_title, 240);

313: dbms_sql.define_column(p_cur_get_salesmember, 9, l_sales_member_rec.last_name, 40);
314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);
315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);
316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);
317: dbms_sql.define_column(p_cur_get_salesmember, 13, l_sales_member_rec.job_title, 240);
318: dbms_sql.define_column(p_cur_get_salesmember, 14, l_sales_member_rec.sales_group_name, 60);
319: dbms_sql.define_column(p_cur_get_salesmember, 15, l_sales_member_rec.managing_sales_grp_id);
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;

Line 318: dbms_sql.define_column(p_cur_get_salesmember, 14, l_sales_member_rec.sales_group_name, 60);

314: dbms_sql.define_column(p_cur_get_salesmember, 10, l_sales_member_rec.first_name, 20);
315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);
316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);
317: dbms_sql.define_column(p_cur_get_salesmember, 13, l_sales_member_rec.job_title, 240);
318: dbms_sql.define_column(p_cur_get_salesmember, 14, l_sales_member_rec.sales_group_name, 60);
319: dbms_sql.define_column(p_cur_get_salesmember, 15, l_sales_member_rec.managing_sales_grp_id);
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:

Line 319: dbms_sql.define_column(p_cur_get_salesmember, 15, l_sales_member_rec.managing_sales_grp_id);

315: dbms_sql.define_column(p_cur_get_salesmember, 11, l_sales_member_rec.full_name, 240);
316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);
317: dbms_sql.define_column(p_cur_get_salesmember, 13, l_sales_member_rec.job_title, 240);
318: dbms_sql.define_column(p_cur_get_salesmember, 14, l_sales_member_rec.sales_group_name, 60);
319: dbms_sql.define_column(p_cur_get_salesmember, 15, l_sales_member_rec.managing_sales_grp_id);
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,

Line 320: dbms_sql.define_column(p_cur_get_salesmember, 16, l_sales_member_rec.managing_sales_grp_name, 60);

316: dbms_sql.define_column(p_cur_get_salesmember, 12, l_sales_member_rec.email_address, 240);
317: dbms_sql.define_column(p_cur_get_salesmember, 13, l_sales_member_rec.job_title, 240);
318: dbms_sql.define_column(p_cur_get_salesmember, 14, l_sales_member_rec.sales_group_name, 60);
319: dbms_sql.define_column(p_cur_get_salesmember, 15, l_sales_member_rec.managing_sales_grp_id);
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

Line 328: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_user_id',

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',
329: p_sales_member_rec.user_id);
330: End if;
331:
332: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then

Line 333: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_salesforce_id',

329: p_sales_member_rec.user_id);
330: End if;
331:
332: If (p_sales_member_rec.salesforce_id <> FND_API.G_MISS_NUM) Then
333: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_salesforce_id',
334: p_sales_member_rec.salesforce_id);
335: End if;
336:
337: If (p_sales_member_rec.employee_person_id <> FND_API.G_MISS_NUM) Then

Line 338: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_employee_person_id',

334: p_sales_member_rec.salesforce_id);
335: End if;
336:
337: If (p_sales_member_rec.employee_person_id <> FND_API.G_MISS_NUM) Then
338: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_employee_person_id',
339: p_sales_member_rec.employee_person_id);
340: End if;
341:
342: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then

Line 343: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_sales_group_id',

339: p_sales_member_rec.employee_person_id);
340: End if;
341:
342: If (p_sales_member_rec.sales_group_id <> FND_API.G_MISS_NUM) Then
343: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_sales_group_id',
344: p_sales_member_rec.sales_group_id);
345: End if;
346:
347:

Line 349: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_partner_address_id',

345: End if;
346:
347:
348: If (p_sales_member_rec.partner_address_id <> FND_API.G_MISS_NUM) Then
349: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_partner_address_id',
350: p_sales_member_rec.partner_address_id);
351: End if;
352:
353: If (p_sales_member_rec.partner_customer_id <> FND_API.G_MISS_NUM) Then

Line 354: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_partner_customer_id',

350: p_sales_member_rec.partner_address_id);
351: End if;
352:
353: If (p_sales_member_rec.partner_customer_id <> FND_API.G_MISS_NUM) Then
354: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_partner_customer_id',
355: p_sales_member_rec.partner_customer_id);
356: End if;
357:
358: If (p_sales_member_rec.last_name <> FND_API.G_MISS_CHAR) Then

Line 359: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_last_name',

355: p_sales_member_rec.partner_customer_id);
356: End if;
357:
358: If (p_sales_member_rec.last_name <> FND_API.G_MISS_CHAR) Then
359: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_last_name',
360: p_sales_member_rec.last_name);
361: End if;
362:
363: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then

Line 364: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_first_name',

360: p_sales_member_rec.last_name);
361: End if;
362:
363: If (p_sales_member_rec.first_name <> FND_API.G_MISS_CHAR) Then
364: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_first_name',
365: p_sales_member_rec.first_name);
366: End if;
367:
368: If (p_sales_member_rec.email_address <> FND_API.G_MISS_CHAR) Then

Line 369: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_email_address',

365: p_sales_member_rec.first_name);
366: End if;
367:
368: If (p_sales_member_rec.email_address <> FND_API.G_MISS_CHAR) Then
369: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_email_address',
370: p_sales_member_rec.email_address);
371: End if;
372:
373: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then

Line 374: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_type',

370: p_sales_member_rec.email_address);
371: End if;
372:
373: If (p_sales_member_rec.type <> FND_API.G_MISS_CHAR) Then
374: dbms_sql.bind_variable(p_cur_get_salesmember, 'p_type',
375: p_sales_member_rec.type);
376: End if;
377:
378: End get_salesmem_bind_vars;

Line 385: dbms_sql.column_value(p_cur_get_salesmember, 1, x_sales_member_rec.salesforce_id);

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);
386: dbms_sql.column_value(p_cur_get_salesmember, 2, x_sales_member_rec.type);
387: dbms_sql.column_value(p_cur_get_salesmember, 3, x_sales_member_rec.start_date_active);
388: dbms_sql.column_value(p_cur_get_salesmember, 4, x_sales_member_rec.end_date_active);
389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);

Line 386: dbms_sql.column_value(p_cur_get_salesmember, 2, x_sales_member_rec.type);

382:
383: Begin
384:
385: dbms_sql.column_value(p_cur_get_salesmember, 1, x_sales_member_rec.salesforce_id);
386: dbms_sql.column_value(p_cur_get_salesmember, 2, x_sales_member_rec.type);
387: dbms_sql.column_value(p_cur_get_salesmember, 3, x_sales_member_rec.start_date_active);
388: dbms_sql.column_value(p_cur_get_salesmember, 4, x_sales_member_rec.end_date_active);
389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);
390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);

Line 387: dbms_sql.column_value(p_cur_get_salesmember, 3, x_sales_member_rec.start_date_active);

383: Begin
384:
385: dbms_sql.column_value(p_cur_get_salesmember, 1, x_sales_member_rec.salesforce_id);
386: dbms_sql.column_value(p_cur_get_salesmember, 2, x_sales_member_rec.type);
387: dbms_sql.column_value(p_cur_get_salesmember, 3, x_sales_member_rec.start_date_active);
388: dbms_sql.column_value(p_cur_get_salesmember, 4, x_sales_member_rec.end_date_active);
389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);
390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);
391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);

Line 388: dbms_sql.column_value(p_cur_get_salesmember, 4, x_sales_member_rec.end_date_active);

384:
385: dbms_sql.column_value(p_cur_get_salesmember, 1, x_sales_member_rec.salesforce_id);
386: dbms_sql.column_value(p_cur_get_salesmember, 2, x_sales_member_rec.type);
387: dbms_sql.column_value(p_cur_get_salesmember, 3, x_sales_member_rec.start_date_active);
388: dbms_sql.column_value(p_cur_get_salesmember, 4, x_sales_member_rec.end_date_active);
389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);
390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);
391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);
392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);

Line 389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);

385: dbms_sql.column_value(p_cur_get_salesmember, 1, x_sales_member_rec.salesforce_id);
386: dbms_sql.column_value(p_cur_get_salesmember, 2, x_sales_member_rec.type);
387: dbms_sql.column_value(p_cur_get_salesmember, 3, x_sales_member_rec.start_date_active);
388: dbms_sql.column_value(p_cur_get_salesmember, 4, x_sales_member_rec.end_date_active);
389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);
390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);
391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);
392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);
393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);

Line 390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);

386: dbms_sql.column_value(p_cur_get_salesmember, 2, x_sales_member_rec.type);
387: dbms_sql.column_value(p_cur_get_salesmember, 3, x_sales_member_rec.start_date_active);
388: dbms_sql.column_value(p_cur_get_salesmember, 4, x_sales_member_rec.end_date_active);
389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);
390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);
391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);
392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);
393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);
394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);

Line 391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);

387: dbms_sql.column_value(p_cur_get_salesmember, 3, x_sales_member_rec.start_date_active);
388: dbms_sql.column_value(p_cur_get_salesmember, 4, x_sales_member_rec.end_date_active);
389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);
390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);
391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);
392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);
393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);
394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);
395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);

Line 392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);

388: dbms_sql.column_value(p_cur_get_salesmember, 4, x_sales_member_rec.end_date_active);
389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);
390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);
391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);
392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);
393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);
394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);
395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);
396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);

Line 393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);

389: dbms_sql.column_value(p_cur_get_salesmember, 5, x_sales_member_rec.employee_person_id);
390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);
391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);
392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);
393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);
394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);
395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);
396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);
397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);

Line 394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);

390: dbms_sql.column_value(p_cur_get_salesmember, 6, x_sales_member_rec.sales_group_id);
391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);
392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);
393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);
394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);
395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);
396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);
397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);
398: dbms_sql.column_value(p_cur_get_salesmember, 13, x_sales_member_rec.job_title);

Line 395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);

391: dbms_sql.column_value(p_cur_get_salesmember, 7, x_sales_member_rec.partner_address_id);
392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);
393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);
394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);
395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);
396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);
397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);
398: dbms_sql.column_value(p_cur_get_salesmember, 13, x_sales_member_rec.job_title);
399: dbms_sql.column_value(p_cur_get_salesmember, 14, x_sales_member_rec.sales_group_name);

Line 396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);

392: dbms_sql.column_value(p_cur_get_salesmember, 8, x_sales_member_rec.partner_customer_id);
393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);
394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);
395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);
396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);
397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);
398: dbms_sql.column_value(p_cur_get_salesmember, 13, x_sales_member_rec.job_title);
399: dbms_sql.column_value(p_cur_get_salesmember, 14, x_sales_member_rec.sales_group_name);
400: dbms_sql.column_value(p_cur_get_salesmember, 15, x_sales_member_rec.managing_sales_grp_id);

Line 397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);

393: --dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.partner_contact_id);
394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);
395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);
396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);
397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);
398: dbms_sql.column_value(p_cur_get_salesmember, 13, x_sales_member_rec.job_title);
399: dbms_sql.column_value(p_cur_get_salesmember, 14, x_sales_member_rec.sales_group_name);
400: dbms_sql.column_value(p_cur_get_salesmember, 15, x_sales_member_rec.managing_sales_grp_id);
401: dbms_sql.column_value(p_cur_get_salesmember, 16, x_sales_member_rec.managing_sales_grp_name);

Line 398: dbms_sql.column_value(p_cur_get_salesmember, 13, x_sales_member_rec.job_title);

394: dbms_sql.column_value(p_cur_get_salesmember, 9, x_sales_member_rec.last_name);
395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);
396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);
397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);
398: dbms_sql.column_value(p_cur_get_salesmember, 13, x_sales_member_rec.job_title);
399: dbms_sql.column_value(p_cur_get_salesmember, 14, x_sales_member_rec.sales_group_name);
400: dbms_sql.column_value(p_cur_get_salesmember, 15, x_sales_member_rec.managing_sales_grp_id);
401: dbms_sql.column_value(p_cur_get_salesmember, 16, x_sales_member_rec.managing_sales_grp_name);
402:

Line 399: dbms_sql.column_value(p_cur_get_salesmember, 14, x_sales_member_rec.sales_group_name);

395: dbms_sql.column_value(p_cur_get_salesmember, 10, x_sales_member_rec.first_name);
396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);
397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);
398: dbms_sql.column_value(p_cur_get_salesmember, 13, x_sales_member_rec.job_title);
399: dbms_sql.column_value(p_cur_get_salesmember, 14, x_sales_member_rec.sales_group_name);
400: dbms_sql.column_value(p_cur_get_salesmember, 15, x_sales_member_rec.managing_sales_grp_id);
401: dbms_sql.column_value(p_cur_get_salesmember, 16, x_sales_member_rec.managing_sales_grp_name);
402:
403: End get_salesmem_column_values;

Line 400: dbms_sql.column_value(p_cur_get_salesmember, 15, x_sales_member_rec.managing_sales_grp_id);

396: dbms_sql.column_value(p_cur_get_salesmember, 11, x_sales_member_rec.full_name);
397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);
398: dbms_sql.column_value(p_cur_get_salesmember, 13, x_sales_member_rec.job_title);
399: dbms_sql.column_value(p_cur_get_salesmember, 14, x_sales_member_rec.sales_group_name);
400: dbms_sql.column_value(p_cur_get_salesmember, 15, x_sales_member_rec.managing_sales_grp_id);
401: dbms_sql.column_value(p_cur_get_salesmember, 16, x_sales_member_rec.managing_sales_grp_name);
402:
403: End get_salesmem_column_values;
404:

Line 401: dbms_sql.column_value(p_cur_get_salesmember, 16, x_sales_member_rec.managing_sales_grp_name);

397: dbms_sql.column_value(p_cur_get_salesmember, 12, x_sales_member_rec.email_address);
398: dbms_sql.column_value(p_cur_get_salesmember, 13, x_sales_member_rec.job_title);
399: dbms_sql.column_value(p_cur_get_salesmember, 14, x_sales_member_rec.sales_group_name);
400: dbms_sql.column_value(p_cur_get_salesmember, 15, x_sales_member_rec.managing_sales_grp_id);
401: dbms_sql.column_value(p_cur_get_salesmember, 16, x_sales_member_rec.managing_sales_grp_name);
402:
403: End get_salesmem_column_values;
404:
405: /*****************************************************************************************/

Line 485: l_cur_get_salesgroup := DBMS_SQL.open_cursor;

481: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Open Cursor');
482: END IF;
483: END IF;
484:
485: l_cur_get_salesgroup := DBMS_SQL.open_cursor;
486:
487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
488: IF l_debug THEN
489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Generate Select');

Line 509: DBMS_SQL.parse(l_cur_get_salesgroup,

505: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Parse SQL');
506: END IF;
507: END IF;
508:
509: DBMS_SQL.parse(l_cur_get_salesgroup,
510: l_select_cl || l_where_cl, DBMS_SQL.native);
511:
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
513: IF l_debug THEN

Line 510: l_select_cl || l_where_cl, DBMS_SQL.native);

506: END IF;
507: END IF;
508:
509: DBMS_SQL.parse(l_cur_get_salesgroup,
510: l_select_cl || l_where_cl, DBMS_SQL.native);
511:
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
513: IF l_debug THEN
514: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Define Columns');

Line 534: l_ignore := DBMS_SQL.Execute(l_cur_get_salesgroup);

530: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Execute SQL');
531: END IF;
532: END IF;
533:
534: l_ignore := DBMS_SQL.Execute(l_cur_get_salesgroup);
535:
536: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
537: IF l_debug THEN
538: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Column Values');

Line 543: If (dbms_sql.fetch_rows(l_cur_get_salesgroup) > 0) Then

539: END IF;
540: END IF;
541:
542: Loop
543: If (dbms_sql.fetch_rows(l_cur_get_salesgroup) > 0) Then
544: get_sales_group_column_values(l_cur_get_salesgroup, l_SALES_GROUP_rec);
545: l_curr_row := l_curr_row + 1;
546: x_SALES_GROUP_tbl(l_curr_row) := l_SALES_GROUP_rec;
547: Else

Line 558: DBMS_SQL.Close_Cursor(l_cur_get_salesgroup);

554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Close cursor');
555: END IF;
556: END IF;
557:
558: DBMS_SQL.Close_Cursor(l_cur_get_salesgroup);
559:
560:
561: EXCEPTION
562:

Line 1010: l_cur_get_salesmember := DBMS_SQL.open_cursor;

1006: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Open Cursor');
1007: END IF;
1008: END IF;
1009:
1010: l_cur_get_salesmember := DBMS_SQL.open_cursor;
1011:
1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1013: IF l_debug THEN
1014: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Generate Select');

Line 1049: DBMS_SQL.parse(l_cur_get_salesmember,

1045: END IF;
1046: END IF;
1047:
1048:
1049: DBMS_SQL.parse(l_cur_get_salesmember,
1050: l_select_cl || l_where_cl, DBMS_SQL.native);
1051:
1052:
1053: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1050: l_select_cl || l_where_cl, DBMS_SQL.native);

1046: END IF;
1047:
1048:
1049: DBMS_SQL.parse(l_cur_get_salesmember,
1050: l_select_cl || l_where_cl, DBMS_SQL.native);
1051:
1052:
1053: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1054: IF l_debug THEN

Line 1075: l_ignore := DBMS_SQL.Execute(l_cur_get_salesmember);

1071: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Execute SQL');
1072: END IF;
1073: END IF;
1074:
1075: l_ignore := DBMS_SQL.Execute(l_cur_get_salesmember);
1076:
1077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1078: IF l_debug THEN
1079: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Column Values');

Line 1087: If (dbms_sql.fetch_rows(l_cur_get_salesmember) > 0) Then

1083:
1084: -- initializing return status as this is always come up as 'S'
1085: x_return_status := FND_API.G_RET_STS_ERROR;
1086: Loop
1087: If (dbms_sql.fetch_rows(l_cur_get_salesmember) > 0) Then
1088: get_salesmem_column_values(l_cur_get_salesmember, l_sales_member_rec);
1089: l_curr_row := l_curr_row + 1;
1090: x_sales_member_tbl(l_curr_row) := l_sales_member_rec;
1091: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1103: DBMS_SQL.Close_Cursor(l_cur_get_salesmember);

1099: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Close cursor');
1100: END IF;
1101: END IF;
1102:
1103: DBMS_SQL.Close_Cursor(l_cur_get_salesmember);
1104:
1105: EXCEPTION
1106:
1107: WHEN NO_DATA_FOUND THEN