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_COMM_SUMM_DATA_PVT_W dependencies on CN_GET_COMM_SUMM_DATA_PVT

Line 1: package body cn_get_comm_summ_data_pvt_w as

1: package body cn_get_comm_summ_data_pvt_w as
2: /* $Header: cnwcommb.pls 120.4 2005/10/24 07:22 sjustina noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_comm_summ_data_pvt.comm_summ_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_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_get_comm_summ_data_pvt_w as
2: /* $Header: cnwcommb.pls 120.4 2005/10/24 07:22 sjustina noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE

Line 36: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

32: end loop;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_100
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_DATE_TABLE
40: , a4 out nocopy JTF_DATE_TABLE

Line 95: procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE) as

91: end if;
92: end if;
93: end rosetta_table_copy_out_p1;
94:
95: procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE) as
96: ddindx binary_integer; indx binary_integer;
97: begin
98: if a0 is not null and a0.count > 0 then
99: if a0.count > 0 then

Line 113: procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

109: end loop;
110: end if;
111: end if;
112: end rosetta_table_copy_in_p2;
113: procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
114: ddindx binary_integer; indx binary_integer;
115: begin
116: if t is null or t.count = 0 then
117: a0 := JTF_NUMBER_TABLE();

Line 136: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

132: end if;
133: end if;
134: end rosetta_table_copy_out_p2;
135:
136: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
137: ddindx binary_integer; indx binary_integer;
138: begin
139: if a0 is not null and a0.count > 0 then
140: if a0.count > 0 then

Line 154: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

150: end loop;
151: end if;
152: end if;
153: end rosetta_table_copy_in_p3;
154: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
155: ddindx binary_integer; indx binary_integer;
156: begin
157: if t is null or t.count = 0 then
158: a0 := JTF_VARCHAR2_TABLE_100();

Line 177: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE

173: end if;
174: end if;
175: end rosetta_table_copy_out_p3;
176:
177: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE
178: , a1 JTF_VARCHAR2_TABLE_100
179: , a2 JTF_NUMBER_TABLE
180: , a3 JTF_NUMBER_TABLE
181: , a4 JTF_NUMBER_TABLE

Line 218: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

214: end loop;
215: end if;
216: end if;
217: end rosetta_table_copy_in_p5;
218: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
219: , a1 out nocopy JTF_VARCHAR2_TABLE_100
220: , a2 out nocopy JTF_NUMBER_TABLE
221: , a3 out nocopy JTF_NUMBER_TABLE
222: , a4 out nocopy JTF_NUMBER_TABLE

Line 297: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400

293: end if;
294: end if;
295: end rosetta_table_copy_out_p5;
296:
297: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400
298: , a1 JTF_VARCHAR2_TABLE_100
299: , a2 JTF_VARCHAR2_TABLE_100
300: , a3 JTF_VARCHAR2_TABLE_100
301: , a4 JTF_VARCHAR2_TABLE_100

Line 326: procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400

322: end loop;
323: end if;
324: end if;
325: end rosetta_table_copy_in_p7;
326: procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
327: , a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , a3 out nocopy JTF_VARCHAR2_TABLE_100
330: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 375: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE

371: end if;
372: end if;
373: end rosetta_table_copy_out_p7;
374:
375: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE
376: , a1 JTF_NUMBER_TABLE
377: ) as
378: ddindx binary_integer; indx binary_integer;
379: begin

Line 396: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

392: end loop;
393: end if;
394: end if;
395: end rosetta_table_copy_in_p9;
396: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: ) as
399: ddindx binary_integer; indx binary_integer;
400: begin

Line 435: ddx_salesrep_tbl cn_get_comm_summ_data_pvt.salesrep_tbl_type;

431: , x_salesrep_tbl out nocopy JTF_NUMBER_TABLE
432: )
433:
434: as
435: ddx_salesrep_tbl cn_get_comm_summ_data_pvt.salesrep_tbl_type;
436: ddindx binary_integer; indx binary_integer;
437: begin
438:
439: -- copy data to the local IN or IN-OUT args, if any

Line 448: cn_get_comm_summ_data_pvt.get_salesrep_list(p_first,

444:
445:
446:
447: -- here's the delegated call to the old PL/SQL routine
448: cn_get_comm_summ_data_pvt.get_salesrep_list(p_first,
449: p_last,
450: p_period_id,
451: p_analyst_id,
452: p_org_id,

Line 463: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p2(ddx_salesrep_tbl, x_salesrep_tbl);

459:
460:
461:
462:
463: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p2(ddx_salesrep_tbl, x_salesrep_tbl);
464: end;
465:
466: procedure get_quota_summary(p_salesrep_id NUMBER
467: , p_period_id NUMBER

Line 481: ddx_result_tbl cn_get_comm_summ_data_pvt.comm_summ_tbl_type;

477: , p4_a7 out nocopy JTF_NUMBER_TABLE
478: )
479:
480: as
481: ddx_result_tbl cn_get_comm_summ_data_pvt.comm_summ_tbl_type;
482: ddindx binary_integer; indx binary_integer;
483: begin
484:
485: -- copy data to the local IN or IN-OUT args, if any

Line 492: cn_get_comm_summ_data_pvt.get_quota_summary(p_salesrep_id,

488:
489:
490:
491: -- here's the delegated call to the old PL/SQL routine
492: cn_get_comm_summ_data_pvt.get_quota_summary(p_salesrep_id,
493: p_period_id,
494: p_credit_type_id,
495: p_org_id,
496: ddx_result_tbl);

Line 503: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p4_a0

499:
500:
501:
502:
503: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p4_a0
504: , p4_a1
505: , p4_a2
506: , p4_a3
507: , p4_a4

Line 528: ddx_result_tbl cn_get_comm_summ_data_pvt.comm_summ_tbl_type;

524: , p3_a7 out nocopy JTF_NUMBER_TABLE
525: )
526:
527: as
528: ddx_result_tbl cn_get_comm_summ_data_pvt.comm_summ_tbl_type;
529: ddindx binary_integer; indx binary_integer;
530: begin
531:
532: -- copy data to the local IN or IN-OUT args, if any

Line 538: cn_get_comm_summ_data_pvt.get_quota_manager_summary(p_period_id,

534:
535:
536:
537: -- here's the delegated call to the old PL/SQL routine
538: cn_get_comm_summ_data_pvt.get_quota_manager_summary(p_period_id,
539: p_credit_type_id,
540: p_org_id,
541: ddx_result_tbl);
542:

Line 547: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p3_a0

543: -- copy data back from the local variables to OUT or IN-OUT args, if any
544:
545:
546:
547: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p3_a0
548: , p3_a1
549: , p3_a2
550: , p3_a3
551: , p3_a4

Line 573: ddx_result_tbl cn_get_comm_summ_data_pvt.comm_summ_tbl_type;

569: , p4_a7 out nocopy JTF_NUMBER_TABLE
570: )
571:
572: as
573: ddx_result_tbl cn_get_comm_summ_data_pvt.comm_summ_tbl_type;
574: ddindx binary_integer; indx binary_integer;
575: begin
576:
577: -- copy data to the local IN or IN-OUT args, if any

Line 584: cn_get_comm_summ_data_pvt.get_quota_analyst_summary(p_period_id,

580:
581:
582:
583: -- here's the delegated call to the old PL/SQL routine
584: cn_get_comm_summ_data_pvt.get_quota_analyst_summary(p_period_id,
585: p_credit_type_id,
586: p_org_id,
587: p_analyst_id,
588: ddx_result_tbl);

Line 595: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p4_a0

591:
592:
593:
594:
595: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p1(ddx_result_tbl, p4_a0
596: , p4_a1
597: , p4_a2
598: , p4_a3
599: , p4_a4

Line 625: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_info_tbl_type;

621: , p4_a11 out nocopy JTF_NUMBER_TABLE
622: )
623:
624: as
625: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_info_tbl_type;
626: ddindx binary_integer; indx binary_integer;
627: begin
628:
629: -- copy data to the local IN or IN-OUT args, if any

Line 636: cn_get_comm_summ_data_pvt.get_salesrep_pe_info(p_salesrep_id,

632:
633:
634:
635: -- here's the delegated call to the old PL/SQL routine
636: cn_get_comm_summ_data_pvt.get_salesrep_pe_info(p_salesrep_id,
637: p_period_id,
638: p_credit_type_id,
639: p_org_id,
640: ddx_result_tbl);

Line 647: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p5(ddx_result_tbl, p4_a0

643:
644:
645:
646:
647: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p5(ddx_result_tbl, p4_a0
648: , p4_a1
649: , p4_a2
650: , p4_a3
651: , p4_a4

Line 680: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_info_tbl_type;

676: , p3_a11 out nocopy JTF_NUMBER_TABLE
677: )
678:
679: as
680: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_info_tbl_type;
681: ddindx binary_integer; indx binary_integer;
682: begin
683:
684: -- copy data to the local IN or IN-OUT args, if any

Line 690: cn_get_comm_summ_data_pvt.get_manager_pe_info(p_period_id,

686:
687:
688:
689: -- here's the delegated call to the old PL/SQL routine
690: cn_get_comm_summ_data_pvt.get_manager_pe_info(p_period_id,
691: p_credit_type_id,
692: p_org_id,
693: ddx_result_tbl);
694:

Line 699: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p5(ddx_result_tbl, p3_a0

695: -- copy data back from the local variables to OUT or IN-OUT args, if any
696:
697:
698:
699: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p5(ddx_result_tbl, p3_a0
700: , p3_a1
701: , p3_a2
702: , p3_a3
703: , p3_a4

Line 733: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_info_tbl_type;

729: , p4_a11 out nocopy JTF_NUMBER_TABLE
730: )
731:
732: as
733: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_info_tbl_type;
734: ddindx binary_integer; indx binary_integer;
735: begin
736:
737: -- copy data to the local IN or IN-OUT args, if any

Line 744: cn_get_comm_summ_data_pvt.get_analyst_pe_info(p_period_id,

740:
741:
742:
743: -- here's the delegated call to the old PL/SQL routine
744: cn_get_comm_summ_data_pvt.get_analyst_pe_info(p_period_id,
745: p_credit_type_id,
746: p_org_id,
747: p_analyst_id,
748: ddx_result_tbl);

Line 755: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p5(ddx_result_tbl, p4_a0

751:
752:
753:
754:
755: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p5(ddx_result_tbl, p4_a0
756: , p4_a1
757: , p4_a2
758: , p4_a3
759: , p4_a4

Line 781: ddx_result_tbl cn_get_comm_summ_data_pvt.salesrep_info_tbl_type;

777: , p2_a5 out nocopy JTF_NUMBER_TABLE
778: )
779:
780: as
781: ddx_result_tbl cn_get_comm_summ_data_pvt.salesrep_info_tbl_type;
782: ddindx binary_integer; indx binary_integer;
783: begin
784:
785: -- copy data to the local IN or IN-OUT args, if any

Line 790: cn_get_comm_summ_data_pvt.get_salesrep_details(p_salesrep_id,

786:
787:
788:
789: -- here's the delegated call to the old PL/SQL routine
790: cn_get_comm_summ_data_pvt.get_salesrep_details(p_salesrep_id,
791: p_org_id,
792: ddx_result_tbl);
793:
794: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 797: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p7(ddx_result_tbl, p2_a0

793:
794: -- copy data back from the local variables to OUT or IN-OUT args, if any
795:
796:
797: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p7(ddx_result_tbl, p2_a0
798: , p2_a1
799: , p2_a2
800: , p2_a3
801: , p2_a4

Line 816: ddx_result_tbl cn_get_comm_summ_data_pvt.salesrep_info_tbl_type;

812: , p1_a5 out nocopy JTF_NUMBER_TABLE
813: )
814:
815: as
816: ddx_result_tbl cn_get_comm_summ_data_pvt.salesrep_info_tbl_type;
817: ddindx binary_integer; indx binary_integer;
818: begin
819:
820: -- copy data to the local IN or IN-OUT args, if any

Line 824: cn_get_comm_summ_data_pvt.get_manager_details(p_org_id,

820: -- copy data to the local IN or IN-OUT args, if any
821:
822:
823: -- here's the delegated call to the old PL/SQL routine
824: cn_get_comm_summ_data_pvt.get_manager_details(p_org_id,
825: ddx_result_tbl);
826:
827: -- copy data back from the local variables to OUT or IN-OUT args, if any
828:

Line 829: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p7(ddx_result_tbl, p1_a0

825: ddx_result_tbl);
826:
827: -- copy data back from the local variables to OUT or IN-OUT args, if any
828:
829: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p7(ddx_result_tbl, p1_a0
830: , p1_a1
831: , p1_a2
832: , p1_a3
833: , p1_a4

Line 849: ddx_result_tbl cn_get_comm_summ_data_pvt.salesrep_info_tbl_type;

845: , p2_a5 out nocopy JTF_NUMBER_TABLE
846: )
847:
848: as
849: ddx_result_tbl cn_get_comm_summ_data_pvt.salesrep_info_tbl_type;
850: ddindx binary_integer; indx binary_integer;
851: begin
852:
853: -- copy data to the local IN or IN-OUT args, if any

Line 858: cn_get_comm_summ_data_pvt.get_analyst_details(p_org_id,

854:
855:
856:
857: -- here's the delegated call to the old PL/SQL routine
858: cn_get_comm_summ_data_pvt.get_analyst_details(p_org_id,
859: p_analyst_id,
860: ddx_result_tbl);
861:
862: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 865: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p7(ddx_result_tbl, p2_a0

861:
862: -- copy data back from the local variables to OUT or IN-OUT args, if any
863:
864:
865: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p7(ddx_result_tbl, p2_a0
866: , p2_a1
867: , p2_a2
868: , p2_a3
869: , p2_a4

Line 879: ddx_result_tbl cn_get_comm_summ_data_pvt.group_code_tbl_type;

875: , x_result_tbl out nocopy JTF_VARCHAR2_TABLE_100
876: )
877:
878: as
879: ddx_result_tbl cn_get_comm_summ_data_pvt.group_code_tbl_type;
880: ddindx binary_integer; indx binary_integer;
881: begin
882:
883: -- copy data to the local IN or IN-OUT args, if any

Line 887: cn_get_comm_summ_data_pvt.get_group_codes(p_org_id,

883: -- copy data to the local IN or IN-OUT args, if any
884:
885:
886: -- here's the delegated call to the old PL/SQL routine
887: cn_get_comm_summ_data_pvt.get_group_codes(p_org_id,
888: ddx_result_tbl);
889:
890: -- copy data back from the local variables to OUT or IN-OUT args, if any
891:

Line 892: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p3(ddx_result_tbl, x_result_tbl);

888: ddx_result_tbl);
889:
890: -- copy data back from the local variables to OUT or IN-OUT args, if any
891:
892: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p3(ddx_result_tbl, x_result_tbl);
893: end;
894:
895: procedure get_ptd_credit(p_salesrep_id NUMBER
896: , p_payrun_id NUMBER

Line 903: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type;

899: , p3_a1 in out nocopy JTF_NUMBER_TABLE
900: )
901:
902: as
903: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type;
904: ddindx binary_integer; indx binary_integer;
905: begin
906:
907: -- copy data to the local IN or IN-OUT args, if any

Line 911: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_in_p9(ddx_result_tbl, p3_a0

907: -- copy data to the local IN or IN-OUT args, if any
908:
909:
910:
911: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_in_p9(ddx_result_tbl, p3_a0
912: , p3_a1
913: );
914:
915: -- here's the delegated call to the old PL/SQL routine

Line 916: cn_get_comm_summ_data_pvt.get_ptd_credit(p_salesrep_id,

912: , p3_a1
913: );
914:
915: -- here's the delegated call to the old PL/SQL routine
916: cn_get_comm_summ_data_pvt.get_ptd_credit(p_salesrep_id,
917: p_payrun_id,
918: p_org_id,
919: ddx_result_tbl);
920:

Line 925: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p9(ddx_result_tbl, p3_a0

921: -- copy data back from the local variables to OUT or IN-OUT args, if any
922:
923:
924:
925: cn_get_comm_summ_data_pvt_w.rosetta_table_copy_out_p9(ddx_result_tbl, p3_a0
926: , p3_a1
927: );
928: end;
929:

Line 930: end cn_get_comm_summ_data_pvt_w;

926: , p3_a1
927: );
928: end;
929:
930: end cn_get_comm_summ_data_pvt_w;