DBA Data[Home] [Help]

APPS.CN_ATTAIN_TIER_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_attain_tier_pvt.attain_tier_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_attain_tier_pvt.attain_tier_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_200

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_attain_tier_pvt.attain_tier_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_200
18: , a5 JTF_VARCHAR2_TABLE_200

Line 15: , a2 JTF_NUMBER_TABLE

11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_attain_tier_pvt.attain_tier_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_200
18: , a5 JTF_VARCHAR2_TABLE_200
19: , a6 JTF_VARCHAR2_TABLE_200

Line 32: , a19 JTF_NUMBER_TABLE

28: , a15 JTF_VARCHAR2_TABLE_200
29: , a16 JTF_VARCHAR2_TABLE_200
30: , a17 JTF_VARCHAR2_TABLE_200
31: , a18 JTF_VARCHAR2_TABLE_200
32: , a19 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
35: begin
36: if a0 is not null and a0.count > 0 then

Line 70: procedure rosetta_table_copy_out_p1(t cn_attain_tier_pvt.attain_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

66: end loop;
67: end if;
68: end if;
69: end rosetta_table_copy_in_p1;
70: procedure rosetta_table_copy_out_p1(t cn_attain_tier_pvt.attain_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 71: , a1 out nocopy JTF_NUMBER_TABLE

67: end if;
68: end if;
69: end rosetta_table_copy_in_p1;
70: procedure rosetta_table_copy_out_p1(t cn_attain_tier_pvt.attain_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_VARCHAR2_TABLE_200
75: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 72: , a2 out nocopy JTF_NUMBER_TABLE

68: end if;
69: end rosetta_table_copy_in_p1;
70: procedure rosetta_table_copy_out_p1(t cn_attain_tier_pvt.attain_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_VARCHAR2_TABLE_200
75: , a5 out nocopy JTF_VARCHAR2_TABLE_200
76: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 89: , a19 out nocopy JTF_NUMBER_TABLE

85: , a15 out nocopy JTF_VARCHAR2_TABLE_200
86: , a16 out nocopy JTF_VARCHAR2_TABLE_200
87: , a17 out nocopy JTF_VARCHAR2_TABLE_200
88: , a18 out nocopy JTF_VARCHAR2_TABLE_200
89: , a19 out nocopy JTF_NUMBER_TABLE
90: ) as
91: ddindx binary_integer; indx binary_integer;
92: begin
93: if t is null or t.count = 0 then

Line 94: a0 := JTF_NUMBER_TABLE();

90: ) as
91: ddindx binary_integer; indx binary_integer;
92: begin
93: if t is null or t.count = 0 then
94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_VARCHAR2_TABLE_200();

Line 95: a1 := JTF_NUMBER_TABLE();

91: ddindx binary_integer; indx binary_integer;
92: begin
93: if t is null or t.count = 0 then
94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_VARCHAR2_TABLE_200();
99: a5 := JTF_VARCHAR2_TABLE_200();

Line 96: a2 := JTF_NUMBER_TABLE();

92: begin
93: if t is null or t.count = 0 then
94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_VARCHAR2_TABLE_200();
99: a5 := JTF_VARCHAR2_TABLE_200();
100: a6 := JTF_VARCHAR2_TABLE_200();

Line 113: a19 := JTF_NUMBER_TABLE();

109: a15 := JTF_VARCHAR2_TABLE_200();
110: a16 := JTF_VARCHAR2_TABLE_200();
111: a17 := JTF_VARCHAR2_TABLE_200();
112: a18 := JTF_VARCHAR2_TABLE_200();
113: a19 := JTF_NUMBER_TABLE();
114: else
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();

Line 115: a0 := JTF_NUMBER_TABLE();

111: a17 := JTF_VARCHAR2_TABLE_200();
112: a18 := JTF_VARCHAR2_TABLE_200();
113: a19 := JTF_NUMBER_TABLE();
114: else
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_VARCHAR2_TABLE_200();

Line 116: a1 := JTF_NUMBER_TABLE();

112: a18 := JTF_VARCHAR2_TABLE_200();
113: a19 := JTF_NUMBER_TABLE();
114: else
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_VARCHAR2_TABLE_200();
120: a5 := JTF_VARCHAR2_TABLE_200();

Line 117: a2 := JTF_NUMBER_TABLE();

113: a19 := JTF_NUMBER_TABLE();
114: else
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_VARCHAR2_TABLE_200();
120: a5 := JTF_VARCHAR2_TABLE_200();
121: a6 := JTF_VARCHAR2_TABLE_200();

Line 134: a19 := JTF_NUMBER_TABLE();

130: a15 := JTF_VARCHAR2_TABLE_200();
131: a16 := JTF_VARCHAR2_TABLE_200();
132: a17 := JTF_VARCHAR2_TABLE_200();
133: a18 := JTF_VARCHAR2_TABLE_200();
134: a19 := JTF_NUMBER_TABLE();
135: if t.count > 0 then
136: a0.extend(t.count);
137: a1.extend(t.count);
138: a2.extend(t.count);

Line 443: , p5_a0 out nocopy JTF_NUMBER_TABLE

439: , p_init_msg_list VARCHAR2
440: , p_commit VARCHAR2
441: , p_validation_level NUMBER
442: , p_attain_schedule_id NUMBER
443: , p5_a0 out nocopy JTF_NUMBER_TABLE
444: , p5_a1 out nocopy JTF_NUMBER_TABLE
445: , p5_a2 out nocopy JTF_NUMBER_TABLE
446: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
447: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 444: , p5_a1 out nocopy JTF_NUMBER_TABLE

440: , p_commit VARCHAR2
441: , p_validation_level NUMBER
442: , p_attain_schedule_id NUMBER
443: , p5_a0 out nocopy JTF_NUMBER_TABLE
444: , p5_a1 out nocopy JTF_NUMBER_TABLE
445: , p5_a2 out nocopy JTF_NUMBER_TABLE
446: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
447: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
448: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 445: , p5_a2 out nocopy JTF_NUMBER_TABLE

441: , p_validation_level NUMBER
442: , p_attain_schedule_id NUMBER
443: , p5_a0 out nocopy JTF_NUMBER_TABLE
444: , p5_a1 out nocopy JTF_NUMBER_TABLE
445: , p5_a2 out nocopy JTF_NUMBER_TABLE
446: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
447: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
448: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_200
449: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 462: , p5_a19 out nocopy JTF_NUMBER_TABLE

458: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
459: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_200
460: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_200
461: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_200
462: , p5_a19 out nocopy JTF_NUMBER_TABLE
463: , x_return_status out nocopy VARCHAR2
464: , x_msg_count out nocopy NUMBER
465: , x_msg_data out nocopy VARCHAR2
466: )