DBA Data[Home] [Help]

APPS.OKL_CREDIT_MEMO_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_p1(t out nocopy okl_credit_memo_pvt.credit_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_VARCHAR2_TABLE_200

Line 27: , a2 JTF_VARCHAR2_TABLE_100

23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy okl_credit_memo_pvt.credit_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_VARCHAR2_TABLE_200
31: , a6 JTF_VARCHAR2_TABLE_2000

Line 33: , a8 JTF_VARCHAR2_TABLE_100

29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_VARCHAR2_TABLE_200
31: , a6 JTF_VARCHAR2_TABLE_2000
32: , a7 JTF_DATE_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: ) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if a0 is not null and a0.count > 0 then

Line 61: , a1 out nocopy JTF_VARCHAR2_TABLE_100

57: end if;
58: end if;
59: end rosetta_table_copy_in_p1;
60: procedure rosetta_table_copy_out_p1(t okl_credit_memo_pvt.credit_tbl, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_100
62: , a2 out nocopy JTF_VARCHAR2_TABLE_100
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 62: , a2 out nocopy JTF_VARCHAR2_TABLE_100

58: end if;
59: end rosetta_table_copy_in_p1;
60: procedure rosetta_table_copy_out_p1(t okl_credit_memo_pvt.credit_tbl, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_100
62: , a2 out nocopy JTF_VARCHAR2_TABLE_100
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_VARCHAR2_TABLE_200
66: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 68: , a8 out nocopy JTF_VARCHAR2_TABLE_100

64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_VARCHAR2_TABLE_200
66: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a7 out nocopy JTF_DATE_TABLE
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then

Line 74: a1 := JTF_VARCHAR2_TABLE_100();

70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_100();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_200();

Line 75: a2 := JTF_VARCHAR2_TABLE_100();

71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_100();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_200();
79: a6 := JTF_VARCHAR2_TABLE_2000();

Line 81: a8 := JTF_VARCHAR2_TABLE_100();

77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_200();
79: a6 := JTF_VARCHAR2_TABLE_2000();
80: a7 := JTF_DATE_TABLE();
81: a8 := JTF_VARCHAR2_TABLE_100();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_VARCHAR2_TABLE_100();
85: a2 := JTF_VARCHAR2_TABLE_100();

Line 84: a1 := JTF_VARCHAR2_TABLE_100();

80: a7 := JTF_DATE_TABLE();
81: a8 := JTF_VARCHAR2_TABLE_100();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_VARCHAR2_TABLE_100();
85: a2 := JTF_VARCHAR2_TABLE_100();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_NUMBER_TABLE();
88: a5 := JTF_VARCHAR2_TABLE_200();

Line 85: a2 := JTF_VARCHAR2_TABLE_100();

81: a8 := JTF_VARCHAR2_TABLE_100();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_VARCHAR2_TABLE_100();
85: a2 := JTF_VARCHAR2_TABLE_100();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_NUMBER_TABLE();
88: a5 := JTF_VARCHAR2_TABLE_200();
89: a6 := JTF_VARCHAR2_TABLE_2000();

Line 91: a8 := JTF_VARCHAR2_TABLE_100();

87: a4 := JTF_NUMBER_TABLE();
88: a5 := JTF_VARCHAR2_TABLE_200();
89: a6 := JTF_VARCHAR2_TABLE_2000();
90: a7 := JTF_DATE_TABLE();
91: a8 := JTF_VARCHAR2_TABLE_100();
92: if t.count > 0 then
93: a0.extend(t.count);
94: a1.extend(t.count);
95: a2.extend(t.count);

Line 348: , p2_a1 JTF_VARCHAR2_TABLE_100

344:
345: procedure insert_request(p_api_version NUMBER
346: , p_init_msg_list VARCHAR2
347: , p2_a0 JTF_NUMBER_TABLE
348: , p2_a1 JTF_VARCHAR2_TABLE_100
349: , p2_a2 JTF_VARCHAR2_TABLE_100
350: , p2_a3 JTF_NUMBER_TABLE
351: , p2_a4 JTF_NUMBER_TABLE
352: , p2_a5 JTF_VARCHAR2_TABLE_200

Line 349: , p2_a2 JTF_VARCHAR2_TABLE_100

345: procedure insert_request(p_api_version NUMBER
346: , p_init_msg_list VARCHAR2
347: , p2_a0 JTF_NUMBER_TABLE
348: , p2_a1 JTF_VARCHAR2_TABLE_100
349: , p2_a2 JTF_VARCHAR2_TABLE_100
350: , p2_a3 JTF_NUMBER_TABLE
351: , p2_a4 JTF_NUMBER_TABLE
352: , p2_a5 JTF_VARCHAR2_TABLE_200
353: , p2_a6 JTF_VARCHAR2_TABLE_2000

Line 355: , p2_a8 JTF_VARCHAR2_TABLE_100

351: , p2_a4 JTF_NUMBER_TABLE
352: , p2_a5 JTF_VARCHAR2_TABLE_200
353: , p2_a6 JTF_VARCHAR2_TABLE_2000
354: , p2_a7 JTF_DATE_TABLE
355: , p2_a8 JTF_VARCHAR2_TABLE_100
356: , p_transaction_source VARCHAR2
357: , p_source_trx_number VARCHAR2
358: , p5_a0 out nocopy JTF_NUMBER_TABLE
359: , p5_a1 out nocopy JTF_NUMBER_TABLE

Line 360: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100

356: , p_transaction_source VARCHAR2
357: , p_source_trx_number VARCHAR2
358: , p5_a0 out nocopy JTF_NUMBER_TABLE
359: , p5_a1 out nocopy JTF_NUMBER_TABLE
360: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
361: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
362: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
363: , p5_a5 out nocopy JTF_NUMBER_TABLE
364: , p5_a6 out nocopy JTF_DATE_TABLE

Line 361: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

357: , p_source_trx_number VARCHAR2
358: , p5_a0 out nocopy JTF_NUMBER_TABLE
359: , p5_a1 out nocopy JTF_NUMBER_TABLE
360: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
361: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
362: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
363: , p5_a5 out nocopy JTF_NUMBER_TABLE
364: , p5_a6 out nocopy JTF_DATE_TABLE
365: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 362: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

358: , p5_a0 out nocopy JTF_NUMBER_TABLE
359: , p5_a1 out nocopy JTF_NUMBER_TABLE
360: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
361: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
362: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
363: , p5_a5 out nocopy JTF_NUMBER_TABLE
364: , p5_a6 out nocopy JTF_DATE_TABLE
365: , p5_a7 out nocopy JTF_NUMBER_TABLE
366: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 372: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100

368: , p5_a10 out nocopy JTF_NUMBER_TABLE
369: , p5_a11 out nocopy JTF_NUMBER_TABLE
370: , p5_a12 out nocopy JTF_NUMBER_TABLE
371: , p5_a13 out nocopy JTF_NUMBER_TABLE
372: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100
373: , p5_a15 out nocopy JTF_NUMBER_TABLE
374: , p5_a16 out nocopy JTF_NUMBER_TABLE
375: , p5_a17 out nocopy JTF_NUMBER_TABLE
376: , p5_a18 out nocopy JTF_NUMBER_TABLE

Line 388: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100

384: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_300
385: , p5_a27 out nocopy JTF_NUMBER_TABLE
386: , p5_a28 out nocopy JTF_NUMBER_TABLE
387: , p5_a29 out nocopy JTF_NUMBER_TABLE
388: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
389: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_500
390: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_500
391: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_500
392: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_500

Line 418: , p5_a60 out nocopy JTF_VARCHAR2_TABLE_100

414: , p5_a56 out nocopy JTF_NUMBER_TABLE
415: , p5_a57 out nocopy JTF_NUMBER_TABLE
416: , p5_a58 out nocopy JTF_VARCHAR2_TABLE_200
417: , p5_a59 out nocopy JTF_VARCHAR2_TABLE_400
418: , p5_a60 out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a61 out nocopy JTF_NUMBER_TABLE
420: , p5_a62 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a63 out nocopy JTF_DATE_TABLE
422: , p5_a64 out nocopy JTF_VARCHAR2_TABLE_100

Line 420: , p5_a62 out nocopy JTF_VARCHAR2_TABLE_100

416: , p5_a58 out nocopy JTF_VARCHAR2_TABLE_200
417: , p5_a59 out nocopy JTF_VARCHAR2_TABLE_400
418: , p5_a60 out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a61 out nocopy JTF_NUMBER_TABLE
420: , p5_a62 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a63 out nocopy JTF_DATE_TABLE
422: , p5_a64 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a65 out nocopy JTF_NUMBER_TABLE
424: , p5_a66 out nocopy JTF_NUMBER_TABLE

Line 422: , p5_a64 out nocopy JTF_VARCHAR2_TABLE_100

418: , p5_a60 out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a61 out nocopy JTF_NUMBER_TABLE
420: , p5_a62 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a63 out nocopy JTF_DATE_TABLE
422: , p5_a64 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a65 out nocopy JTF_NUMBER_TABLE
424: , p5_a66 out nocopy JTF_NUMBER_TABLE
425: , p5_a67 out nocopy JTF_NUMBER_TABLE
426: , p5_a68 out nocopy JTF_NUMBER_TABLE

Line 427: , p5_a69 out nocopy JTF_VARCHAR2_TABLE_100

423: , p5_a65 out nocopy JTF_NUMBER_TABLE
424: , p5_a66 out nocopy JTF_NUMBER_TABLE
425: , p5_a67 out nocopy JTF_NUMBER_TABLE
426: , p5_a68 out nocopy JTF_NUMBER_TABLE
427: , p5_a69 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a70 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a71 out nocopy JTF_NUMBER_TABLE
430: , p5_a72 out nocopy JTF_VARCHAR2_TABLE_4000
431: , p5_a73 out nocopy JTF_DATE_TABLE

Line 428: , p5_a70 out nocopy JTF_VARCHAR2_TABLE_100

424: , p5_a66 out nocopy JTF_NUMBER_TABLE
425: , p5_a67 out nocopy JTF_NUMBER_TABLE
426: , p5_a68 out nocopy JTF_NUMBER_TABLE
427: , p5_a69 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a70 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a71 out nocopy JTF_NUMBER_TABLE
430: , p5_a72 out nocopy JTF_VARCHAR2_TABLE_4000
431: , p5_a73 out nocopy JTF_DATE_TABLE
432: , x_return_status out nocopy VARCHAR2