APPS.CSI_PRICING_ATTRIBS_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 18: ,p_pricing_attribs_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec

14: ( p_api_version IN NUMBER
15: ,p_commit IN VARCHAR2
16: ,p_init_msg_list IN VARCHAR2
17: ,p_validation_level IN NUMBER
18: ,p_pricing_attribs_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec
19: ,p_time_stamp IN DATE
20: ,x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_msg_count OUT NOCOPY NUMBER

Line 20: ,x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

16: ,p_init_msg_list IN VARCHAR2
17: ,p_validation_level IN NUMBER
18: ,p_pricing_attribs_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec
19: ,p_time_stamp IN DATE
20: ,x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_msg_count OUT NOCOPY NUMBER
23: ,x_msg_data OUT NOCOPY VARCHAR2
24: )

Line 30: l_pri_rec csi_datastructures_pub.pricing_attribs_rec;

26: IS
27: l_api_name CONSTANT VARCHAR2(30) := 'get_pricing_attribs';
28: l_api_version CONSTANT NUMBER := 1.0;
29: l_debug_level NUMBER;
30: l_pri_rec csi_datastructures_pub.pricing_attribs_rec;
31: l_rows_processed NUMBER;
32: l_where_clause VARCHAR2(2000) := '';
33: l_select_stmt VARCHAR2(20000) := 'SELECT * FROM csi_i_pricing_attribs ';
34: l_cur_get_pri NUMBER;

Line 230: ,p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

226: ( p_api_version IN NUMBER
227: ,p_commit IN VARCHAR2
228: ,p_init_msg_list IN VARCHAR2
229: ,p_validation_level IN NUMBER
230: ,p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
231: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
232: ,x_return_status OUT NOCOPY VARCHAR2
233: ,x_msg_count OUT NOCOPY NUMBER
234: ,x_msg_data OUT NOCOPY VARCHAR2

Line 231: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

227: ,p_commit IN VARCHAR2
228: ,p_init_msg_list IN VARCHAR2
229: ,p_validation_level IN NUMBER
230: ,p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
231: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
232: ,x_return_status OUT NOCOPY VARCHAR2
233: ,x_msg_count OUT NOCOPY NUMBER
234: ,x_msg_data OUT NOCOPY VARCHAR2
235: )

Line 417: ,p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl

413: ( p_api_version IN NUMBER
414: ,p_commit IN VARCHAR2
415: ,p_init_msg_list IN VARCHAR2
416: ,p_validation_level IN NUMBER
417: ,p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl
418: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
419: ,x_return_status OUT NOCOPY VARCHAR2
420: ,x_msg_count OUT NOCOPY NUMBER
421: ,x_msg_data OUT NOCOPY VARCHAR2

Line 418: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

414: ,p_commit IN VARCHAR2
415: ,p_init_msg_list IN VARCHAR2
416: ,p_validation_level IN NUMBER
417: ,p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl
418: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
419: ,x_return_status OUT NOCOPY VARCHAR2
420: ,x_msg_count OUT NOCOPY NUMBER
421: ,x_msg_data OUT NOCOPY VARCHAR2
422: )

Line 602: ,p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl

598: ( p_api_version IN NUMBER
599: ,p_commit IN VARCHAR2
600: ,p_init_msg_list IN VARCHAR2
601: ,p_validation_level IN NUMBER
602: ,p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl
603: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
604: ,x_return_status OUT NOCOPY VARCHAR2
605: ,x_msg_count OUT NOCOPY NUMBER
606: ,x_msg_data OUT NOCOPY VARCHAR2

Line 603: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

599: ,p_commit IN VARCHAR2
600: ,p_init_msg_list IN VARCHAR2
601: ,p_validation_level IN NUMBER
602: ,p_pricing_attribs_tbl IN csi_datastructures_pub.pricing_attribs_tbl
603: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
604: ,x_return_status OUT NOCOPY VARCHAR2
605: ,x_msg_count OUT NOCOPY NUMBER
606: ,x_msg_data OUT NOCOPY VARCHAR2
607: )