DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 3: procedure rosetta_table_copy_in_p4(t out nocopy okl_contract_pvt.hdr_tbl_type, a0 JTF_VARCHAR2_TABLE_300);

1: package okl_contract_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLOKHRS.pls 115.9 2003/10/16 09:59:50 avsingh noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy okl_contract_pvt.hdr_tbl_type, a0 JTF_VARCHAR2_TABLE_300);
4: procedure rosetta_table_copy_out_p4(t okl_contract_pvt.hdr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
5:
6: procedure create_contract_header(p_api_version NUMBER
7: , p_init_msg_list VARCHAR2

Line 4: procedure rosetta_table_copy_out_p4(t okl_contract_pvt.hdr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);

1: package okl_contract_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLOKHRS.pls 115.9 2003/10/16 09:59:50 avsingh noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy okl_contract_pvt.hdr_tbl_type, a0 JTF_VARCHAR2_TABLE_300);
4: procedure rosetta_table_copy_out_p4(t okl_contract_pvt.hdr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
5:
6: procedure create_contract_header(p_api_version NUMBER
7: , p_init_msg_list VARCHAR2
8: , x_return_status out nocopy VARCHAR2

Line 381: , p5_a22 JTF_VARCHAR2_TABLE_300

377: , p5_a18 JTF_VARCHAR2_TABLE_600
378: , p5_a19 JTF_VARCHAR2_TABLE_2000
379: , p5_a20 JTF_VARCHAR2_TABLE_2000
380: , p5_a21 JTF_VARCHAR2_TABLE_100
381: , p5_a22 JTF_VARCHAR2_TABLE_300
382: , p5_a23 JTF_VARCHAR2_TABLE_100
383: , p5_a24 JTF_VARCHAR2_TABLE_200
384: , p5_a25 JTF_DATE_TABLE
385: , p5_a26 JTF_DATE_TABLE

Line 552: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_300

548: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_600
549: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_2000
550: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
551: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
552: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_300
553: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
554: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_200
555: , p7_a25 out nocopy JTF_DATE_TABLE
556: , p7_a26 out nocopy JTF_DATE_TABLE

Line 1079: , p6_a22 JTF_VARCHAR2_TABLE_300

1075: , p6_a18 JTF_VARCHAR2_TABLE_600
1076: , p6_a19 JTF_VARCHAR2_TABLE_2000
1077: , p6_a20 JTF_VARCHAR2_TABLE_2000
1078: , p6_a21 JTF_VARCHAR2_TABLE_100
1079: , p6_a22 JTF_VARCHAR2_TABLE_300
1080: , p6_a23 JTF_VARCHAR2_TABLE_100
1081: , p6_a24 JTF_VARCHAR2_TABLE_200
1082: , p6_a25 JTF_DATE_TABLE
1083: , p6_a26 JTF_DATE_TABLE

Line 1250: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_300

1246: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_600
1247: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_2000
1248: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1249: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
1250: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_300
1251: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
1253: , p8_a25 out nocopy JTF_DATE_TABLE
1254: , p8_a26 out nocopy JTF_DATE_TABLE

Line 1957: , p5_a22 JTF_VARCHAR2_TABLE_300

1953: , p5_a18 JTF_VARCHAR2_TABLE_600
1954: , p5_a19 JTF_VARCHAR2_TABLE_2000
1955: , p5_a20 JTF_VARCHAR2_TABLE_2000
1956: , p5_a21 JTF_VARCHAR2_TABLE_100
1957: , p5_a22 JTF_VARCHAR2_TABLE_300
1958: , p5_a23 JTF_VARCHAR2_TABLE_100
1959: , p5_a24 JTF_VARCHAR2_TABLE_200
1960: , p5_a25 JTF_DATE_TABLE
1961: , p5_a26 JTF_DATE_TABLE

Line 2311: , p5_a22 JTF_VARCHAR2_TABLE_300

2307: , p5_a18 JTF_VARCHAR2_TABLE_600
2308: , p5_a19 JTF_VARCHAR2_TABLE_2000
2309: , p5_a20 JTF_VARCHAR2_TABLE_2000
2310: , p5_a21 JTF_VARCHAR2_TABLE_100
2311: , p5_a22 JTF_VARCHAR2_TABLE_300
2312: , p5_a23 JTF_VARCHAR2_TABLE_100
2313: , p5_a24 JTF_VARCHAR2_TABLE_200
2314: , p5_a25 JTF_DATE_TABLE
2315: , p5_a26 JTF_DATE_TABLE

Line 2665: , p5_a22 JTF_VARCHAR2_TABLE_300

2661: , p5_a18 JTF_VARCHAR2_TABLE_600
2662: , p5_a19 JTF_VARCHAR2_TABLE_2000
2663: , p5_a20 JTF_VARCHAR2_TABLE_2000
2664: , p5_a21 JTF_VARCHAR2_TABLE_100
2665: , p5_a22 JTF_VARCHAR2_TABLE_300
2666: , p5_a23 JTF_VARCHAR2_TABLE_100
2667: , p5_a24 JTF_VARCHAR2_TABLE_200
2668: , p5_a25 JTF_DATE_TABLE
2669: , p5_a26 JTF_DATE_TABLE

Line 3220: , p5_a16 JTF_VARCHAR2_TABLE_300

3216: , p5_a12 JTF_NUMBER_TABLE
3217: , p5_a13 JTF_VARCHAR2_TABLE_2000
3218: , p5_a14 JTF_VARCHAR2_TABLE_2000
3219: , p5_a15 JTF_VARCHAR2_TABLE_2000
3220: , p5_a16 JTF_VARCHAR2_TABLE_300
3221: , p5_a17 JTF_VARCHAR2_TABLE_100
3222: , p5_a18 JTF_NUMBER_TABLE
3223: , p5_a19 JTF_NUMBER_TABLE
3224: , p5_a20 JTF_NUMBER_TABLE

Line 3331: , p6_a37 JTF_VARCHAR2_TABLE_300

3327: , p6_a33 JTF_NUMBER_TABLE
3328: , p6_a34 JTF_DATE_TABLE
3329: , p6_a35 JTF_VARCHAR2_TABLE_100
3330: , p6_a36 JTF_DATE_TABLE
3331: , p6_a37 JTF_VARCHAR2_TABLE_300
3332: , p6_a38 JTF_NUMBER_TABLE
3333: , p6_a39 JTF_NUMBER_TABLE
3334: , p6_a40 JTF_NUMBER_TABLE
3335: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 3409: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300

3405: , p7_a12 out nocopy JTF_NUMBER_TABLE
3406: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
3407: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
3408: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
3409: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300
3410: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
3411: , p7_a18 out nocopy JTF_NUMBER_TABLE
3412: , p7_a19 out nocopy JTF_NUMBER_TABLE
3413: , p7_a20 out nocopy JTF_NUMBER_TABLE

Line 3520: , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300

3516: , p8_a33 out nocopy JTF_NUMBER_TABLE
3517: , p8_a34 out nocopy JTF_DATE_TABLE
3518: , p8_a35 out nocopy JTF_VARCHAR2_TABLE_100
3519: , p8_a36 out nocopy JTF_DATE_TABLE
3520: , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300
3521: , p8_a38 out nocopy JTF_NUMBER_TABLE
3522: , p8_a39 out nocopy JTF_NUMBER_TABLE
3523: , p8_a40 out nocopy JTF_NUMBER_TABLE
3524: , p8_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 3988: , p5_a16 JTF_VARCHAR2_TABLE_300

3984: , p5_a12 JTF_NUMBER_TABLE
3985: , p5_a13 JTF_VARCHAR2_TABLE_2000
3986: , p5_a14 JTF_VARCHAR2_TABLE_2000
3987: , p5_a15 JTF_VARCHAR2_TABLE_2000
3988: , p5_a16 JTF_VARCHAR2_TABLE_300
3989: , p5_a17 JTF_VARCHAR2_TABLE_100
3990: , p5_a18 JTF_NUMBER_TABLE
3991: , p5_a19 JTF_NUMBER_TABLE
3992: , p5_a20 JTF_NUMBER_TABLE

Line 4099: , p6_a37 JTF_VARCHAR2_TABLE_300

4095: , p6_a33 JTF_NUMBER_TABLE
4096: , p6_a34 JTF_DATE_TABLE
4097: , p6_a35 JTF_VARCHAR2_TABLE_100
4098: , p6_a36 JTF_DATE_TABLE
4099: , p6_a37 JTF_VARCHAR2_TABLE_300
4100: , p6_a38 JTF_NUMBER_TABLE
4101: , p6_a39 JTF_NUMBER_TABLE
4102: , p6_a40 JTF_NUMBER_TABLE
4103: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 4177: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300

4173: , p7_a12 out nocopy JTF_NUMBER_TABLE
4174: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
4175: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
4176: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
4177: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300
4178: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
4179: , p7_a18 out nocopy JTF_NUMBER_TABLE
4180: , p7_a19 out nocopy JTF_NUMBER_TABLE
4181: , p7_a20 out nocopy JTF_NUMBER_TABLE

Line 4288: , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300

4284: , p8_a33 out nocopy JTF_NUMBER_TABLE
4285: , p8_a34 out nocopy JTF_DATE_TABLE
4286: , p8_a35 out nocopy JTF_VARCHAR2_TABLE_100
4287: , p8_a36 out nocopy JTF_DATE_TABLE
4288: , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300
4289: , p8_a38 out nocopy JTF_NUMBER_TABLE
4290: , p8_a39 out nocopy JTF_NUMBER_TABLE
4291: , p8_a40 out nocopy JTF_NUMBER_TABLE
4292: , p8_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 4758: , p5_a16 JTF_VARCHAR2_TABLE_300

4754: , p5_a12 JTF_NUMBER_TABLE
4755: , p5_a13 JTF_VARCHAR2_TABLE_2000
4756: , p5_a14 JTF_VARCHAR2_TABLE_2000
4757: , p5_a15 JTF_VARCHAR2_TABLE_2000
4758: , p5_a16 JTF_VARCHAR2_TABLE_300
4759: , p5_a17 JTF_VARCHAR2_TABLE_100
4760: , p5_a18 JTF_NUMBER_TABLE
4761: , p5_a19 JTF_NUMBER_TABLE
4762: , p5_a20 JTF_NUMBER_TABLE

Line 4869: , p6_a37 JTF_VARCHAR2_TABLE_300

4865: , p6_a33 JTF_NUMBER_TABLE
4866: , p6_a34 JTF_DATE_TABLE
4867: , p6_a35 JTF_VARCHAR2_TABLE_100
4868: , p6_a36 JTF_DATE_TABLE
4869: , p6_a37 JTF_VARCHAR2_TABLE_300
4870: , p6_a38 JTF_NUMBER_TABLE
4871: , p6_a39 JTF_NUMBER_TABLE
4872: , p6_a40 JTF_NUMBER_TABLE
4873: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 4948: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_300

4944: , p8_a12 out nocopy JTF_NUMBER_TABLE
4945: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_2000
4946: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_2000
4947: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_2000
4948: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_300
4949: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
4950: , p8_a18 out nocopy JTF_NUMBER_TABLE
4951: , p8_a19 out nocopy JTF_NUMBER_TABLE
4952: , p8_a20 out nocopy JTF_NUMBER_TABLE

Line 5059: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_300

5055: , p9_a33 out nocopy JTF_NUMBER_TABLE
5056: , p9_a34 out nocopy JTF_DATE_TABLE
5057: , p9_a35 out nocopy JTF_VARCHAR2_TABLE_100
5058: , p9_a36 out nocopy JTF_DATE_TABLE
5059: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_300
5060: , p9_a38 out nocopy JTF_NUMBER_TABLE
5061: , p9_a39 out nocopy JTF_NUMBER_TABLE
5062: , p9_a40 out nocopy JTF_NUMBER_TABLE
5063: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 5339: , p5_a16 JTF_VARCHAR2_TABLE_300

5335: , p5_a12 JTF_NUMBER_TABLE
5336: , p5_a13 JTF_VARCHAR2_TABLE_2000
5337: , p5_a14 JTF_VARCHAR2_TABLE_2000
5338: , p5_a15 JTF_VARCHAR2_TABLE_2000
5339: , p5_a16 JTF_VARCHAR2_TABLE_300
5340: , p5_a17 JTF_VARCHAR2_TABLE_100
5341: , p5_a18 JTF_NUMBER_TABLE
5342: , p5_a19 JTF_NUMBER_TABLE
5343: , p5_a20 JTF_NUMBER_TABLE

Line 5450: , p6_a37 JTF_VARCHAR2_TABLE_300

5446: , p6_a33 JTF_NUMBER_TABLE
5447: , p6_a34 JTF_DATE_TABLE
5448: , p6_a35 JTF_VARCHAR2_TABLE_100
5449: , p6_a36 JTF_DATE_TABLE
5450: , p6_a37 JTF_VARCHAR2_TABLE_300
5451: , p6_a38 JTF_NUMBER_TABLE
5452: , p6_a39 JTF_NUMBER_TABLE
5453: , p6_a40 JTF_NUMBER_TABLE
5454: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 5730: , p5_a16 JTF_VARCHAR2_TABLE_300

5726: , p5_a12 JTF_NUMBER_TABLE
5727: , p5_a13 JTF_VARCHAR2_TABLE_2000
5728: , p5_a14 JTF_VARCHAR2_TABLE_2000
5729: , p5_a15 JTF_VARCHAR2_TABLE_2000
5730: , p5_a16 JTF_VARCHAR2_TABLE_300
5731: , p5_a17 JTF_VARCHAR2_TABLE_100
5732: , p5_a18 JTF_NUMBER_TABLE
5733: , p5_a19 JTF_NUMBER_TABLE
5734: , p5_a20 JTF_NUMBER_TABLE

Line 5841: , p6_a37 JTF_VARCHAR2_TABLE_300

5837: , p6_a33 JTF_NUMBER_TABLE
5838: , p6_a34 JTF_DATE_TABLE
5839: , p6_a35 JTF_VARCHAR2_TABLE_100
5840: , p6_a36 JTF_DATE_TABLE
5841: , p6_a37 JTF_VARCHAR2_TABLE_300
5842: , p6_a38 JTF_NUMBER_TABLE
5843: , p6_a39 JTF_NUMBER_TABLE
5844: , p6_a40 JTF_NUMBER_TABLE
5845: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 6121: , p5_a16 JTF_VARCHAR2_TABLE_300

6117: , p5_a12 JTF_NUMBER_TABLE
6118: , p5_a13 JTF_VARCHAR2_TABLE_2000
6119: , p5_a14 JTF_VARCHAR2_TABLE_2000
6120: , p5_a15 JTF_VARCHAR2_TABLE_2000
6121: , p5_a16 JTF_VARCHAR2_TABLE_300
6122: , p5_a17 JTF_VARCHAR2_TABLE_100
6123: , p5_a18 JTF_NUMBER_TABLE
6124: , p5_a19 JTF_NUMBER_TABLE
6125: , p5_a20 JTF_NUMBER_TABLE

Line 6232: , p6_a37 JTF_VARCHAR2_TABLE_300

6228: , p6_a33 JTF_NUMBER_TABLE
6229: , p6_a34 JTF_DATE_TABLE
6230: , p6_a35 JTF_VARCHAR2_TABLE_100
6231: , p6_a36 JTF_DATE_TABLE
6232: , p6_a37 JTF_VARCHAR2_TABLE_300
6233: , p6_a38 JTF_NUMBER_TABLE
6234: , p6_a39 JTF_NUMBER_TABLE
6235: , p6_a40 JTF_NUMBER_TABLE
6236: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 6511: , p5_a16 JTF_VARCHAR2_TABLE_300

6507: , p5_a12 JTF_NUMBER_TABLE
6508: , p5_a13 JTF_VARCHAR2_TABLE_2000
6509: , p5_a14 JTF_VARCHAR2_TABLE_2000
6510: , p5_a15 JTF_VARCHAR2_TABLE_2000
6511: , p5_a16 JTF_VARCHAR2_TABLE_300
6512: , p5_a17 JTF_VARCHAR2_TABLE_100
6513: , p5_a18 JTF_NUMBER_TABLE
6514: , p5_a19 JTF_NUMBER_TABLE
6515: , p5_a20 JTF_NUMBER_TABLE

Line 6622: , p6_a37 JTF_VARCHAR2_TABLE_300

6618: , p6_a33 JTF_NUMBER_TABLE
6619: , p6_a34 JTF_DATE_TABLE
6620: , p6_a35 JTF_VARCHAR2_TABLE_100
6621: , p6_a36 JTF_DATE_TABLE
6622: , p6_a37 JTF_VARCHAR2_TABLE_300
6623: , p6_a38 JTF_NUMBER_TABLE
6624: , p6_a39 JTF_NUMBER_TABLE
6625: , p6_a40 JTF_NUMBER_TABLE
6626: , p6_a41 JTF_VARCHAR2_TABLE_100

Line 6953: , x_hdr_tbl out nocopy JTF_VARCHAR2_TABLE_300

6949: , p_custid NUMBER
6950: , p_invorgid NUMBER
6951: , p_oldokl_status VARCHAR2
6952: , p_oldokc_status VARCHAR2
6953: , x_hdr_tbl out nocopy JTF_VARCHAR2_TABLE_300
6954: );
6955: end okl_contract_pvt_w;