DBA Data[Home] [Help]

APPS.OKL_STRM_GEN_TEMPLATE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a1 JTF_VARCHAR2_TABLE_100

22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p72(t out nocopy okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 JTF_VARCHAR2_TABLE_2500
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin

Line 27: , a2 JTF_VARCHAR2_TABLE_100

23: end;
24:
25: procedure rosetta_table_copy_in_p72(t out nocopy okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 JTF_VARCHAR2_TABLE_2500
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin
31: if a0 is not null and a0.count > 0 then

Line 49: , a1 out nocopy JTF_VARCHAR2_TABLE_100

45: end if;
46: end if;
47: end rosetta_table_copy_in_p72;
48: procedure rosetta_table_copy_out_p72(t okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2500
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin

Line 50: , a2 out nocopy JTF_VARCHAR2_TABLE_100

46: end if;
47: end rosetta_table_copy_in_p72;
48: procedure rosetta_table_copy_out_p72(t okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2500
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then

Line 56: a1 := JTF_VARCHAR2_TABLE_100();

52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_VARCHAR2_TABLE_2500();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: else
59: a0 := JTF_VARCHAR2_TABLE_2500();
60: a1 := JTF_VARCHAR2_TABLE_100();

Line 57: a2 := JTF_VARCHAR2_TABLE_100();

53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_VARCHAR2_TABLE_2500();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: else
59: a0 := JTF_VARCHAR2_TABLE_2500();
60: a1 := JTF_VARCHAR2_TABLE_100();
61: a2 := JTF_VARCHAR2_TABLE_100();

Line 60: a1 := JTF_VARCHAR2_TABLE_100();

56: a1 := JTF_VARCHAR2_TABLE_100();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: else
59: a0 := JTF_VARCHAR2_TABLE_2500();
60: a1 := JTF_VARCHAR2_TABLE_100();
61: a2 := JTF_VARCHAR2_TABLE_100();
62: if t.count > 0 then
63: a0.extend(t.count);
64: a1.extend(t.count);

Line 61: a2 := JTF_VARCHAR2_TABLE_100();

57: a2 := JTF_VARCHAR2_TABLE_100();
58: else
59: a0 := JTF_VARCHAR2_TABLE_2500();
60: a1 := JTF_VARCHAR2_TABLE_100();
61: a2 := JTF_VARCHAR2_TABLE_100();
62: if t.count > 0 then
63: a0.extend(t.count);
64: a1.extend(t.count);
65: a2.extend(t.count);

Line 91: , p7_a4 JTF_VARCHAR2_TABLE_100

87: , p7_a0 JTF_NUMBER_TABLE
88: , p7_a1 JTF_NUMBER_TABLE
89: , p7_a2 JTF_VARCHAR2_TABLE_200
90: , p7_a3 JTF_VARCHAR2_TABLE_2000
91: , p7_a4 JTF_VARCHAR2_TABLE_100
92: , p7_a5 JTF_VARCHAR2_TABLE_100
93: , p7_a6 JTF_VARCHAR2_TABLE_500
94: , p7_a7 JTF_VARCHAR2_TABLE_500
95: , p7_a8 JTF_NUMBER_TABLE

Line 92: , p7_a5 JTF_VARCHAR2_TABLE_100

88: , p7_a1 JTF_NUMBER_TABLE
89: , p7_a2 JTF_VARCHAR2_TABLE_200
90: , p7_a3 JTF_VARCHAR2_TABLE_2000
91: , p7_a4 JTF_VARCHAR2_TABLE_100
92: , p7_a5 JTF_VARCHAR2_TABLE_100
93: , p7_a6 JTF_VARCHAR2_TABLE_500
94: , p7_a7 JTF_VARCHAR2_TABLE_500
95: , p7_a8 JTF_NUMBER_TABLE
96: , p7_a9 JTF_NUMBER_TABLE

Line 105: , p8_a3 JTF_VARCHAR2_TABLE_100

101: , p7_a14 JTF_NUMBER_TABLE
102: , p8_a0 JTF_NUMBER_TABLE
103: , p8_a1 JTF_NUMBER_TABLE
104: , p8_a2 JTF_NUMBER_TABLE
105: , p8_a3 JTF_VARCHAR2_TABLE_100
106: , p8_a4 JTF_NUMBER_TABLE
107: , p8_a5 JTF_NUMBER_TABLE
108: , p8_a6 JTF_VARCHAR2_TABLE_200
109: , p8_a7 JTF_NUMBER_TABLE

Line 354: , p7_a4 JTF_VARCHAR2_TABLE_100

350: , p7_a0 JTF_NUMBER_TABLE
351: , p7_a1 JTF_NUMBER_TABLE
352: , p7_a2 JTF_VARCHAR2_TABLE_200
353: , p7_a3 JTF_VARCHAR2_TABLE_2000
354: , p7_a4 JTF_VARCHAR2_TABLE_100
355: , p7_a5 JTF_VARCHAR2_TABLE_100
356: , p7_a6 JTF_VARCHAR2_TABLE_500
357: , p7_a7 JTF_VARCHAR2_TABLE_500
358: , p7_a8 JTF_NUMBER_TABLE

Line 355: , p7_a5 JTF_VARCHAR2_TABLE_100

351: , p7_a1 JTF_NUMBER_TABLE
352: , p7_a2 JTF_VARCHAR2_TABLE_200
353: , p7_a3 JTF_VARCHAR2_TABLE_2000
354: , p7_a4 JTF_VARCHAR2_TABLE_100
355: , p7_a5 JTF_VARCHAR2_TABLE_100
356: , p7_a6 JTF_VARCHAR2_TABLE_500
357: , p7_a7 JTF_VARCHAR2_TABLE_500
358: , p7_a8 JTF_NUMBER_TABLE
359: , p7_a9 JTF_NUMBER_TABLE

Line 368: , p8_a3 JTF_VARCHAR2_TABLE_100

364: , p7_a14 JTF_NUMBER_TABLE
365: , p8_a0 JTF_NUMBER_TABLE
366: , p8_a1 JTF_NUMBER_TABLE
367: , p8_a2 JTF_NUMBER_TABLE
368: , p8_a3 JTF_VARCHAR2_TABLE_100
369: , p8_a4 JTF_NUMBER_TABLE
370: , p8_a5 JTF_NUMBER_TABLE
371: , p8_a6 JTF_VARCHAR2_TABLE_200
372: , p8_a7 JTF_NUMBER_TABLE

Line 618: , p7_a3 JTF_VARCHAR2_TABLE_100

614: , p_pri_sty_id NUMBER
615: , p7_a0 JTF_NUMBER_TABLE
616: , p7_a1 JTF_NUMBER_TABLE
617: , p7_a2 JTF_NUMBER_TABLE
618: , p7_a3 JTF_VARCHAR2_TABLE_100
619: , p7_a4 JTF_NUMBER_TABLE
620: , p7_a5 JTF_NUMBER_TABLE
621: , p7_a6 JTF_VARCHAR2_TABLE_200
622: , p7_a7 JTF_NUMBER_TABLE

Line 796: , p5_a4 JTF_VARCHAR2_TABLE_100

792: , p5_a0 JTF_NUMBER_TABLE
793: , p5_a1 JTF_NUMBER_TABLE
794: , p5_a2 JTF_VARCHAR2_TABLE_200
795: , p5_a3 JTF_VARCHAR2_TABLE_2000
796: , p5_a4 JTF_VARCHAR2_TABLE_100
797: , p5_a5 JTF_VARCHAR2_TABLE_100
798: , p5_a6 JTF_VARCHAR2_TABLE_500
799: , p5_a7 JTF_VARCHAR2_TABLE_500
800: , p5_a8 JTF_NUMBER_TABLE

Line 797: , p5_a5 JTF_VARCHAR2_TABLE_100

793: , p5_a1 JTF_NUMBER_TABLE
794: , p5_a2 JTF_VARCHAR2_TABLE_200
795: , p5_a3 JTF_VARCHAR2_TABLE_2000
796: , p5_a4 JTF_VARCHAR2_TABLE_100
797: , p5_a5 JTF_VARCHAR2_TABLE_100
798: , p5_a6 JTF_VARCHAR2_TABLE_500
799: , p5_a7 JTF_VARCHAR2_TABLE_500
800: , p5_a8 JTF_NUMBER_TABLE
801: , p5_a9 JTF_NUMBER_TABLE

Line 861: , p5_a3 JTF_VARCHAR2_TABLE_100

857: , x_msg_data out nocopy VARCHAR2
858: , p5_a0 JTF_NUMBER_TABLE
859: , p5_a1 JTF_NUMBER_TABLE
860: , p5_a2 JTF_NUMBER_TABLE
861: , p5_a3 JTF_VARCHAR2_TABLE_100
862: , p5_a4 JTF_NUMBER_TABLE
863: , p5_a5 JTF_NUMBER_TABLE
864: , p5_a6 JTF_VARCHAR2_TABLE_200
865: , p5_a7 JTF_NUMBER_TABLE

Line 923: , p5_a3 JTF_VARCHAR2_TABLE_100

919: , x_msg_data out nocopy VARCHAR2
920: , p5_a0 JTF_NUMBER_TABLE
921: , p5_a1 JTF_NUMBER_TABLE
922: , p5_a2 JTF_NUMBER_TABLE
923: , p5_a3 JTF_VARCHAR2_TABLE_100
924: , p5_a4 JTF_NUMBER_TABLE
925: , p5_a5 JTF_NUMBER_TABLE
926: , p5_a6 JTF_VARCHAR2_TABLE_200
927: , p5_a7 JTF_NUMBER_TABLE

Line 984: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

980: , x_msg_count out nocopy NUMBER
981: , x_msg_data out nocopy VARCHAR2
982: , p_gtt_id NUMBER
983: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
984: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
986: , x_return_tmpt_status out nocopy VARCHAR2
987: , p_during_upd_flag VARCHAR2
988: )

Line 985: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

981: , x_msg_data out nocopy VARCHAR2
982: , p_gtt_id NUMBER
983: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
984: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
986: , x_return_tmpt_status out nocopy VARCHAR2
987: , p_during_upd_flag VARCHAR2
988: )
989:

Line 1038: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

1034: , x_msg_count out nocopy NUMBER
1035: , x_msg_data out nocopy VARCHAR2
1036: , p_gtt_id NUMBER
1037: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
1038: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1039: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1040: , p_during_upd_flag VARCHAR
1041: , x_pri_purpose_list out nocopy VARCHAR
1042: )

Line 1039: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1035: , x_msg_data out nocopy VARCHAR2
1036: , p_gtt_id NUMBER
1037: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
1038: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1039: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1040: , p_during_upd_flag VARCHAR
1041: , x_pri_purpose_list out nocopy VARCHAR
1042: )
1043:

Line 1094: , p7_a4 JTF_VARCHAR2_TABLE_100

1090: , p7_a0 JTF_NUMBER_TABLE
1091: , p7_a1 JTF_NUMBER_TABLE
1092: , p7_a2 JTF_VARCHAR2_TABLE_200
1093: , p7_a3 JTF_VARCHAR2_TABLE_2000
1094: , p7_a4 JTF_VARCHAR2_TABLE_100
1095: , p7_a5 JTF_VARCHAR2_TABLE_100
1096: , p7_a6 JTF_VARCHAR2_TABLE_500
1097: , p7_a7 JTF_VARCHAR2_TABLE_500
1098: , p7_a8 JTF_NUMBER_TABLE

Line 1095: , p7_a5 JTF_VARCHAR2_TABLE_100

1091: , p7_a1 JTF_NUMBER_TABLE
1092: , p7_a2 JTF_VARCHAR2_TABLE_200
1093: , p7_a3 JTF_VARCHAR2_TABLE_2000
1094: , p7_a4 JTF_VARCHAR2_TABLE_100
1095: , p7_a5 JTF_VARCHAR2_TABLE_100
1096: , p7_a6 JTF_VARCHAR2_TABLE_500
1097: , p7_a7 JTF_VARCHAR2_TABLE_500
1098: , p7_a8 JTF_NUMBER_TABLE
1099: , p7_a9 JTF_NUMBER_TABLE

Line 1108: , p8_a3 JTF_VARCHAR2_TABLE_100

1104: , p7_a14 JTF_NUMBER_TABLE
1105: , p8_a0 JTF_NUMBER_TABLE
1106: , p8_a1 JTF_NUMBER_TABLE
1107: , p8_a2 JTF_NUMBER_TABLE
1108: , p8_a3 JTF_VARCHAR2_TABLE_100
1109: , p8_a4 JTF_NUMBER_TABLE
1110: , p8_a5 JTF_NUMBER_TABLE
1111: , p8_a6 JTF_VARCHAR2_TABLE_200
1112: , p8_a7 JTF_NUMBER_TABLE

Line 1121: , p9_a3 JTF_VARCHAR2_TABLE_100

1117: , p8_a12 JTF_NUMBER_TABLE
1118: , p9_a0 JTF_NUMBER_TABLE
1119: , p9_a1 JTF_NUMBER_TABLE
1120: , p9_a2 JTF_NUMBER_TABLE
1121: , p9_a3 JTF_VARCHAR2_TABLE_100
1122: , p9_a4 JTF_NUMBER_TABLE
1123: , p9_a5 JTF_NUMBER_TABLE
1124: , p9_a6 JTF_VARCHAR2_TABLE_200
1125: , p9_a7 JTF_NUMBER_TABLE

Line 1134: , p10_a3 JTF_VARCHAR2_TABLE_100

1130: , p9_a12 JTF_NUMBER_TABLE
1131: , p10_a0 JTF_NUMBER_TABLE
1132: , p10_a1 JTF_NUMBER_TABLE
1133: , p10_a2 JTF_NUMBER_TABLE
1134: , p10_a3 JTF_VARCHAR2_TABLE_100
1135: , p10_a4 JTF_NUMBER_TABLE
1136: , p10_a5 JTF_NUMBER_TABLE
1137: , p10_a6 JTF_VARCHAR2_TABLE_200
1138: , p10_a7 JTF_NUMBER_TABLE