DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT_W dependencies on OZF_ACTBUDGETS_PVT

Line 1: package body ozf_actbudgets_pvt_w as

1: package body ozf_actbudgets_pvt_w as
2: /* $Header: ozfwbdgb.pls 120.6 2008/08/14 15:45:03 nirprasa 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 88: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

84: , x_act_budget_id out nocopy NUMBER
85: )
86:
87: as
88: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
89: ddindx binary_integer; indx binary_integer;
90: begin
91:
92: -- copy data to the local IN or IN-OUT args, if any

Line 164: ozf_actbudgets_pvt.create_act_budgets(p_api_version,

160: ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
161:
162:
163: -- here's the delegated call to the old PL/SQL routine
164: ozf_actbudgets_pvt.create_act_budgets(p_api_version,
165: p_init_msg_list,
166: p_commit,
167: p_validation_level,
168: x_return_status,

Line 303: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

299: , p_approval_flag VARCHAR2
300: )
301:
302: as
303: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
304: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
305: ddindx binary_integer; indx binary_integer;
306: begin
307:

Line 304: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

300: )
301:
302: as
303: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
304: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
305: ddindx binary_integer; indx binary_integer;
306: begin
307:
308: -- copy data to the local IN or IN-OUT args, if any

Line 427: ozf_actbudgets_pvt.create_act_budgets(p_api_version,

423:
424:
425:
426: -- here's the delegated call to the old PL/SQL routine
427: ozf_actbudgets_pvt.create_act_budgets(p_api_version,
428: p_init_msg_list,
429: p_commit,
430: p_validation_level,
431: x_return_status,

Line 571: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

567: , x_utilized_amount out nocopy NUMBER
568: )
569:
570: as
571: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
572: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
573: ddindx binary_integer; indx binary_integer;
574: begin
575:

Line 572: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

568: )
569:
570: as
571: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
572: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
573: ddindx binary_integer; indx binary_integer;
574: begin
575:
576: -- copy data to the local IN or IN-OUT args, if any

Line 696: ozf_actbudgets_pvt.create_act_budgets(p_api_version,

692:
693:
694:
695: -- here's the delegated call to the old PL/SQL routine
696: ozf_actbudgets_pvt.create_act_budgets(p_api_version,
697: p_init_msg_list,
698: p_commit,
699: p_validation_level,
700: x_return_status,

Line 794: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

790: , p7_a60 NUMBER
791: )
792:
793: as
794: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
795: ddindx binary_integer; indx binary_integer;
796: begin
797:
798: -- copy data to the local IN or IN-OUT args, if any

Line 869: ozf_actbudgets_pvt.update_act_budgets(p_api_version,

865: ddp_act_budgets_rec.attribute15 := p7_a59;
866: ddp_act_budgets_rec.src_curr_req_amt := p7_a60;
867:
868: -- here's the delegated call to the old PL/SQL routine
869: ozf_actbudgets_pvt.update_act_budgets(p_api_version,
870: p_init_msg_list,
871: p_commit,
872: p_validation_level,
873: x_return_status,

Line 1011: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1007: , p15_a44 VARCHAR2
1008: )
1009:
1010: as
1011: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1012: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1013: ddindx binary_integer; indx binary_integer;
1014: begin
1015:

Line 1012: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1008: )
1009:
1010: as
1011: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1012: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1013: ddindx binary_integer; indx binary_integer;
1014: begin
1015:
1016: -- copy data to the local IN or IN-OUT args, if any

Line 1140: ozf_actbudgets_pvt.update_act_budgets(p_api_version,

1136: ddp_act_util_rec.attribute14 := p15_a43;
1137: ddp_act_util_rec.attribute15 := p15_a44;
1138:
1139: -- here's the delegated call to the old PL/SQL routine
1140: ozf_actbudgets_pvt.update_act_budgets(p_api_version,
1141: p_init_msg_list,
1142: p_commit,
1143: p_validation_level,
1144: x_return_status,

Line 1299: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1295: , x_utilized_amount out nocopy NUMBER
1296: )
1297:
1298: as
1299: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1300: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1301: ddindx binary_integer; indx binary_integer;
1302: begin
1303:

Line 1300: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1296: )
1297:
1298: as
1299: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1300: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1301: ddindx binary_integer; indx binary_integer;
1302: begin
1303:
1304: -- copy data to the local IN or IN-OUT args, if any

Line 1429: ozf_actbudgets_pvt.update_act_budgets(p_api_version,

1425: ddp_act_util_rec.attribute15 := p15_a44;
1426:
1427:
1428: -- here's the delegated call to the old PL/SQL routine
1429: ozf_actbudgets_pvt.update_act_budgets(p_api_version,
1430: p_init_msg_list,
1431: p_commit,
1432: p_validation_level,
1433: x_return_status,

Line 1584: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1580: , p10_a44 VARCHAR2
1581: )
1582:
1583: as
1584: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1585: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1586: ddindx binary_integer; indx binary_integer;
1587: begin
1588:

Line 1585: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1581: )
1582:
1583: as
1584: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1585: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1586: ddindx binary_integer; indx binary_integer;
1587: begin
1588:
1589: -- copy data to the local IN or IN-OUT args, if any

Line 1708: ozf_actbudgets_pvt.update_act_budgets(p_api_version,

1704: ddp_act_util_rec.attribute14 := p10_a43;
1705: ddp_act_util_rec.attribute15 := p10_a44;
1706:
1707: -- here's the delegated call to the old PL/SQL routine
1708: ozf_actbudgets_pvt.update_act_budgets(p_api_version,
1709: p_init_msg_list,
1710: p_commit,
1711: p_validation_level,
1712: x_return_status,

Line 1852: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1848: , x_utilized_amount out nocopy NUMBER
1849: )
1850:
1851: as
1852: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1853: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1854: ddindx binary_integer; indx binary_integer;
1855: begin
1856:

Line 1853: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1849: )
1850:
1851: as
1852: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1853: ddp_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1854: ddindx binary_integer; indx binary_integer;
1855: begin
1856:
1857: -- copy data to the local IN or IN-OUT args, if any

Line 1977: ozf_actbudgets_pvt.update_act_budgets(p_api_version,

1973: ddp_act_util_rec.attribute15 := p10_a44;
1974:
1975:
1976: -- here's the delegated call to the old PL/SQL routine
1977: ozf_actbudgets_pvt.update_act_budgets(p_api_version,
1978: p_init_msg_list,
1979: p_commit,
1980: p_validation_level,
1981: x_return_status,

Line 2074: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2070: , p6_a60 NUMBER
2071: )
2072:
2073: as
2074: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2075: ddindx binary_integer; indx binary_integer;
2076: begin
2077:
2078: -- copy data to the local IN or IN-OUT args, if any

Line 2148: ozf_actbudgets_pvt.validate_act_budgets(p_api_version,

2144: ddp_act_budgets_rec.attribute15 := p6_a59;
2145: ddp_act_budgets_rec.src_curr_req_amt := p6_a60;
2146:
2147: -- here's the delegated call to the old PL/SQL routine
2148: ozf_actbudgets_pvt.validate_act_budgets(p_api_version,
2149: p_init_msg_list,
2150: p_validation_level,
2151: x_return_status,
2152: x_msg_count,

Line 2231: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2227: , x_return_status out nocopy VARCHAR2
2228: )
2229:
2230: as
2231: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2232: ddindx binary_integer; indx binary_integer;
2233: begin
2234:
2235: -- copy data to the local IN or IN-OUT args, if any

Line 2301: ozf_actbudgets_pvt.validate_act_budgets_items(ddp_act_budgets_rec,

2297:
2298:
2299:
2300: -- here's the delegated call to the old PL/SQL routine
2301: ozf_actbudgets_pvt.validate_act_budgets_items(ddp_act_budgets_rec,
2302: p_validation_mode,
2303: x_return_status);
2304:
2305: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 2376: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2372: , x_return_status out nocopy VARCHAR2
2373: )
2374:
2375: as
2376: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2377: ddindx binary_integer; indx binary_integer;
2378: begin
2379:
2380: -- copy data to the local IN or IN-OUT args, if any

Line 2446: ozf_actbudgets_pvt.validate_act_budgets_record(ddp_act_budgets_rec,

2442:
2443:
2444:
2445: -- here's the delegated call to the old PL/SQL routine
2446: ozf_actbudgets_pvt.validate_act_budgets_record(ddp_act_budgets_rec,
2447: p_validation_mode,
2448: x_return_status);
2449:
2450: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 2580: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2576: , p1_a60 out nocopy NUMBER
2577: )
2578:
2579: as
2580: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2581: ddx_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2582: ddindx binary_integer; indx binary_integer;
2583: begin
2584:

Line 2581: ddx_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2577: )
2578:
2579: as
2580: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2581: ddx_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2582: ddindx binary_integer; indx binary_integer;
2583: begin
2584:
2585: -- copy data to the local IN or IN-OUT args, if any

Line 2650: ozf_actbudgets_pvt.complete_act_budgets_rec(ddp_act_budgets_rec,

2646: ddp_act_budgets_rec.src_curr_req_amt := p0_a60;
2647:
2648:
2649: -- here's the delegated call to the old PL/SQL routine
2650: ozf_actbudgets_pvt.complete_act_budgets_rec(ddp_act_budgets_rec,
2651: ddx_act_budgets_rec);
2652:
2653: -- copy data back from the local variables to OUT or IN-OUT args, if any
2654:

Line 2782: ddx_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2778: , p0_a60 out nocopy NUMBER
2779: )
2780:
2781: as
2782: ddx_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2783: ddindx binary_integer; indx binary_integer;
2784: begin
2785:
2786: -- copy data to the local IN or IN-OUT args, if any

Line 2789: ozf_actbudgets_pvt.init_act_budgets_rec(ddx_act_budgets_rec);

2785:
2786: -- copy data to the local IN or IN-OUT args, if any
2787:
2788: -- here's the delegated call to the old PL/SQL routine
2789: ozf_actbudgets_pvt.init_act_budgets_rec(ddx_act_budgets_rec);
2790:
2791: -- copy data back from the local variables to OUT or IN-OUT args, if any
2792: p0_a0 := ddx_act_budgets_rec.activity_budget_id;
2793: p0_a1 := ddx_act_budgets_rec.last_update_date;

Line 2923: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2919: , p_exchange_rate_type VARCHAR2
2920: )
2921:
2922: as
2923: ddp_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2924: ddindx binary_integer; indx binary_integer;
2925: begin
2926:
2927: -- copy data to the local IN or IN-OUT args, if any

Line 2995: ozf_actbudgets_pvt.create_child_act_budget(x_return_status,

2991: ddp_act_budgets_rec.src_curr_req_amt := p3_a60;
2992:
2993:
2994: -- here's the delegated call to the old PL/SQL routine
2995: ozf_actbudgets_pvt.create_child_act_budget(x_return_status,
2996: x_msg_count,
2997: x_msg_data,
2998: ddp_act_budgets_rec,
2999: p_exchange_rate_type);

Line 3008: end ozf_actbudgets_pvt_w;

3004:
3005:
3006: end;
3007:
3008: end ozf_actbudgets_pvt_w;