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.CN_GET_TX_DATA_PUB_W dependencies on CN_GET_TX_DATA_PUB

Line 1: package body cn_get_tx_data_pub_w as

1: package body cn_get_tx_data_pub_w as
2: /* $Header: cnwxadjb.pls 120.5.12010000.3 2009/02/02 13:04:28 gmarwah ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_tx_data_pub.adj_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_tx_data_pub.adj_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_get_tx_data_pub_w as
2: /* $Header: cnwxadjb.pls 120.5.12010000.3 2009/02/02 13:04:28 gmarwah ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_tx_data_pub.adj_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 402: procedure rosetta_table_copy_out_p1(t cn_get_tx_data_pub.adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

398: end loop;
399: end if;
400: end if;
401: end rosetta_table_copy_in_p1;
402: procedure rosetta_table_copy_out_p1(t cn_get_tx_data_pub.adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
403: , a1 out nocopy JTF_VARCHAR2_TABLE_100
404: , a2 out nocopy JTF_VARCHAR2_TABLE_400
405: , a3 out nocopy JTF_NUMBER_TABLE
406: , a4 out nocopy JTF_NUMBER_TABLE

Line 1376: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_tx_data_pub.tx_adj_data_tbl, a0 JTF_NUMBER_TABLE

1372: end if;
1373: end if;
1374: end rosetta_table_copy_out_p1;
1375:
1376: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_tx_data_pub.tx_adj_data_tbl, a0 JTF_NUMBER_TABLE
1377: , a1 JTF_VARCHAR2_TABLE_100
1378: , a2 JTF_VARCHAR2_TABLE_400
1379: , a3 JTF_DATE_TABLE
1380: , a4 JTF_NUMBER_TABLE

Line 1423: procedure rosetta_table_copy_out_p3(t cn_get_tx_data_pub.tx_adj_data_tbl, a0 out nocopy JTF_NUMBER_TABLE

1419: end loop;
1420: end if;
1421: end if;
1422: end rosetta_table_copy_in_p3;
1423: procedure rosetta_table_copy_out_p3(t cn_get_tx_data_pub.tx_adj_data_tbl, a0 out nocopy JTF_NUMBER_TABLE
1424: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1425: , a2 out nocopy JTF_VARCHAR2_TABLE_400
1426: , a3 out nocopy JTF_DATE_TABLE
1427: , a4 out nocopy JTF_NUMBER_TABLE

Line 1517: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_tx_data_pub.split_data_tbl, a0 JTF_NUMBER_TABLE

1513: end if;
1514: end if;
1515: end rosetta_table_copy_out_p3;
1516:
1517: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_tx_data_pub.split_data_tbl, a0 JTF_NUMBER_TABLE
1518: , a1 JTF_VARCHAR2_TABLE_100
1519: , a2 JTF_VARCHAR2_TABLE_100
1520: , a3 JTF_NUMBER_TABLE
1521: , a4 JTF_NUMBER_TABLE

Line 1544: procedure rosetta_table_copy_out_p5(t cn_get_tx_data_pub.split_data_tbl, a0 out nocopy JTF_NUMBER_TABLE

1540: end loop;
1541: end if;
1542: end if;
1543: end rosetta_table_copy_in_p5;
1544: procedure rosetta_table_copy_out_p5(t cn_get_tx_data_pub.split_data_tbl, a0 out nocopy JTF_NUMBER_TABLE
1545: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1546: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1547: , a3 out nocopy JTF_NUMBER_TABLE
1548: , a4 out nocopy JTF_NUMBER_TABLE

Line 1588: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_tx_data_pub.trx_line_tbl, a0 JTF_NUMBER_TABLE

1584: end if;
1585: end if;
1586: end rosetta_table_copy_out_p5;
1587:
1588: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_tx_data_pub.trx_line_tbl, a0 JTF_NUMBER_TABLE
1589: , a1 JTF_NUMBER_TABLE
1590: , a2 JTF_NUMBER_TABLE
1591: , a3 JTF_VARCHAR2_TABLE_400
1592: , a4 JTF_VARCHAR2_TABLE_100

Line 1645: procedure rosetta_table_copy_out_p7(t cn_get_tx_data_pub.trx_line_tbl, a0 out nocopy JTF_NUMBER_TABLE

1641: end loop;
1642: end if;
1643: end if;
1644: end rosetta_table_copy_in_p7;
1645: procedure rosetta_table_copy_out_p7(t cn_get_tx_data_pub.trx_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
1646: , a1 out nocopy JTF_NUMBER_TABLE
1647: , a2 out nocopy JTF_NUMBER_TABLE
1648: , a3 out nocopy JTF_VARCHAR2_TABLE_400
1649: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1764: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_tx_data_pub.cust_info_tbl, a0 JTF_NUMBER_TABLE

1760: end if;
1761: end if;
1762: end rosetta_table_copy_out_p7;
1763:
1764: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_tx_data_pub.cust_info_tbl, a0 JTF_NUMBER_TABLE
1765: , a1 JTF_VARCHAR2_TABLE_100
1766: , a2 JTF_VARCHAR2_TABLE_300
1767: , a3 JTF_NUMBER_TABLE
1768: , a4 JTF_VARCHAR2_TABLE_300

Line 1827: procedure rosetta_table_copy_out_p9(t cn_get_tx_data_pub.cust_info_tbl, a0 out nocopy JTF_NUMBER_TABLE

1823: end loop;
1824: end if;
1825: end if;
1826: end rosetta_table_copy_in_p9;
1827: procedure rosetta_table_copy_out_p9(t cn_get_tx_data_pub.cust_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
1828: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1829: , a2 out nocopy JTF_VARCHAR2_TABLE_300
1830: , a3 out nocopy JTF_NUMBER_TABLE
1831: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 1961: procedure rosetta_table_copy_in_p11(t out nocopy cn_get_tx_data_pub.attribute_tbl, a0 JTF_VARCHAR2_TABLE_100

1957: end if;
1958: end if;
1959: end rosetta_table_copy_out_p9;
1960:
1961: procedure rosetta_table_copy_in_p11(t out nocopy cn_get_tx_data_pub.attribute_tbl, a0 JTF_VARCHAR2_TABLE_100
1962: , a1 JTF_VARCHAR2_TABLE_100
1963: ) as
1964: ddindx binary_integer; indx binary_integer;
1965: begin

Line 1982: procedure rosetta_table_copy_out_p11(t cn_get_tx_data_pub.attribute_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

1978: end loop;
1979: end if;
1980: end if;
1981: end rosetta_table_copy_in_p11;
1982: procedure rosetta_table_copy_out_p11(t cn_get_tx_data_pub.attribute_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
1983: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1984: ) as
1985: ddindx binary_integer; indx binary_integer;
1986: begin

Line 2206: ddx_adj_tbl cn_get_tx_data_pub.adj_tbl_type;

2202: , p1_a190 out nocopy JTF_VARCHAR2_TABLE_2000
2203: )
2204:
2205: as
2206: ddx_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
2207: ddindx binary_integer; indx binary_integer;
2208: begin
2209:
2210: -- copy data to the local IN or IN-OUT args, if any

Line 2214: cn_get_tx_data_pub.get_api_data(p_comm_lines_api_id,

2210: -- copy data to the local IN or IN-OUT args, if any
2211:
2212:
2213: -- here's the delegated call to the old PL/SQL routine
2214: cn_get_tx_data_pub.get_api_data(p_comm_lines_api_id,
2215: ddx_adj_tbl);
2216:
2217: -- copy data back from the local variables to OUT or IN-OUT args, if any
2218:

Line 2219: cn_get_tx_data_pub_w.rosetta_table_copy_out_p1(ddx_adj_tbl, p1_a0

2215: ddx_adj_tbl);
2216:
2217: -- copy data back from the local variables to OUT or IN-OUT args, if any
2218:
2219: cn_get_tx_data_pub_w.rosetta_table_copy_out_p1(ddx_adj_tbl, p1_a0
2220: , p1_a1
2221: , p1_a2
2222: , p1_a3
2223: , p1_a4

Line 2818: ddp_srch_attr_rec cn_get_tx_data_pub.adj_rec_type;

2814: , x_valid_trx_count out nocopy NUMBER
2815: )
2816:
2817: as
2818: ddp_srch_attr_rec cn_get_tx_data_pub.adj_rec_type;
2819: ddx_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
2820: ddindx binary_integer; indx binary_integer;
2821: begin
2822:

Line 2819: ddx_adj_tbl cn_get_tx_data_pub.adj_tbl_type;

2815: )
2816:
2817: as
2818: ddp_srch_attr_rec cn_get_tx_data_pub.adj_rec_type;
2819: ddx_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
2820: ddindx binary_integer; indx binary_integer;
2821: begin
2822:
2823: -- copy data to the local IN or IN-OUT args, if any

Line 3038: cn_get_tx_data_pub.get_adj(p_api_version,

3034:
3035:
3036:
3037: -- here's the delegated call to the old PL/SQL routine
3038: cn_get_tx_data_pub.get_adj(p_api_version,
3039: p_init_msg_list,
3040: p_validation_level,
3041: p_org_id,
3042: p_salesrep_id,

Line 3081: cn_get_tx_data_pub_w.rosetta_table_copy_out_p1(ddx_adj_tbl, p19_a0

3077:
3078:
3079:
3080:
3081: cn_get_tx_data_pub_w.rosetta_table_copy_out_p1(ddx_adj_tbl, p19_a0
3082: , p19_a1
3083: , p19_a2
3084: , p19_a3
3085: , p19_a4

Line 3481: ddx_adj_tbl cn_get_tx_data_pub.adj_tbl_type;

3477: , x_adj_count out nocopy NUMBER
3478: )
3479:
3480: as
3481: ddx_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
3482: ddindx binary_integer; indx binary_integer;
3483: begin
3484:
3485: -- copy data to the local IN or IN-OUT args, if any

Line 3498: cn_get_tx_data_pub.get_split_data(p_api_version,

3494:
3495:
3496:
3497: -- here's the delegated call to the old PL/SQL routine
3498: cn_get_tx_data_pub.get_split_data(p_api_version,
3499: p_init_msg_list,
3500: p_validation_level,
3501: p_comm_lines_api_id,
3502: p_load_status,

Line 3520: cn_get_tx_data_pub_w.rosetta_table_copy_out_p1(ddx_adj_tbl, p9_a0

3516:
3517:
3518:
3519:
3520: cn_get_tx_data_pub_w.rosetta_table_copy_out_p1(ddx_adj_tbl, p9_a0
3521: , p9_a1
3522: , p9_a2
3523: , p9_a3
3524: , p9_a4

Line 3918: ddp_newtx_rec cn_get_tx_data_pub.adj_rec_type;

3914: , x_loading_status out nocopy VARCHAR2
3915: )
3916:
3917: as
3918: ddp_newtx_rec cn_get_tx_data_pub.adj_rec_type;
3919: ddindx binary_integer; indx binary_integer;
3920: begin
3921:
3922: -- copy data to the local IN or IN-OUT args, if any

Line 4125: cn_get_tx_data_pub.insert_api_record(p_api_version,

4121:
4122:
4123:
4124: -- here's the delegated call to the old PL/SQL routine
4125: cn_get_tx_data_pub.insert_api_record(p_api_version,
4126: p_init_msg_list,
4127: p_validation_level,
4128: p_action,
4129: ddp_newtx_rec,

Line 4550: ddp_srch_attr_rec cn_get_tx_data_pub.adj_rec_type;

4546: , x_loading_status out nocopy VARCHAR2
4547: )
4548:
4549: as
4550: ddp_srch_attr_rec cn_get_tx_data_pub.adj_rec_type;
4551: ddp_adj_rec cn_get_tx_data_pub.adj_rec_type;
4552: ddindx binary_integer; indx binary_integer;
4553: begin
4554:

Line 4551: ddp_adj_rec cn_get_tx_data_pub.adj_rec_type;

4547: )
4548:
4549: as
4550: ddp_srch_attr_rec cn_get_tx_data_pub.adj_rec_type;
4551: ddp_adj_rec cn_get_tx_data_pub.adj_rec_type;
4552: ddindx binary_integer; indx binary_integer;
4553: begin
4554:
4555: -- copy data to the local IN or IN-OUT args, if any

Line 4958: cn_get_tx_data_pub.call_mass_update(p_api_version,

4954:
4955:
4956:
4957: -- here's the delegated call to the old PL/SQL routine
4958: cn_get_tx_data_pub.call_mass_update(p_api_version,
4959: p_init_msg_list,
4960: p_validation_level,
4961: p_org_id,
4962: p_salesrep_id,

Line 5023: ddp_split_data_tbl cn_get_tx_data_pub.split_data_tbl;

5019: , x_loading_status out nocopy VARCHAR2
5020: )
5021:
5022: as
5023: ddp_split_data_tbl cn_get_tx_data_pub.split_data_tbl;
5024: ddindx binary_integer; indx binary_integer;
5025: begin
5026:
5027: -- copy data to the local IN or IN-OUT args, if any

Line 5033: cn_get_tx_data_pub_w.rosetta_table_copy_in_p5(ddp_split_data_tbl, p5_a0

5029:
5030:
5031:
5032:
5033: cn_get_tx_data_pub_w.rosetta_table_copy_in_p5(ddp_split_data_tbl, p5_a0
5034: , p5_a1
5035: , p5_a2
5036: , p5_a3
5037: , p5_a4

Line 5052: cn_get_tx_data_pub.call_split(p_api_version,

5048:
5049:
5050:
5051: -- here's the delegated call to the old PL/SQL routine
5052: cn_get_tx_data_pub.call_split(p_api_version,
5053: p_init_msg_list,
5054: p_validation_level,
5055: p_split_type,
5056: p_from_salesrep_id,

Line 5121: ddx_trx_line_tbl cn_get_tx_data_pub.trx_line_tbl;

5117: , x_tbl_count out nocopy NUMBER
5118: )
5119:
5120: as
5121: ddx_trx_line_tbl cn_get_tx_data_pub.trx_line_tbl;
5122: ddindx binary_integer; indx binary_integer;
5123: begin
5124:
5125: -- copy data to the local IN or IN-OUT args, if any

Line 5137: cn_get_tx_data_pub.get_trx_lines(p_api_version,

5133:
5134:
5135:
5136: -- here's the delegated call to the old PL/SQL routine
5137: cn_get_tx_data_pub.get_trx_lines(p_api_version,
5138: p_init_msg_list,
5139: p_validation_level,
5140: p_header_id,
5141: x_return_status,

Line 5157: cn_get_tx_data_pub_w.rosetta_table_copy_out_p7(ddx_trx_line_tbl, p8_a0

5153:
5154:
5155:
5156:
5157: cn_get_tx_data_pub_w.rosetta_table_copy_out_p7(ddx_trx_line_tbl, p8_a0
5158: , p8_a1
5159: , p8_a2
5160: , p8_a3
5161: , p8_a4

Line 5384: ddx_adj_tbl cn_get_tx_data_pub.adj_tbl_type;

5380: , x_adj_count out nocopy NUMBER
5381: )
5382:
5383: as
5384: ddx_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
5385: ddindx binary_integer; indx binary_integer;
5386: begin
5387:
5388: -- copy data to the local IN or IN-OUT args, if any

Line 5400: cn_get_tx_data_pub.get_trx_history(p_api_version,

5396:
5397:
5398:
5399: -- here's the delegated call to the old PL/SQL routine
5400: cn_get_tx_data_pub.get_trx_history(p_api_version,
5401: p_init_msg_list,
5402: p_validation_level,
5403: p_adj_comm_lines_api_id,
5404: x_return_status,

Line 5420: cn_get_tx_data_pub_w.rosetta_table_copy_out_p1(ddx_adj_tbl, p8_a0

5416:
5417:
5418:
5419:
5420: cn_get_tx_data_pub_w.rosetta_table_copy_out_p1(ddx_adj_tbl, p8_a0
5421: , p8_a1
5422: , p8_a2
5423: , p8_a3
5424: , p8_a4

Line 5650: ddx_cust_info_rec cn_get_tx_data_pub.cust_info_rec;

5646: , p9_a22 out nocopy VARCHAR2
5647: )
5648:
5649: as
5650: ddx_cust_info_rec cn_get_tx_data_pub.cust_info_rec;
5651: ddindx binary_integer; indx binary_integer;
5652: begin
5653:
5654: -- copy data to the local IN or IN-OUT args, if any

Line 5666: cn_get_tx_data_pub.get_cust_info(p_api_version,

5662:
5663:
5664:
5665: -- here's the delegated call to the old PL/SQL routine
5666: cn_get_tx_data_pub.get_cust_info(p_api_version,
5667: p_init_msg_list,
5668: p_validation_level,
5669: p_comm_lines_api_id,
5670: p_load_status,

Line 5914: ddp_newtx_rec cn_get_tx_data_pub.adj_rec_type;

5910: , x_loading_status out nocopy VARCHAR2
5911: )
5912:
5913: as
5914: ddp_newtx_rec cn_get_tx_data_pub.adj_rec_type;
5915: ddindx binary_integer; indx binary_integer;
5916: begin
5917:
5918: -- copy data to the local IN or IN-OUT args, if any

Line 6120: cn_get_tx_data_pub.update_api_record(p_api_version,

6116:
6117:
6118:
6119: -- here's the delegated call to the old PL/SQL routine
6120: cn_get_tx_data_pub.update_api_record(p_api_version,
6121: p_init_msg_list,
6122: p_validation_level,
6123: ddp_newtx_rec,
6124: x_api_id,

Line 6141: end cn_get_tx_data_pub_w;

6137:
6138:
6139: end;
6140:
6141: end cn_get_tx_data_pub_w;