APPS.CSI_PRICING_ATTRIBS_PUB dependencies on CSI_PRICING_ATTRIBS_PVT

Line 105: csi_pricing_attribs_pvt.Gen_pri_Where_Clause

101: END IF;
102:
103:
104: -- Generate the where clause
105: csi_pricing_attribs_pvt.Gen_pri_Where_Clause
106: ( p_pri_query_rec => p_pricing_attribs_query_rec,
107: x_where_clause => l_where_clause );
108:
109: -- Build the select statement

Line 119: csi_pricing_attribs_pvt.Bind_pri_variable

115: --Parse the select statement
116: dbms_sql.parse(l_cur_get_pri, l_select_stmt , dbms_sql.native);
117:
118: -- Bind the variables
119: csi_pricing_attribs_pvt.Bind_pri_variable
120: (p_pricing_attribs_query_rec,
121: l_cur_get_pri );
122:
123: -- Define output variables

Line 124: csi_pricing_attribs_pvt.Define_pri_Columns(l_cur_get_pri);

120: (p_pricing_attribs_query_rec,
121: l_cur_get_pri );
122:
123: -- Define output variables
124: csi_pricing_attribs_pvt.Define_pri_Columns(l_cur_get_pri);
125:
126: -- execute the select statement
127: l_rows_processed := dbms_sql.execute(l_cur_get_pri);
128:

Line 132: csi_pricing_attribs_pvt.Get_pri_Column_Values(l_cur_get_pri, l_pri_rec);

128:
129:
130: LOOP
131: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_pri) = 0;
132: csi_pricing_attribs_pvt.Get_pri_Column_Values(l_cur_get_pri, l_pri_rec);
133: l_count := l_count + 1;
134: x_pricing_attribs_tbl(l_count) := l_pri_rec;
135: END LOOP;
136:

Line 142: csi_pricing_attribs_pvt.Construct_pri_From_Hist(x_pricing_attribs_tbl, p_time_stamp);

138: DBMS_SQL.CLOSE_CURSOR(l_cur_get_pri);
139:
140: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
141: IF p_time_stamp <= sysdate THEN
142: csi_pricing_attribs_pvt.Construct_pri_From_Hist(x_pricing_attribs_tbl, p_time_stamp);
143: ELSE
144: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
145: FND_MESSAGE.SET_TOKEN('TIME_STAMP',p_time_stamp);
146: FND_MSG_PUB.ADD;

Line 310: csi_pricing_attribs_pvt.create_pricing_attribs

306: IF p_pricing_attribs_tbl.COUNT > 0 THEN
307: FOR tab_row IN p_pricing_attribs_tbl.FIRST .. p_pricing_attribs_tbl.LAST
308: LOOP
309: IF p_pricing_attribs_tbl.EXISTS(tab_row) THEN
310: csi_pricing_attribs_pvt.create_pricing_attribs
311: ( p_api_version => p_api_version
312: ,p_commit => p_commit
313: ,p_init_msg_list => p_init_msg_list
314: ,p_validation_level => p_validation_level

Line 495: csi_pricing_attribs_pvt.update_pricing_attribs

491: IF p_pricing_attribs_tbl.COUNT > 0 THEN
492: FOR tab_row IN p_pricing_attribs_tbl.FIRST .. p_pricing_attribs_tbl.LAST
493: LOOP
494: IF p_pricing_attribs_tbl.EXISTS(tab_row) THEN
495: csi_pricing_attribs_pvt.update_pricing_attribs
496: ( p_api_version => p_api_version
497: ,p_commit => fnd_api.g_false
498: ,p_init_msg_list => p_init_msg_list
499: ,p_validation_level => p_validation_level

Line 680: csi_pricing_attribs_pvt.expire_pricing_attribs

676: IF p_pricing_attribs_tbl.COUNT > 0 THEN
677: FOR tab_row IN p_pricing_attribs_tbl.FIRST .. p_pricing_attribs_tbl.LAST
678: LOOP
679: IF p_pricing_attribs_tbl.EXISTS(tab_row) THEN
680: csi_pricing_attribs_pvt.expire_pricing_attribs
681: ( p_api_version => p_api_version
682: ,p_commit => fnd_api.g_false
683: ,p_init_msg_list => p_init_msg_list
684: ,p_validation_level => p_validation_level