DBA Data[Home] [Help]

APPS.CS_TP_TEMPLATES_PVT_W dependencies on CS_TP_TEMPLATES_PVT

Line 1: package body cs_tp_templates_pvt_w as

1: package body cs_tp_templates_pvt_w as
2: /* $Header: cstprtmb.pls 120.2 2005/06/30 11:07 appldev ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_templates_pvt.template_list, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_templates_pvt.template_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_1000
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100

Line 57: procedure rosetta_table_copy_out_p1(t cs_tp_templates_pvt.template_list, a0 out nocopy JTF_NUMBER_TABLE

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t cs_tp_templates_pvt.template_list, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
59: , a2 out nocopy JTF_VARCHAR2_TABLE_200
60: , a3 out nocopy JTF_VARCHAR2_TABLE_200
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 121: procedure rosetta_table_copy_in_p3(t out nocopy cs_tp_templates_pvt.template_attribute_list, a0 JTF_NUMBER_TABLE

117: end if;
118: end if;
119: end rosetta_table_copy_out_p1;
120:
121: procedure rosetta_table_copy_in_p3(t out nocopy cs_tp_templates_pvt.template_attribute_list, a0 JTF_NUMBER_TABLE
122: , a1 JTF_VARCHAR2_TABLE_1000
123: , a2 JTF_NUMBER_TABLE
124: , a3 JTF_NUMBER_TABLE
125: , a4 JTF_VARCHAR2_TABLE_200

Line 154: procedure rosetta_table_copy_out_p3(t cs_tp_templates_pvt.template_attribute_list, a0 out nocopy JTF_NUMBER_TABLE

150: end loop;
151: end if;
152: end if;
153: end rosetta_table_copy_in_p3;
154: procedure rosetta_table_copy_out_p3(t cs_tp_templates_pvt.template_attribute_list, a0 out nocopy JTF_NUMBER_TABLE
155: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
156: , a2 out nocopy JTF_NUMBER_TABLE
157: , a3 out nocopy JTF_NUMBER_TABLE
158: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 213: procedure rosetta_table_copy_in_p5(t out nocopy cs_tp_templates_pvt.template_link_list, a0 JTF_NUMBER_TABLE

209: end if;
210: end if;
211: end rosetta_table_copy_out_p3;
212:
213: procedure rosetta_table_copy_in_p5(t out nocopy cs_tp_templates_pvt.template_link_list, a0 JTF_NUMBER_TABLE
214: , a1 JTF_VARCHAR2_TABLE_1000
215: , a2 JTF_VARCHAR2_TABLE_1000
216: , a3 JTF_VARCHAR2_TABLE_200
217: , a4 JTF_NUMBER_TABLE

Line 246: procedure rosetta_table_copy_out_p5(t cs_tp_templates_pvt.template_link_list, a0 out nocopy JTF_NUMBER_TABLE

242: end loop;
243: end if;
244: end if;
245: end rosetta_table_copy_in_p5;
246: procedure rosetta_table_copy_out_p5(t cs_tp_templates_pvt.template_link_list, a0 out nocopy JTF_NUMBER_TABLE
247: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
248: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
249: , a3 out nocopy JTF_VARCHAR2_TABLE_200
250: , a4 out nocopy JTF_NUMBER_TABLE

Line 305: procedure rosetta_table_copy_in_p7(t out nocopy cs_tp_templates_pvt.id_name_pairs, a0 JTF_VARCHAR2_TABLE_1000

301: end if;
302: end if;
303: end rosetta_table_copy_out_p5;
304:
305: procedure rosetta_table_copy_in_p7(t out nocopy cs_tp_templates_pvt.id_name_pairs, a0 JTF_VARCHAR2_TABLE_1000
306: , a1 JTF_VARCHAR2_TABLE_1000
307: ) as
308: ddindx binary_integer; indx binary_integer;
309: begin

Line 326: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000

322: end loop;
323: end if;
324: end if;
325: end rosetta_table_copy_in_p7;
326: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000
327: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
328: ) as
329: ddindx binary_integer; indx binary_integer;
330: begin

Line 355: procedure rosetta_table_copy_in_p9(t out nocopy cs_tp_templates_pvt.object_other_id_pairs, a0 JTF_NUMBER_TABLE

351: end if;
352: end if;
353: end rosetta_table_copy_out_p7;
354:
355: procedure rosetta_table_copy_in_p9(t out nocopy cs_tp_templates_pvt.object_other_id_pairs, a0 JTF_NUMBER_TABLE
356: , a1 JTF_VARCHAR2_TABLE_100
357: , a2 JTF_VARCHAR2_TABLE_1000
358: ) as
359: ddindx binary_integer; indx binary_integer;

Line 378: procedure rosetta_table_copy_out_p9(t cs_tp_templates_pvt.object_other_id_pairs, a0 out nocopy JTF_NUMBER_TABLE

374: end loop;
375: end if;
376: end if;
377: end rosetta_table_copy_in_p9;
378: procedure rosetta_table_copy_out_p9(t cs_tp_templates_pvt.object_other_id_pairs, a0 out nocopy JTF_NUMBER_TABLE
379: , a1 out nocopy JTF_VARCHAR2_TABLE_100
380: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
381: ) as
382: ddindx binary_integer; indx binary_integer;

Line 431: ddp_one_template cs_tp_templates_pvt.template;

427: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
428: )
429:
430: as
431: ddp_one_template cs_tp_templates_pvt.template;
432: ddindx binary_integer; indx binary_integer;
433: begin
434:
435: -- copy data to the local IN or IN-OUT args, if any

Line 454: cs_tp_templates_pvt.add_template(p_api_version_number,

450:
451:
452:
453: -- here's the delegated call to the old PL/SQL routine
454: cs_tp_templates_pvt.add_template(p_api_version_number,
455: p_init_msg_list,
456: p_commit,
457: ddp_one_template,
458: x_msg_count,

Line 491: ddp_one_template cs_tp_templates_pvt.template;

487: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
488: )
489:
490: as
491: ddp_one_template cs_tp_templates_pvt.template;
492: ddindx binary_integer; indx binary_integer;
493: begin
494:
495: -- copy data to the local IN or IN-OUT args, if any

Line 513: cs_tp_templates_pvt.update_template(p_api_version_number,

509:
510:
511:
512: -- here's the delegated call to the old PL/SQL routine
513: cs_tp_templates_pvt.update_template(p_api_version_number,
514: p_init_msg_list,
515: p_commit,
516: ddp_one_template,
517: x_msg_count,

Line 548: ddp_template_attributes cs_tp_templates_pvt.template_attribute_list;

544: , x_return_status out nocopy VARCHAR2
545: )
546:
547: as
548: ddp_template_attributes cs_tp_templates_pvt.template_attribute_list;
549: ddindx binary_integer; indx binary_integer;
550: begin
551:
552: -- copy data to the local IN or IN-OUT args, if any

Line 557: cs_tp_templates_pvt_w.rosetta_table_copy_in_p3(ddp_template_attributes, p4_a0

553:
554:
555:
556:
557: cs_tp_templates_pvt_w.rosetta_table_copy_in_p3(ddp_template_attributes, p4_a0
558: , p4_a1
559: , p4_a2
560: , p4_a3
561: , p4_a4

Line 571: cs_tp_templates_pvt.update_template_attributes(p_api_version_number,

567:
568:
569:
570: -- here's the delegated call to the old PL/SQL routine
571: cs_tp_templates_pvt.update_template_attributes(p_api_version_number,
572: p_init_msg_list,
573: p_commit,
574: p_template_id,
575: ddp_template_attributes,

Line 609: ddp_template_links cs_tp_templates_pvt.template_link_list;

605: , x_return_status out nocopy VARCHAR2
606: )
607:
608: as
609: ddp_template_links cs_tp_templates_pvt.template_link_list;
610: ddindx binary_integer; indx binary_integer;
611: begin
612:
613: -- copy data to the local IN or IN-OUT args, if any

Line 619: cs_tp_templates_pvt_w.rosetta_table_copy_in_p5(ddp_template_links, p5_a0

615:
616:
617:
618:
619: cs_tp_templates_pvt_w.rosetta_table_copy_in_p5(ddp_template_links, p5_a0
620: , p5_a1
621: , p5_a2
622: , p5_a3
623: , p5_a4

Line 633: cs_tp_templates_pvt.update_template_links(p_api_version_number,

629:
630:
631:
632: -- here's the delegated call to the old PL/SQL routine
633: cs_tp_templates_pvt.update_template_links(p_api_version_number,
634: p_init_msg_list,
635: p_commit,
636: p_template_id,
637: p_jtf_object_code,

Line 678: ddx_template_list_to_show cs_tp_templates_pvt.template_list;

674: , x_retrieved_template_num out nocopy NUMBER
675: )
676:
677: as
678: ddx_template_list_to_show cs_tp_templates_pvt.template_list;
679: ddindx binary_integer; indx binary_integer;
680: begin
681:
682: -- copy data to the local IN or IN-OUT args, if any

Line 697: cs_tp_templates_pvt.show_templates(p_api_version_number,

693:
694:
695:
696: -- here's the delegated call to the old PL/SQL routine
697: cs_tp_templates_pvt.show_templates(p_api_version_number,
698: p_init_msg_list,
699: p_commit,
700: p_template_name,
701: p_start_template,

Line 722: cs_tp_templates_pvt_w.rosetta_table_copy_out_p1(ddx_template_list_to_show, p10_a0

718:
719:
720:
721:
722: cs_tp_templates_pvt_w.rosetta_table_copy_out_p1(ddx_template_list_to_show, p10_a0
723: , p10_a1
724: , p10_a2
725: , p10_a3
726: , p10_a4

Line 755: ddx_template_to_show cs_tp_templates_pvt.template;

751: , p7_a8 out nocopy VARCHAR2
752: )
753:
754: as
755: ddx_template_to_show cs_tp_templates_pvt.template;
756: ddindx binary_integer; indx binary_integer;
757: begin
758:
759: -- copy data to the local IN or IN-OUT args, if any

Line 769: cs_tp_templates_pvt.show_template(p_api_version_number,

765:
766:
767:
768: -- here's the delegated call to the old PL/SQL routine
769: cs_tp_templates_pvt.show_template(p_api_version_number,
770: p_init_msg_list,
771: p_commit,
772: p_template_id,
773: x_msg_count,

Line 818: ddp_object_other_list cs_tp_templates_pvt.object_other_id_pairs;

814: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
815: )
816:
817: as
818: ddp_object_other_list cs_tp_templates_pvt.object_other_id_pairs;
819: ddx_template_list cs_tp_templates_pvt.template_list;
820: ddindx binary_integer; indx binary_integer;
821: begin
822:

Line 819: ddx_template_list cs_tp_templates_pvt.template_list;

815: )
816:
817: as
818: ddp_object_other_list cs_tp_templates_pvt.object_other_id_pairs;
819: ddx_template_list cs_tp_templates_pvt.template_list;
820: ddindx binary_integer; indx binary_integer;
821: begin
822:
823: -- copy data to the local IN or IN-OUT args, if any

Line 827: cs_tp_templates_pvt_w.rosetta_table_copy_in_p9(ddp_object_other_list, p3_a0

823: -- copy data to the local IN or IN-OUT args, if any
824:
825:
826:
827: cs_tp_templates_pvt_w.rosetta_table_copy_in_p9(ddp_object_other_list, p3_a0
828: , p3_a1
829: , p3_a2
830: );
831:

Line 837: cs_tp_templates_pvt.show_templates_with_link(p_api_version_number,

833:
834:
835:
836: -- here's the delegated call to the old PL/SQL routine
837: cs_tp_templates_pvt.show_templates_with_link(p_api_version_number,
838: p_init_msg_list,
839: p_commit,
840: ddp_object_other_list,
841: x_msg_count,

Line 854: cs_tp_templates_pvt_w.rosetta_table_copy_out_p1(ddx_template_list, p7_a0

850:
851:
852:
853:
854: cs_tp_templates_pvt_w.rosetta_table_copy_out_p1(ddx_template_list, p7_a0
855: , p7_a1
856: , p7_a2
857: , p7_a3
858: , p7_a4

Line 885: ddx_template_attributes cs_tp_templates_pvt.template_attribute_list;

881: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
882: )
883:
884: as
885: ddx_template_attributes cs_tp_templates_pvt.template_attribute_list;
886: ddindx binary_integer; indx binary_integer;
887: begin
888:
889: -- copy data to the local IN or IN-OUT args, if any

Line 900: cs_tp_templates_pvt.show_template_attributes(p_api_version_number,

896:
897:
898:
899: -- here's the delegated call to the old PL/SQL routine
900: cs_tp_templates_pvt.show_template_attributes(p_api_version_number,
901: p_init_msg_list,
902: p_commit,
903: p_template_id,
904: p_jtf_object_code,

Line 919: cs_tp_templates_pvt_w.rosetta_table_copy_out_p3(ddx_template_attributes, p8_a0

915:
916:
917:
918:
919: cs_tp_templates_pvt_w.rosetta_table_copy_out_p3(ddx_template_attributes, p8_a0
920: , p8_a1
921: , p8_a2
922: , p8_a3
923: , p8_a4

Line 949: ddx_template_links cs_tp_templates_pvt.template_link_list;

945: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
946: )
947:
948: as
949: ddx_template_links cs_tp_templates_pvt.template_link_list;
950: ddindx binary_integer; indx binary_integer;
951: begin
952:
953: -- copy data to the local IN or IN-OUT args, if any

Line 964: cs_tp_templates_pvt.show_template_links(p_api_version_number,

960:
961:
962:
963: -- here's the delegated call to the old PL/SQL routine
964: cs_tp_templates_pvt.show_template_links(p_api_version_number,
965: p_init_msg_list,
966: p_commit,
967: p_template_id,
968: p_jtf_object_code,

Line 983: cs_tp_templates_pvt_w.rosetta_table_copy_out_p5(ddx_template_links, p8_a0

979:
980:
981:
982:
983: cs_tp_templates_pvt_w.rosetta_table_copy_out_p5(ddx_template_links, p8_a0
984: , p8_a1
985: , p8_a2
986: , p8_a3
987: , p8_a4

Line 1013: ddx_template_link_list cs_tp_templates_pvt.template_link_list;

1009: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
1010: )
1011:
1012: as
1013: ddx_template_link_list cs_tp_templates_pvt.template_link_list;
1014: ddindx binary_integer; indx binary_integer;
1015: begin
1016:
1017: -- copy data to the local IN or IN-OUT args, if any

Line 1028: cs_tp_templates_pvt.show_non_asso_links(p_api_version_number,

1024:
1025:
1026:
1027: -- here's the delegated call to the old PL/SQL routine
1028: cs_tp_templates_pvt.show_non_asso_links(p_api_version_number,
1029: p_init_msg_list,
1030: p_commit,
1031: p_template_id,
1032: p_jtf_object_code,

Line 1047: cs_tp_templates_pvt_w.rosetta_table_copy_out_p5(ddx_template_link_list, p8_a0

1043:
1044:
1045:
1046:
1047: cs_tp_templates_pvt_w.rosetta_table_copy_out_p5(ddx_template_link_list, p8_a0
1048: , p8_a1
1049: , p8_a2
1050: , p8_a3
1051: , p8_a4

Line 1070: ddx_idname_pairs cs_tp_templates_pvt.id_name_pairs;

1066: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1067: )
1068:
1069: as
1070: ddx_idname_pairs cs_tp_templates_pvt.id_name_pairs;
1071: ddindx binary_integer; indx binary_integer;
1072: begin
1073:
1074: -- copy data to the local IN or IN-OUT args, if any

Line 1084: cs_tp_templates_pvt.show_link_attribute_list(p_api_version_number,

1080:
1081:
1082:
1083: -- here's the delegated call to the old PL/SQL routine
1084: cs_tp_templates_pvt.show_link_attribute_list(p_api_version_number,
1085: p_init_msg_list,
1086: p_commit,
1087: p_identify,
1088: x_msg_count,

Line 1101: cs_tp_templates_pvt_w.rosetta_table_copy_out_p7(ddx_idname_pairs, p7_a0

1097:
1098:
1099:
1100:
1101: cs_tp_templates_pvt_w.rosetta_table_copy_out_p7(ddx_idname_pairs, p7_a0
1102: , p7_a1
1103: );
1104: end;
1105:

Line 1117: ddx_idname_pairs cs_tp_templates_pvt.id_name_pairs;

1113: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_1000
1114: )
1115:
1116: as
1117: ddx_idname_pairs cs_tp_templates_pvt.id_name_pairs;
1118: ddindx binary_integer; indx binary_integer;
1119: begin
1120:
1121: -- copy data to the local IN or IN-OUT args, if any

Line 1130: cs_tp_templates_pvt.retrieve_constants(p_api_version_number,

1126:
1127:
1128:
1129: -- here's the delegated call to the old PL/SQL routine
1130: cs_tp_templates_pvt.retrieve_constants(p_api_version_number,
1131: p_init_msg_list,
1132: p_commit,
1133: x_msg_count,
1134: x_msg_data,

Line 1145: cs_tp_templates_pvt_w.rosetta_table_copy_out_p7(ddx_idname_pairs, p6_a0

1141:
1142:
1143:
1144:
1145: cs_tp_templates_pvt_w.rosetta_table_copy_out_p7(ddx_idname_pairs, p6_a0
1146: , p6_a1
1147: );
1148: end;
1149:

Line 1168: ddx_default_template cs_tp_templates_pvt.template;

1164: , p6_a8 out nocopy VARCHAR2
1165: )
1166:
1167: as
1168: ddx_default_template cs_tp_templates_pvt.template;
1169: ddindx binary_integer; indx binary_integer;
1170: begin
1171:
1172: -- copy data to the local IN or IN-OUT args, if any

Line 1181: cs_tp_templates_pvt.show_default_template(p_api_version_number,

1177:
1178:
1179:
1180: -- here's the delegated call to the old PL/SQL routine
1181: cs_tp_templates_pvt.show_default_template(p_api_version_number,
1182: p_init_msg_list,
1183: p_commit,
1184: x_msg_count,
1185: x_msg_data,

Line 1230: ddx_template_links cs_tp_templates_pvt.template_link_list;

1226: , x_retrieved_link_number out nocopy NUMBER
1227: )
1228:
1229: as
1230: ddx_template_links cs_tp_templates_pvt.template_link_list;
1231: ddindx binary_integer; indx binary_integer;
1232: begin
1233:
1234: -- copy data to the local IN or IN-OUT args, if any

Line 1249: cs_tp_templates_pvt.show_template_links_two(p_api_version_number,

1245:
1246:
1247:
1248: -- here's the delegated call to the old PL/SQL routine
1249: cs_tp_templates_pvt.show_template_links_two(p_api_version_number,
1250: p_init_msg_list,
1251: p_commit,
1252: p_template_id,
1253: p_jtf_object_code,

Line 1274: cs_tp_templates_pvt_w.rosetta_table_copy_out_p5(ddx_template_links, p10_a0

1270:
1271:
1272:
1273:
1274: cs_tp_templates_pvt_w.rosetta_table_copy_out_p5(ddx_template_links, p10_a0
1275: , p10_a1
1276: , p10_a2
1277: , p10_a3
1278: , p10_a4

Line 1311: ddx_template_link_list cs_tp_templates_pvt.template_link_list;

1307: , x_retrieved_link_number out nocopy NUMBER
1308: )
1309:
1310: as
1311: ddx_template_link_list cs_tp_templates_pvt.template_link_list;
1312: ddindx binary_integer; indx binary_integer;
1313: begin
1314:
1315: -- copy data to the local IN or IN-OUT args, if any

Line 1331: cs_tp_templates_pvt.show_non_asso_links_two(p_api_version_number,

1327:
1328:
1329:
1330: -- here's the delegated call to the old PL/SQL routine
1331: cs_tp_templates_pvt.show_non_asso_links_two(p_api_version_number,
1332: p_init_msg_list,
1333: p_commit,
1334: p_template_id,
1335: p_jtf_object_code,

Line 1358: cs_tp_templates_pvt_w.rosetta_table_copy_out_p5(ddx_template_link_list, p11_a0

1354:
1355:
1356:
1357:
1358: cs_tp_templates_pvt_w.rosetta_table_copy_out_p5(ddx_template_link_list, p11_a0
1359: , p11_a1
1360: , p11_a2
1361: , p11_a3
1362: , p11_a4

Line 1390: ddp_template_links cs_tp_templates_pvt.template_link_list;

1386: , x_return_status out nocopy VARCHAR2
1387: )
1388:
1389: as
1390: ddp_template_links cs_tp_templates_pvt.template_link_list;
1391: ddindx binary_integer; indx binary_integer;
1392: begin
1393:
1394: -- copy data to the local IN or IN-OUT args, if any

Line 1400: cs_tp_templates_pvt_w.rosetta_table_copy_in_p5(ddp_template_links, p5_a0

1396:
1397:
1398:
1399:
1400: cs_tp_templates_pvt_w.rosetta_table_copy_in_p5(ddp_template_links, p5_a0
1401: , p5_a1
1402: , p5_a2
1403: , p5_a3
1404: , p5_a4

Line 1414: cs_tp_templates_pvt.delete_template_links(p_api_version_number,

1410:
1411:
1412:
1413: -- here's the delegated call to the old PL/SQL routine
1414: cs_tp_templates_pvt.delete_template_links(p_api_version_number,
1415: p_init_msg_list,
1416: p_commit,
1417: p_template_id,
1418: p_jtf_object_code,

Line 1454: ddp_template_links cs_tp_templates_pvt.template_link_list;

1450: , x_return_status out nocopy VARCHAR2
1451: )
1452:
1453: as
1454: ddp_template_links cs_tp_templates_pvt.template_link_list;
1455: ddindx binary_integer; indx binary_integer;
1456: begin
1457:
1458: -- copy data to the local IN or IN-OUT args, if any

Line 1464: cs_tp_templates_pvt_w.rosetta_table_copy_in_p5(ddp_template_links, p5_a0

1460:
1461:
1462:
1463:
1464: cs_tp_templates_pvt_w.rosetta_table_copy_in_p5(ddp_template_links, p5_a0
1465: , p5_a1
1466: , p5_a2
1467: , p5_a3
1468: , p5_a4

Line 1478: cs_tp_templates_pvt.add_template_links(p_api_version_number,

1474:
1475:
1476:
1477: -- here's the delegated call to the old PL/SQL routine
1478: cs_tp_templates_pvt.add_template_links(p_api_version_number,
1479: p_init_msg_list,
1480: p_commit,
1481: p_template_id,
1482: p_jtf_object_code,

Line 1499: end cs_tp_templates_pvt_w;

1495:
1496:
1497: end;
1498:
1499: end cs_tp_templates_pvt_w;