[Home] [Help]
1: package body ozf_offer_adj_line_pvt_w as
2: /* $Header: ozfwoalb.pls 120.1 2005/09/26 17:59 rssharma noship $ */
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:
18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_adj_line_pvt.offadj_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
75: end loop;
76: end if;
77: end if;
78: end rosetta_table_copy_in_p2;
79: procedure rosetta_table_copy_out_p2(t ozf_offer_adj_line_pvt.offadj_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_NUMBER_TABLE
81: , a2 out nocopy JTF_NUMBER_TABLE
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_NUMBER_TABLE
194: end if;
195: end if;
196: end rosetta_table_copy_out_p2;
197:
198: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_adj_line_pvt.offadj_new_line_tbl_type, a0 JTF_NUMBER_TABLE
199: , a1 JTF_NUMBER_TABLE
200: , a2 JTF_NUMBER_TABLE
201: , a3 JTF_NUMBER_TABLE
202: , a4 JTF_VARCHAR2_TABLE_100
325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p6;
329: procedure rosetta_table_copy_out_p6(t ozf_offer_adj_line_pvt.offadj_new_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_NUMBER_TABLE
331: , a2 out nocopy JTF_NUMBER_TABLE
332: , a3 out nocopy JTF_NUMBER_TABLE
333: , a4 out nocopy JTF_VARCHAR2_TABLE_100
660: , p7_a19 DATE := fnd_api.g_miss_date
661: )
662:
663: as
664: ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
665: ddindx binary_integer; indx binary_integer;
666: begin
667:
668: -- copy data to the local IN or IN-OUT args, if any
695: ddp_offadj_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p7_a19);
696:
697:
698: -- here's the delegated call to the old PL/SQL routine
699: ozf_offer_adj_line_pvt.create_offer_adj_line(p_api_version_number,
700: p_init_msg_list,
701: p_commit,
702: p_validation_level,
703: x_return_status,
784: , p7_a56 DATE := fnd_api.g_miss_date
785: )
786:
787: as
788: ddp_list_line_rec ozf_offer_adj_line_pvt.offadj_new_line_rec_type;
789: ddindx binary_integer; indx binary_integer;
790: begin
791:
792: -- copy data to the local IN or IN-OUT args, if any
856: ddp_list_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p7_a56);
857:
858:
859: -- here's the delegated call to the old PL/SQL routine
860: ozf_offer_adj_line_pvt.create_new_offer_adj_line(p_api_version_number,
861: p_init_msg_list,
862: p_commit,
863: p_validation_level,
864: x_return_status,
908: , p7_a19 DATE := fnd_api.g_miss_date
909: )
910:
911: as
912: ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
913: ddindx binary_integer; indx binary_integer;
914: begin
915:
916: -- copy data to the local IN or IN-OUT args, if any
943: ddp_offadj_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p7_a19);
944:
945:
946: -- here's the delegated call to the old PL/SQL routine
947: ozf_offer_adj_line_pvt.update_offer_adj_line(p_api_version_number,
948: p_init_msg_list,
949: p_commit,
950: p_validation_level,
951: x_return_status,
1032: , p7_a56 DATE := fnd_api.g_miss_date
1033: )
1034:
1035: as
1036: ddp_list_line_rec ozf_offer_adj_line_pvt.offadj_new_line_rec_type;
1037: ddindx binary_integer; indx binary_integer;
1038: begin
1039: ozf_utility_pvt.debug_message('EndDateActive in Rosetta:'||p7_a56);
1040: -- copy data to the local IN or IN-OUT args, if any
1104: ddp_list_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p7_a56);
1105:
1106:
1107: -- here's the delegated call to the old PL/SQL routine
1108: ozf_offer_adj_line_pvt.update_new_offer_adj_line(p_api_version_number,
1109: p_init_msg_list,
1110: p_commit,
1111: p_validation_level,
1112: x_return_status,
1155: , p3_a19 DATE := fnd_api.g_miss_date
1156: )
1157:
1158: as
1159: ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
1160: ddindx binary_integer; indx binary_integer;
1161: begin
1162:
1163: -- copy data to the local IN or IN-OUT args, if any
1189:
1190:
1191:
1192: -- here's the delegated call to the old PL/SQL routine
1193: ozf_offer_adj_line_pvt.validate_offer_adj_line(p_api_version_number,
1194: p_init_msg_list,
1195: p_validation_level,
1196: ddp_offadj_line_rec,
1197: p_validation_mode,
1233: , p0_a19 DATE := fnd_api.g_miss_date
1234: )
1235:
1236: as
1237: ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
1238: ddindx binary_integer; indx binary_integer;
1239: begin
1240:
1241: -- copy data to the local IN or IN-OUT args, if any
1262:
1263:
1264:
1265: -- here's the delegated call to the old PL/SQL routine
1266: ozf_offer_adj_line_pvt.check_offadj_line_items(ddp_offadj_line_rec,
1267: p_validation_mode,
1268: x_return_status);
1269:
1270: -- copy data back from the local variables to OUT or IN-OUT args, if any
1299: , p5_a19 DATE := fnd_api.g_miss_date
1300: )
1301:
1302: as
1303: ddp_offadj_line_rec ozf_offer_adj_line_pvt.offadj_line_rec_type;
1304: ddindx binary_integer; indx binary_integer;
1305: begin
1306:
1307: -- copy data to the local IN or IN-OUT args, if any
1331: ddp_offadj_line_rec.created_from_adjustments := p5_a18;
1332: ddp_offadj_line_rec.discount_end_date := rosetta_g_miss_date_in_map(p5_a19);
1333:
1334: -- here's the delegated call to the old PL/SQL routine
1335: ozf_offer_adj_line_pvt.validate_offadj_line_rec(p_api_version_number,
1336: p_init_msg_list,
1337: x_return_status,
1338: x_msg_count,
1339: x_msg_data,
1346:
1347:
1348: end;
1349:
1350: end ozf_offer_adj_line_pvt_w;