DBA Data[Home] [Help]

APPS.OZF_ACTMETRICFACT_PVT_W dependencies on OZF_ACTMETRICFACT_PVT

Line 1: package body ozf_actmetricfact_pvt_w as

1: package body ozf_actmetricfact_pvt_w as
2: /* $Header: ozfwamfb.pls 120.2 2006/06/02 09:50:18 inanaiah 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 124: ddx_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

120: , p0_a104 out nocopy NUMBER
121: )
122:
123: as
124: ddx_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
125: ddindx binary_integer; indx binary_integer;
126: begin
127:
128: -- copy data to the local IN or IN-OUT args, if any

Line 131: ozf_actmetricfact_pvt.init_actmetricfact_rec(ddx_fact_rec);

127:
128: -- copy data to the local IN or IN-OUT args, if any
129:
130: -- here's the delegated call to the old PL/SQL routine
131: ozf_actmetricfact_pvt.init_actmetricfact_rec(ddx_fact_rec);
132:
133: -- copy data back from the local variables to OUT or IN-OUT args, if any
134: p0_a0 := ddx_fact_rec.activity_metric_fact_id;
135: p0_a1 := ddx_fact_rec.last_update_date;

Line 357: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

353: , x_activity_metric_fact_id out nocopy NUMBER
354: )
355:
356: as
357: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
358: ddindx binary_integer; indx binary_integer;
359: begin
360:
361: -- copy data to the local IN or IN-OUT args, if any

Line 477: ozf_actmetricfact_pvt.create_actmetricfact(p_api_version,

473: ddp_act_metric_fact_rec.incremental_sales := p7_a104;
474:
475:
476: -- here's the delegated call to the old PL/SQL routine
477: ozf_actmetricfact_pvt.create_actmetricfact(p_api_version,
478: p_init_msg_list,
479: p_commit,
480: p_validation_level,
481: x_return_status,

Line 613: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

609: , p7_a104 NUMBER
610: )
611:
612: as
613: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
614: ddindx binary_integer; indx binary_integer;
615: begin
616:
617: -- copy data to the local IN or IN-OUT args, if any

Line 732: ozf_actmetricfact_pvt.update_actmetricfact(p_api_version,

728: ddp_act_metric_fact_rec.lift_factor := p7_a103;
729: ddp_act_metric_fact_rec.incremental_sales := p7_a104;
730:
731: -- here's the delegated call to the old PL/SQL routine
732: ozf_actmetricfact_pvt.update_actmetricfact(p_api_version,
733: p_init_msg_list,
734: p_commit,
735: p_validation_level,
736: x_return_status,

Line 865: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

861: , p6_a104 NUMBER
862: )
863:
864: as
865: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
866: ddindx binary_integer; indx binary_integer;
867: begin
868:
869: -- copy data to the local IN or IN-OUT args, if any

Line 983: ozf_actmetricfact_pvt.validate_actmetfact(p_api_version,

979: ddp_act_metric_fact_rec.lift_factor := p6_a103;
980: ddp_act_metric_fact_rec.incremental_sales := p6_a104;
981:
982: -- here's the delegated call to the old PL/SQL routine
983: ozf_actmetricfact_pvt.validate_actmetfact(p_api_version,
984: p_init_msg_list,
985: p_validation_level,
986: x_return_status,
987: x_msg_count,

Line 1110: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

1106: , x_return_status out nocopy VARCHAR2
1107: )
1108:
1109: as
1110: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
1111: ddindx binary_integer; indx binary_integer;
1112: begin
1113:
1114: -- copy data to the local IN or IN-OUT args, if any

Line 1224: ozf_actmetricfact_pvt.validate_actmetfact_items(ddp_act_metric_fact_rec,

1220:
1221:
1222:
1223: -- here's the delegated call to the old PL/SQL routine
1224: ozf_actmetricfact_pvt.validate_actmetfact_items(ddp_act_metric_fact_rec,
1225: p_validation_mode,
1226: x_return_status);
1227:
1228: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1447: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

1443: , x_return_status out nocopy VARCHAR2
1444: )
1445:
1446: as
1447: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
1448: ddp_complete_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
1449: ddindx binary_integer; indx binary_integer;
1450: begin
1451:

Line 1448: ddp_complete_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

1444: )
1445:
1446: as
1447: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
1448: ddp_complete_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
1449: ddindx binary_integer; indx binary_integer;
1450: begin
1451:
1452: -- copy data to the local IN or IN-OUT args, if any

Line 1667: ozf_actmetricfact_pvt.validate_actmetfact_rec(ddp_act_metric_fact_rec,

1663: ddp_complete_fact_rec.incremental_sales := p1_a104;
1664:
1665:
1666: -- here's the delegated call to the old PL/SQL routine
1667: ozf_actmetricfact_pvt.validate_actmetfact_rec(ddp_act_metric_fact_rec,
1668: ddp_complete_fact_rec,
1669: x_return_status);
1670:
1671: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1889: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

1885: , p1_a104 out nocopy NUMBER
1886: )
1887:
1888: as
1889: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
1890: ddx_complete_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
1891: ddindx binary_integer; indx binary_integer;
1892: begin
1893:

Line 1890: ddx_complete_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;

1886: )
1887:
1888: as
1889: ddp_act_metric_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
1890: ddx_complete_fact_rec ozf_actmetricfact_pvt.act_metric_fact_rec_type;
1891: ddindx binary_integer; indx binary_integer;
1892: begin
1893:
1894: -- copy data to the local IN or IN-OUT args, if any

Line 2003: ozf_actmetricfact_pvt.complete_actmetfact_rec(ddp_act_metric_fact_rec,

1999: ddp_act_metric_fact_rec.incremental_sales := p0_a104;
2000:
2001:
2002: -- here's the delegated call to the old PL/SQL routine
2003: ozf_actmetricfact_pvt.complete_actmetfact_rec(ddp_act_metric_fact_rec,
2004: ddx_complete_fact_rec);
2005:
2006: -- copy data back from the local variables to OUT or IN-OUT args, if any
2007:

Line 2137: ddp_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;

2133: , x_formula_id out nocopy NUMBER
2134: )
2135:
2136: as
2137: ddp_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;
2138: ddindx binary_integer; indx binary_integer;
2139: begin
2140:
2141: -- copy data to the local IN or IN-OUT args, if any

Line 2163: ozf_actmetricfact_pvt.create_formula(p_api_version,

2159: ddp_formula_rec.formula_type := p7_a10;
2160:
2161:
2162: -- here's the delegated call to the old PL/SQL routine
2163: ozf_actmetricfact_pvt.create_formula(p_api_version,
2164: p_init_msg_list,
2165: p_commit,
2166: p_validation_level,
2167: x_return_status,

Line 2204: ddp_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;

2200: , p6_a10 VARCHAR2
2201: )
2202:
2203: as
2204: ddp_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;
2205: ddindx binary_integer; indx binary_integer;
2206: begin
2207:
2208: -- copy data to the local IN or IN-OUT args, if any

Line 2228: ozf_actmetricfact_pvt.validate_formula(p_api_version,

2224: ddp_formula_rec.object_version_number := p6_a9;
2225: ddp_formula_rec.formula_type := p6_a10;
2226:
2227: -- here's the delegated call to the old PL/SQL routine
2228: ozf_actmetricfact_pvt.validate_formula(p_api_version,
2229: p_init_msg_list,
2230: p_validation_level,
2231: x_return_status,
2232: x_msg_count,

Line 2261: ddp_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;

2257: , x_return_status out nocopy VARCHAR2
2258: )
2259:
2260: as
2261: ddp_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;
2262: ddindx binary_integer; indx binary_integer;
2263: begin
2264:
2265: -- copy data to the local IN or IN-OUT args, if any

Line 2281: ozf_actmetricfact_pvt.validate_formula_items(ddp_formula_rec,

2277:
2278:
2279:
2280: -- here's the delegated call to the old PL/SQL routine
2281: ozf_actmetricfact_pvt.validate_formula_items(ddp_formula_rec,
2282: p_validation_mode,
2283: x_return_status);
2284:
2285: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 2316: ddp_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;

2312: , x_return_status out nocopy VARCHAR2
2313: )
2314:
2315: as
2316: ddp_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;
2317: ddp_complete_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;
2318: ddindx binary_integer; indx binary_integer;
2319: begin
2320:

Line 2317: ddp_complete_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;

2313: )
2314:
2315: as
2316: ddp_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;
2317: ddp_complete_formula_rec ozf_actmetricfact_pvt.ozf_formula_rec_type;
2318: ddindx binary_integer; indx binary_integer;
2319: begin
2320:
2321: -- copy data to the local IN or IN-OUT args, if any

Line 2348: ozf_actmetricfact_pvt.validate_formula_rec(ddp_formula_rec,

2344: ddp_complete_formula_rec.formula_type := p1_a10;
2345:
2346:
2347: -- here's the delegated call to the old PL/SQL routine
2348: ozf_actmetricfact_pvt.validate_formula_rec(ddp_formula_rec,
2349: ddp_complete_formula_rec,
2350: x_return_status);
2351:
2352: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 2381: ddp_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;

2377: , x_formula_entry_id out nocopy NUMBER
2378: )
2379:
2380: as
2381: ddp_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;
2382: ddindx binary_integer; indx binary_integer;
2383: begin
2384:
2385: -- copy data to the local IN or IN-OUT args, if any

Line 2409: ozf_actmetricfact_pvt.create_formula_entry(p_api_version,

2405: ddp_formula_entry_rec.object_version_number := p7_a12;
2406:
2407:
2408: -- here's the delegated call to the old PL/SQL routine
2409: ozf_actmetricfact_pvt.create_formula_entry(p_api_version,
2410: p_init_msg_list,
2411: p_commit,
2412: p_validation_level,
2413: x_return_status,

Line 2452: ddp_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;

2448: , p6_a12 NUMBER
2449: )
2450:
2451: as
2452: ddp_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;
2453: ddindx binary_integer; indx binary_integer;
2454: begin
2455:
2456: -- copy data to the local IN or IN-OUT args, if any

Line 2478: ozf_actmetricfact_pvt.validate_formula_entry(p_api_version,

2474: ddp_formula_entry_rec.last_update_login := p6_a11;
2475: ddp_formula_entry_rec.object_version_number := p6_a12;
2476:
2477: -- here's the delegated call to the old PL/SQL routine
2478: ozf_actmetricfact_pvt.validate_formula_entry(p_api_version,
2479: p_init_msg_list,
2480: p_validation_level,
2481: x_return_status,
2482: x_msg_count,

Line 2513: ddp_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;

2509: , x_return_status out nocopy VARCHAR2
2510: )
2511:
2512: as
2513: ddp_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;
2514: ddindx binary_integer; indx binary_integer;
2515: begin
2516:
2517: -- copy data to the local IN or IN-OUT args, if any

Line 2535: ozf_actmetricfact_pvt.validate_form_ent_items(ddp_formula_entry_rec,

2531:
2532:
2533:
2534: -- here's the delegated call to the old PL/SQL routine
2535: ozf_actmetricfact_pvt.validate_form_ent_items(ddp_formula_entry_rec,
2536: p_validation_mode,
2537: x_return_status);
2538:
2539: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 2574: ddp_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;

2570: , x_return_status out nocopy VARCHAR2
2571: )
2572:
2573: as
2574: ddp_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;
2575: ddp_complete_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;
2576: ddindx binary_integer; indx binary_integer;
2577: begin
2578:

Line 2575: ddp_complete_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;

2571: )
2572:
2573: as
2574: ddp_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;
2575: ddp_complete_formula_entry_rec ozf_actmetricfact_pvt.ozf_formula_entry_rec_type;
2576: ddindx binary_integer; indx binary_integer;
2577: begin
2578:
2579: -- copy data to the local IN or IN-OUT args, if any

Line 2610: ozf_actmetricfact_pvt.validate_form_ent_rec(ddp_formula_entry_rec,

2606: ddp_complete_formula_entry_rec.object_version_number := p1_a12;
2607:
2608:
2609: -- here's the delegated call to the old PL/SQL routine
2610: ozf_actmetricfact_pvt.validate_form_ent_rec(ddp_formula_entry_rec,
2611: ddp_complete_formula_entry_rec,
2612: x_return_status);
2613:
2614: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 2619: end ozf_actmetricfact_pvt_w;

2615:
2616:
2617: end;
2618:
2619: end ozf_actmetricfact_pvt_w;