DBA Data[Home] [Help]

APPS.CN_GET_COMM_SUMM_DATA_PVT_W dependencies on CN_GET_COMM_SUMM_DATA_PVT_W

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 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 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 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 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 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 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 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 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 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 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 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 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 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;