DBA Data[Home] [Help]

APPS.OKL_PROCESS_TMPLTS_PUB_W dependencies on OKL_PROCESS_TMPLTS_PUB

Line 1: package body okl_process_tmplts_pub_w as

1: package body okl_process_tmplts_pub_w as
2: /* $Header: OKLUPTMB.pls 120.2 2007/06/11 11:44:37 sosharma 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 97: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;

93: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
94: )
95:
96: as
97: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
98: ddx_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
99: ddindx binary_integer; indx binary_integer;
100: begin
101:

Line 98: ddx_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;

94: )
95:
96: as
97: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
98: ddx_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
99: ddindx binary_integer; indx binary_integer;
100: begin
101:
102: -- copy data to the local IN or IN-OUT args, if any

Line 144: okl_process_tmplts_pub.insert_process_tmplts(p_api_version,

140: );
141:
142:
143: -- here's the delegated call to the old PL/SQL routine
144: okl_process_tmplts_pub.insert_process_tmplts(p_api_version,
145: p_init_msg_list,
146: x_return_status,
147: x_msg_count,
148: x_msg_data,

Line 266: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;

262: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
263: )
264:
265: as
266: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
267: ddx_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
268: ddindx binary_integer; indx binary_integer;
269: begin
270:

Line 267: ddx_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;

263: )
264:
265: as
266: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
267: ddx_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
268: ddindx binary_integer; indx binary_integer;
269: begin
270:
271: -- copy data to the local IN or IN-OUT args, if any

Line 312: okl_process_tmplts_pub.insert_process_tmplts(p_api_version,

308: ddp_ptmv_rec.xml_tmplt_code := p5_a31;
309:
310:
311: -- here's the delegated call to the old PL/SQL routine
312: okl_process_tmplts_pub.insert_process_tmplts(p_api_version,
313: p_init_msg_list,
314: x_return_status,
315: x_msg_count,
316: x_msg_data,

Line 401: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;

397: , p5_a31 JTF_VARCHAR2_TABLE_100
398: )
399:
400: as
401: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
402: ddindx binary_integer; indx binary_integer;
403: begin
404:
405: -- copy data to the local IN or IN-OUT args, if any

Line 446: okl_process_tmplts_pub.lock_process_tmplts(p_api_version,

442: , p5_a31
443: );
444:
445: -- here's the delegated call to the old PL/SQL routine
446: okl_process_tmplts_pub.lock_process_tmplts(p_api_version,
447: p_init_msg_list,
448: x_return_status,
449: x_msg_count,
450: x_msg_data,

Line 501: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;

497: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
498: )
499:
500: as
501: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
502: ddindx binary_integer; indx binary_integer;
503: begin
504:
505: -- copy data to the local IN or IN-OUT args, if any

Line 545: okl_process_tmplts_pub.lock_process_tmplts(p_api_version,

541: ddp_ptmv_rec.recipient_type_code := p5_a30;
542: ddp_ptmv_rec.xml_tmplt_code := p5_a31;
543:
544: -- here's the delegated call to the old PL/SQL routine
545: okl_process_tmplts_pub.lock_process_tmplts(p_api_version,
546: p_init_msg_list,
547: x_return_status,
548: x_msg_count,
549: x_msg_data,

Line 632: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;

628: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
629: )
630:
631: as
632: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
633: ddx_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
634: ddindx binary_integer; indx binary_integer;
635: begin
636:

Line 633: ddx_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;

629: )
630:
631: as
632: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
633: ddx_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
634: ddindx binary_integer; indx binary_integer;
635: begin
636:
637: -- copy data to the local IN or IN-OUT args, if any

Line 679: okl_process_tmplts_pub.update_process_tmplts(p_api_version,

675: );
676:
677:
678: -- here's the delegated call to the old PL/SQL routine
679: okl_process_tmplts_pub.update_process_tmplts(p_api_version,
680: p_init_msg_list,
681: x_return_status,
682: x_msg_count,
683: x_msg_data,

Line 801: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;

797: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
798: )
799:
800: as
801: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
802: ddx_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
803: ddindx binary_integer; indx binary_integer;
804: begin
805:

Line 802: ddx_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;

798: )
799:
800: as
801: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
802: ddx_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
803: ddindx binary_integer; indx binary_integer;
804: begin
805:
806: -- copy data to the local IN or IN-OUT args, if any

Line 847: okl_process_tmplts_pub.update_process_tmplts(p_api_version,

843: ddp_ptmv_rec.xml_tmplt_code := p5_a31;
844:
845:
846: -- here's the delegated call to the old PL/SQL routine
847: okl_process_tmplts_pub.update_process_tmplts(p_api_version,
848: p_init_msg_list,
849: x_return_status,
850: x_msg_count,
851: x_msg_data,

Line 936: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;

932: , p5_a31 JTF_VARCHAR2_TABLE_100
933: )
934:
935: as
936: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
937: ddindx binary_integer; indx binary_integer;
938: begin
939:
940: -- copy data to the local IN or IN-OUT args, if any

Line 981: okl_process_tmplts_pub.delete_process_tmplts(p_api_version,

977: , p5_a31
978: );
979:
980: -- here's the delegated call to the old PL/SQL routine
981: okl_process_tmplts_pub.delete_process_tmplts(p_api_version,
982: p_init_msg_list,
983: x_return_status,
984: x_msg_count,
985: x_msg_data,

Line 1036: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;

1032: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1033: )
1034:
1035: as
1036: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
1037: ddindx binary_integer; indx binary_integer;
1038: begin
1039:
1040: -- copy data to the local IN or IN-OUT args, if any

Line 1080: okl_process_tmplts_pub.delete_process_tmplts(p_api_version,

1076: ddp_ptmv_rec.recipient_type_code := p5_a30;
1077: ddp_ptmv_rec.xml_tmplt_code := p5_a31;
1078:
1079: -- here's the delegated call to the old PL/SQL routine
1080: okl_process_tmplts_pub.delete_process_tmplts(p_api_version,
1081: p_init_msg_list,
1082: x_return_status,
1083: x_msg_count,
1084: x_msg_data,

Line 1135: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;

1131: , p5_a31 JTF_VARCHAR2_TABLE_100
1132: )
1133:
1134: as
1135: ddp_ptmv_tbl okl_process_tmplts_pub.ptmv_tbl_type;
1136: ddindx binary_integer; indx binary_integer;
1137: begin
1138:
1139: -- copy data to the local IN or IN-OUT args, if any

Line 1180: okl_process_tmplts_pub.validate_process_tmplts(p_api_version,

1176: , p5_a31
1177: );
1178:
1179: -- here's the delegated call to the old PL/SQL routine
1180: okl_process_tmplts_pub.validate_process_tmplts(p_api_version,
1181: p_init_msg_list,
1182: x_return_status,
1183: x_msg_count,
1184: x_msg_data,

Line 1235: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;

1231: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1232: )
1233:
1234: as
1235: ddp_ptmv_rec okl_process_tmplts_pub.ptmv_rec_type;
1236: ddindx binary_integer; indx binary_integer;
1237: begin
1238:
1239: -- copy data to the local IN or IN-OUT args, if any

Line 1279: okl_process_tmplts_pub.validate_process_tmplts(p_api_version,

1275: ddp_ptmv_rec.recipient_type_code := p5_a30;
1276: ddp_ptmv_rec.xml_tmplt_code := p5_a31;
1277:
1278: -- here's the delegated call to the old PL/SQL routine
1279: okl_process_tmplts_pub.validate_process_tmplts(p_api_version,
1280: p_init_msg_list,
1281: x_return_status,
1282: x_msg_count,
1283: x_msg_data,

Line 1294: end okl_process_tmplts_pub_w;

1290:
1291:
1292: end;
1293:
1294: end okl_process_tmplts_pub_w;