DBA Data[Home] [Help]

APPS.CSI_PRICING_ATTRIBS_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 16: x_pri_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec,

12: /*----------------------------------------------------------*/
13:
14: PROCEDURE Initialize_pri_rec_no_dump
15: (
16: x_pri_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec,
17: p_pri_hist_id IN NUMBER,
18: x_first_no_dump IN OUT NOCOPY DATE
19: ) IS
20:

Line 285: ( x_pri_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec,

281: /* from the history */
282: /*----------------------------------------------------------*/
283:
284: PROCEDURE Initialize_pri_rec
285: ( x_pri_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec,
286: p_pri_h_id IN NUMBER,
287: x_nearest_full_dump IN OUT NOCOPY DATE
288: ) IS
289:

Line 549: ( x_pri_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

545: /* from the history */
546: /*----------------------------------------------------------*/
547:
548: PROCEDURE Construct_pri_from_hist
549: ( x_pri_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
550: p_time_stamp IN DATE
551: ) IS
552:
553: l_nearest_full_dump DATE := p_time_stamp;

Line 555: l_pri_tbl csi_datastructures_pub.pricing_attribs_tbl;

551: ) IS
552:
553: l_nearest_full_dump DATE := p_time_stamp;
554: l_pri_att_hist_id NUMBER;
555: l_pri_tbl csi_datastructures_pub.pricing_attribs_tbl;
556: l_pri_count NUMBER := 0;
557: --
558: Process_next EXCEPTION;
559:

Line 1604: l_pri_rec csi_datastructures_pub.pricing_attribs_rec;

1600: PROCEDURE Define_pri_Columns
1601: ( p_get_pri_cursor_id IN NUMBER
1602: )
1603: IS
1604: l_pri_rec csi_datastructures_pub.pricing_attribs_rec;
1605:
1606: BEGIN
1607:
1608: dbms_sql.define_column(p_get_pri_cursor_id, 1, l_pri_rec.PRICING_ATTRIBUTE_ID);

Line 1746: x_pri_rec OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec

1742: /*----------------------------------------------------------*/
1743:
1744: PROCEDURE Get_pri_Column_Values
1745: (p_get_pri_cursor_id IN NUMBER,
1746: x_pri_rec OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec
1747: ) IS
1748:
1749: BEGIN
1750:

Line 1888: ( p_pri_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec,

1884: /* for the Dynamic SQL */
1885: /*----------------------------------------------------------*/
1886:
1887: PROCEDURE Bind_pri_variable
1888: ( p_pri_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec,
1889: p_cur_get_pri IN NUMBER
1890: )
1891: IS
1892: BEGIN

Line 1912: ( p_pri_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec

1908: /* clause for Extended Attributes units */
1909: /*----------------------------------------------------------*/
1910:
1911: PROCEDURE Gen_pri_Where_Clause
1912: ( p_pri_query_rec IN csi_datastructures_pub.pricing_attribs_query_rec
1913: ,x_where_clause OUT NOCOPY VARCHAR2
1914: ) IS
1915:
1916: BEGIN

Line 1957: ,p_pricing_attribs_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec

1953: ( p_api_version IN NUMBER
1954: ,p_commit IN VARCHAR2
1955: ,p_init_msg_list IN VARCHAR2
1956: ,p_validation_level IN NUMBER
1957: ,p_pricing_attribs_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec
1958: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1959: ,x_return_status OUT NOCOPY VARCHAR2
1960: ,x_msg_count OUT NOCOPY NUMBER
1961: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1958: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

1954: ,p_commit IN VARCHAR2
1955: ,p_init_msg_list IN VARCHAR2
1956: ,p_validation_level IN NUMBER
1957: ,p_pricing_attribs_rec IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_rec
1958: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1959: ,x_return_status OUT NOCOPY VARCHAR2
1960: ,x_msg_count OUT NOCOPY NUMBER
1961: ,x_msg_data OUT NOCOPY VARCHAR2
1962: ,p_called_from_grp IN VARCHAR2

Line 2561: ,p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec

2557: ( p_api_version IN NUMBER
2558: ,p_commit IN VARCHAR2
2559: ,p_init_msg_list IN VARCHAR2
2560: ,p_validation_level IN NUMBER
2561: ,p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec
2562: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2563: ,x_return_status OUT NOCOPY VARCHAR2
2564: ,x_msg_count OUT NOCOPY NUMBER
2565: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2562: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2558: ,p_commit IN VARCHAR2
2559: ,p_init_msg_list IN VARCHAR2
2560: ,p_validation_level IN NUMBER
2561: ,p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec
2562: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2563: ,x_return_status OUT NOCOPY VARCHAR2
2564: ,x_msg_count OUT NOCOPY NUMBER
2565: ,x_msg_data OUT NOCOPY VARCHAR2
2566: )

Line 2575: l_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;

2571: l_msg_index NUMBER;
2572: l_msg_count NUMBER;
2573: l_pricing_attrib_id NUMBER := p_pricing_attribs_rec.pricing_attribute_id;
2574: l_pricing_attrib_h_id NUMBER;
2575: l_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;
2576: l_temp_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;
2577: l_dump_frequency NUMBER;
2578: l_dump_frequency_flag VARCHAR2(30);
2579: l_pricing_history_rec csi_datastructures_pub.pricing_history_rec;

Line 2576: l_temp_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;

2572: l_msg_count NUMBER;
2573: l_pricing_attrib_id NUMBER := p_pricing_attribs_rec.pricing_attribute_id;
2574: l_pricing_attrib_h_id NUMBER;
2575: l_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;
2576: l_temp_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;
2577: l_dump_frequency NUMBER;
2578: l_dump_frequency_flag VARCHAR2(30);
2579: l_pricing_history_rec csi_datastructures_pub.pricing_history_rec;
2580:

Line 2579: l_pricing_history_rec csi_datastructures_pub.pricing_history_rec;

2575: l_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;
2576: l_temp_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;
2577: l_dump_frequency NUMBER;
2578: l_dump_frequency_flag VARCHAR2(30);
2579: l_pricing_history_rec csi_datastructures_pub.pricing_history_rec;
2580:
2581: CURSOR pricing_hist_csr (p_pricing_hist_id NUMBER) IS
2582: SELECT *
2583: FROM csi_i_pricing_attribs_h

Line 7351: ,p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec

7347: p_api_version IN NUMBER
7348: ,p_commit IN VARCHAR2
7349: ,p_init_msg_list IN VARCHAR2
7350: ,p_validation_level IN NUMBER
7351: ,p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec
7352: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7353: ,x_return_status OUT NOCOPY VARCHAR2
7354: ,x_msg_count OUT NOCOPY NUMBER
7355: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7352: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

7348: ,p_commit IN VARCHAR2
7349: ,p_init_msg_list IN VARCHAR2
7350: ,p_validation_level IN NUMBER
7351: ,p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec
7352: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7353: ,x_return_status OUT NOCOPY VARCHAR2
7354: ,x_msg_count OUT NOCOPY NUMBER
7355: ,x_msg_data OUT NOCOPY VARCHAR2
7356: )

Line 7364: l_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;

7360: l_api_version CONSTANT NUMBER := 1.0;
7361: l_debug_level NUMBER;
7362: l_msg_index NUMBER;
7363: l_msg_count NUMBER;
7364: l_pricing_attribs_rec csi_datastructures_pub.pricing_attribs_rec;
7365: l_object_version_number NUMBER;
7366: BEGIN
7367:
7368: -- Standard Start of API savepoint