eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ACT_OFFERS_PVT_W dependencies on OZF_ACT_OFFERS_PVT

Line 1: package body ozf_act_offers_pvt_w as

1: package body ozf_act_offers_pvt_w as
2: /* $Header: ozfwoffb.pls 120.1 2005/06/06 15:00:50 appldev $ */
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:

Line 46: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;

42: , p7_a13 NUMBER := 0-1962.0724
43: , x_act_offer_id out NOCOPY NUMBER
44: )
45: as
46: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;
47: ddindx binary_integer; indx binary_integer;
48: begin
49:
50: -- copy data to the local IN or IN-OUT args, if any

Line 75: ozf_act_offers_pvt.create_act_offer(p_api_version,

71: ddp_act_offer_rec.security_group_id := rosetta_g_miss_num_map(p7_a13);
72:
73:
74: -- here's the delegated call to the old PL/SQL routine
75: ozf_act_offers_pvt.create_act_offer(p_api_version,
76: p_init_msg_list,
77: p_commit,
78: p_validation_level,
79: x_return_status,

Line 119: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;

115: , p7_a12 NUMBER := 0-1962.0724
116: , p7_a13 NUMBER := 0-1962.0724
117: )
118: as
119: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;
120: ddindx binary_integer; indx binary_integer;
121: begin
122:
123: -- copy data to the local IN or IN-OUT args, if any

Line 147: ozf_act_offers_pvt.update_act_offer(p_api_version,

143: ddp_act_offer_rec.qp_list_header_id := rosetta_g_miss_num_map(p7_a12);
144: ddp_act_offer_rec.security_group_id := rosetta_g_miss_num_map(p7_a13);
145:
146: -- here's the delegated call to the old PL/SQL routine
147: ozf_act_offers_pvt.update_act_offer(p_api_version,
148: p_init_msg_list,
149: p_commit,
150: p_validation_level,
151: x_return_status,

Line 188: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;

184: , p6_a12 NUMBER := 0-1962.0724
185: , p6_a13 NUMBER := 0-1962.0724
186: )
187: as
188: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;
189: ddindx binary_integer; indx binary_integer;
190: begin
191:
192: -- copy data to the local IN or IN-OUT args, if any

Line 215: ozf_act_offers_pvt.validate_act_offer(p_api_version,

211: ddp_act_offer_rec.qp_list_header_id := rosetta_g_miss_num_map(p6_a12);
212: ddp_act_offer_rec.security_group_id := rosetta_g_miss_num_map(p6_a13);
213:
214: -- here's the delegated call to the old PL/SQL routine
215: ozf_act_offers_pvt.validate_act_offer(p_api_version,
216: p_init_msg_list,
217: p_validation_level,
218: x_return_status,
219: x_msg_count,

Line 250: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;

246: , p2_a12 NUMBER := 0-1962.0724
247: , p2_a13 NUMBER := 0-1962.0724
248: )
249: as
250: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;
251: ddindx binary_integer; indx binary_integer;
252: begin
253:
254: -- copy data to the local IN or IN-OUT args, if any

Line 273: ozf_act_offers_pvt.check_items(p_validation_mode,

269: ddp_act_offer_rec.qp_list_header_id := rosetta_g_miss_num_map(p2_a12);
270: ddp_act_offer_rec.security_group_id := rosetta_g_miss_num_map(p2_a13);
271:
272: -- here's the delegated call to the old PL/SQL routine
273: ozf_act_offers_pvt.check_items(p_validation_mode,
274: x_return_status,
275: ddp_act_offer_rec);
276:
277: -- copy data back from the local OUT or IN-OUT args, if any

Line 313: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;

309: , p1_a13 NUMBER
310: , x_return_status out NOCOPY VARCHAR2
311: )
312: as
313: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;
314: ddp_complete_rec ozf_act_offers_pvt.act_offer_rec_type;
315: ddindx binary_integer; indx binary_integer;
316: begin
317:

Line 314: ddp_complete_rec ozf_act_offers_pvt.act_offer_rec_type;

310: , x_return_status out NOCOPY VARCHAR2
311: )
312: as
313: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;
314: ddp_complete_rec ozf_act_offers_pvt.act_offer_rec_type;
315: ddindx binary_integer; indx binary_integer;
316: begin
317:
318: -- copy data to the local IN or IN-OUT args, if any

Line 351: ozf_act_offers_pvt.check_record(ddp_act_offer_rec,

347: ddp_complete_rec.security_group_id := rosetta_g_miss_num_map(p1_a13);
348:
349:
350: -- here's the delegated call to the old PL/SQL routine
351: ozf_act_offers_pvt.check_record(ddp_act_offer_rec,
352: ddp_complete_rec,
353: x_return_status);
354:
355: -- copy data back from the local OUT or IN-OUT args, if any

Line 390: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;

386: , p1_a12 out NOCOPY NUMBER
387: , p1_a13 out NOCOPY NUMBER
388: )
389: as
390: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;
391: ddx_complete_rec ozf_act_offers_pvt.act_offer_rec_type;
392: ddindx binary_integer; indx binary_integer;
393: begin
394:

Line 391: ddx_complete_rec ozf_act_offers_pvt.act_offer_rec_type;

387: , p1_a13 out NOCOPY NUMBER
388: )
389: as
390: ddp_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;
391: ddx_complete_rec ozf_act_offers_pvt.act_offer_rec_type;
392: ddindx binary_integer; indx binary_integer;
393: begin
394:
395: -- copy data to the local IN or IN-OUT args, if any

Line 413: ozf_act_offers_pvt.complete_rec(ddp_act_offer_rec,

409: ddp_act_offer_rec.security_group_id := rosetta_g_miss_num_map(p0_a13);
410:
411:
412: -- here's the delegated call to the old PL/SQL routine
413: ozf_act_offers_pvt.complete_rec(ddp_act_offer_rec,
414: ddx_complete_rec);
415:
416: -- copy data back from the local OUT or IN-OUT args, if any
417:

Line 450: ddx_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;

446: , p0_a12 out NOCOPY NUMBER
447: , p0_a13 out NOCOPY NUMBER
448: )
449: as
450: ddx_act_offer_rec ozf_act_offers_pvt.act_offer_rec_type;
451: ddindx binary_integer; indx binary_integer;
452: begin
453:
454: -- copy data to the local IN or IN-OUT args, if any

Line 457: ozf_act_offers_pvt.init_rec(ddx_act_offer_rec);

453:
454: -- copy data to the local IN or IN-OUT args, if any
455:
456: -- here's the delegated call to the old PL/SQL routine
457: ozf_act_offers_pvt.init_rec(ddx_act_offer_rec);
458:
459: -- copy data back from the local OUT or IN-OUT args, if any
460: p0_a0 := rosetta_g_miss_num_map(ddx_act_offer_rec.activity_offer_id);
461: p0_a1 := ddx_act_offer_rec.last_update_date;

Line 476: end ozf_act_offers_pvt_w;

472: p0_a12 := rosetta_g_miss_num_map(ddx_act_offer_rec.qp_list_header_id);
473: p0_a13 := rosetta_g_miss_num_map(ddx_act_offer_rec.security_group_id);
474: end;
475:
476: end ozf_act_offers_pvt_w;