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_COMP_PLAN_PVT_W dependencies on CN_COMP_PLAN_PVT

Line 1: package body cn_comp_plan_pvt_w as

1: package body cn_comp_plan_pvt_w as
2: /* $Header: cnwcmpnb.pls 120.2 2005/09/14 03:38 vensrini noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_comp_plan_pvt_w as
2: /* $Header: cnwcmpnb.pls 120.2 2005/09/14 03:38 vensrini noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_1900
7: , a4 JTF_VARCHAR2_TABLE_100

Line 76: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

72: end loop;
73: end if;
74: end if;
75: end rosetta_table_copy_in_p1;
76: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_VARCHAR2_TABLE_100
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
80: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 235: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE

231: end if;
232: end if;
233: end rosetta_table_copy_out_p1;
234:
235: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE
236: , a1 JTF_NUMBER_TABLE
237: , a2 JTF_NUMBER_TABLE
238: , a3 JTF_VARCHAR2_TABLE_100
239: , a4 JTF_VARCHAR2_TABLE_200

Line 268: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

264: end loop;
265: end if;
266: end if;
267: end rosetta_table_copy_in_p5;
268: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
269: , a1 out nocopy JTF_NUMBER_TABLE
270: , a2 out nocopy JTF_NUMBER_TABLE
271: , a3 out nocopy JTF_VARCHAR2_TABLE_100
272: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 327: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE

323: end if;
324: end if;
325: end rosetta_table_copy_out_p5;
326:
327: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE
328: , a1 JTF_NUMBER_TABLE
329: , a2 JTF_NUMBER_TABLE
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_400

Line 360: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

356: end loop;
357: end if;
358: end if;
359: end rosetta_table_copy_in_p7;
360: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_NUMBER_TABLE
363: , a3 out nocopy JTF_VARCHAR2_TABLE_100
364: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 458: ddp_comp_plan cn_comp_plan_pvt.comp_plan_rec_type;

454: , x_msg_data out nocopy VARCHAR2
455: )
456:
457: as
458: ddp_comp_plan cn_comp_plan_pvt.comp_plan_rec_type;
459: ddindx binary_integer; indx binary_integer;
460: begin
461:
462: -- copy data to the local IN or IN-OUT args, if any

Line 501: cn_comp_plan_pvt.create_comp_plan(p_api_version,

497:
498:
499:
500: -- here's the delegated call to the old PL/SQL routine
501: cn_comp_plan_pvt.create_comp_plan(p_api_version,
502: p_init_msg_list,
503: p_commit,
504: p_validation_level,
505: ddp_comp_plan,

Line 588: ddp_comp_plan cn_comp_plan_pvt.comp_plan_rec_type;

584: , x_msg_data out nocopy VARCHAR2
585: )
586:
587: as
588: ddp_comp_plan cn_comp_plan_pvt.comp_plan_rec_type;
589: ddindx binary_integer; indx binary_integer;
590: begin
591:
592: -- copy data to the local IN or IN-OUT args, if any

Line 630: cn_comp_plan_pvt.update_comp_plan(p_api_version,

626:
627:
628:
629: -- here's the delegated call to the old PL/SQL routine
630: cn_comp_plan_pvt.update_comp_plan(p_api_version,
631: p_init_msg_list,
632: p_commit,
633: p_validation_level,
634: ddp_comp_plan,

Line 715: ddp_comp_plan cn_comp_plan_pvt.comp_plan_rec_type;

711: , x_msg_data out nocopy VARCHAR2
712: )
713:
714: as
715: ddp_comp_plan cn_comp_plan_pvt.comp_plan_rec_type;
716: ddindx binary_integer; indx binary_integer;
717: begin
718:
719: -- copy data to the local IN or IN-OUT args, if any

Line 757: cn_comp_plan_pvt.delete_comp_plan(p_api_version,

753:
754:
755:
756: -- here's the delegated call to the old PL/SQL routine
757: cn_comp_plan_pvt.delete_comp_plan(p_api_version,
758: p_init_msg_list,
759: p_commit,
760: p_validation_level,
761: ddp_comp_plan,

Line 848: ddx_comp_plan cn_comp_plan_pvt.comp_plan_tbl_type;

844: , x_msg_data out nocopy VARCHAR2
845: )
846:
847: as
848: ddx_comp_plan cn_comp_plan_pvt.comp_plan_tbl_type;
849: ddindx binary_integer; indx binary_integer;
850: begin
851:
852: -- copy data to the local IN or IN-OUT args, if any

Line 868: cn_comp_plan_pvt.get_comp_plan_sum(p_api_version,

864:
865:
866:
867: -- here's the delegated call to the old PL/SQL routine
868: cn_comp_plan_pvt.get_comp_plan_sum(p_api_version,
869: p_init_msg_list,
870: p_commit,
871: p_validation_level,
872: p_start_record,

Line 893: cn_comp_plan_pvt_w.rosetta_table_copy_out_p1(ddx_comp_plan, p9_a0

889:
890:
891:
892:
893: cn_comp_plan_pvt_w.rosetta_table_copy_out_p1(ddx_comp_plan, p9_a0
894: , p9_a1
895: , p9_a2
896: , p9_a3
897: , p9_a4

Line 967: ddx_comp_plan cn_comp_plan_pvt.comp_plan_tbl_type;

963: , x_msg_data out nocopy VARCHAR2
964: )
965:
966: as
967: ddx_comp_plan cn_comp_plan_pvt.comp_plan_tbl_type;
968: ddindx binary_integer; indx binary_integer;
969: begin
970:
971: -- copy data to the local IN or IN-OUT args, if any

Line 982: cn_comp_plan_pvt.get_comp_plan_dtl(p_api_version,

978:
979:
980:
981: -- here's the delegated call to the old PL/SQL routine
982: cn_comp_plan_pvt.get_comp_plan_dtl(p_api_version,
983: p_init_msg_list,
984: p_commit,
985: p_validation_level,
986: p_comp_plan_id,

Line 998: cn_comp_plan_pvt_w.rosetta_table_copy_out_p1(ddx_comp_plan, p5_a0

994:
995:
996:
997:
998: cn_comp_plan_pvt_w.rosetta_table_copy_out_p1(ddx_comp_plan, p5_a0
999: , p5_a1
1000: , p5_a2
1001: , p5_a3
1002: , p5_a4

Line 1051: ddx_sales_role cn_comp_plan_pvt.sales_role_tbl_type;

1047: , x_msg_data out nocopy VARCHAR2
1048: )
1049:
1050: as
1051: ddx_sales_role cn_comp_plan_pvt.sales_role_tbl_type;
1052: ddindx binary_integer; indx binary_integer;
1053: begin
1054:
1055: -- copy data to the local IN or IN-OUT args, if any

Line 1066: cn_comp_plan_pvt.get_sales_role(p_api_version,

1062:
1063:
1064:
1065: -- here's the delegated call to the old PL/SQL routine
1066: cn_comp_plan_pvt.get_sales_role(p_api_version,
1067: p_init_msg_list,
1068: p_commit,
1069: p_validation_level,
1070: p_comp_plan_id,

Line 1082: cn_comp_plan_pvt_w.rosetta_table_copy_out_p5(ddx_sales_role, p5_a0

1078:
1079:
1080:
1081:
1082: cn_comp_plan_pvt_w.rosetta_table_copy_out_p5(ddx_sales_role, p5_a0
1083: , p5_a1
1084: , p5_a2
1085: , p5_a3
1086: , p5_a4

Line 1134: ddp_comp_plan cn_comp_plan_pvt.comp_plan_rec_type;

1130: , x_msg_data out nocopy VARCHAR2
1131: )
1132:
1133: as
1134: ddp_comp_plan cn_comp_plan_pvt.comp_plan_rec_type;
1135: ddindx binary_integer; indx binary_integer;
1136: begin
1137:
1138: -- copy data to the local IN or IN-OUT args, if any

Line 1176: cn_comp_plan_pvt.validate_comp_plan(p_api_version,

1172:
1173:
1174:
1175: -- here's the delegated call to the old PL/SQL routine
1176: cn_comp_plan_pvt.validate_comp_plan(p_api_version,
1177: p_init_msg_list,
1178: p_commit,
1179: p_validation_level,
1180: ddp_comp_plan,

Line 1210: ddx_result_tbl cn_comp_plan_pvt.srp_plan_assign_tbl_type;

1206: , p4_a7 out nocopy JTF_DATE_TABLE
1207: )
1208:
1209: as
1210: ddx_result_tbl cn_comp_plan_pvt.srp_plan_assign_tbl_type;
1211: ddindx binary_integer; indx binary_integer;
1212: begin
1213:
1214: -- copy data to the local IN or IN-OUT args, if any

Line 1221: cn_comp_plan_pvt.get_assigned_salesreps(p_comp_plan_id,

1217:
1218:
1219:
1220: -- here's the delegated call to the old PL/SQL routine
1221: cn_comp_plan_pvt.get_assigned_salesreps(p_comp_plan_id,
1222: p_range_low,
1223: p_range_high,
1224: x_total_rows,
1225: ddx_result_tbl);

Line 1232: cn_comp_plan_pvt_w.rosetta_table_copy_out_p7(ddx_result_tbl, p4_a0

1228:
1229:
1230:
1231:
1232: cn_comp_plan_pvt_w.rosetta_table_copy_out_p7(ddx_result_tbl, p4_a0
1233: , p4_a1
1234: , p4_a2
1235: , p4_a3
1236: , p4_a4

Line 1243: end cn_comp_plan_pvt_w;

1239: , p4_a7
1240: );
1241: end;
1242:
1243: end cn_comp_plan_pvt_w;