DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG_W dependencies on AP_VENDOR_PUB_PKG

Line 1: package body ap_vendor_pub_pkg_w as

1: package body ap_vendor_pub_pkg_w as
2: /* $Header: appvndwb.pls 120.0.12000000.1 2007/04/24 19:05:31 xili noship $ */
3: --Global constants for logging
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_VENDOR_PUB_PKG_W';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_VENDOR_PUB_PKG_W';

1: package body ap_vendor_pub_pkg_w as
2: /* $Header: appvndwb.pls 120.0.12000000.1 2007/04/24 19:05:31 xili noship $ */
3: --Global constants for logging
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_VENDOR_PUB_PKG_W';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_VENDOR_PUB_PKG_W';

16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_VENDOR_PUB_PKG_W';
21:
22: G_Vendor_Type_Lookup_Code VARCHAR2(30);
23:
24: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');

Line 187: ddp_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

183: , x_party_id out nocopy NUMBER
184: )
185:
186: as
187: ddp_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
188: ddindx binary_integer; indx binary_integer;
189: begin
190:
191: -- copy data to the local IN or IN-OUT args, if any

Line 341: ap_vendor_pub_pkg.create_vendor(p_api_version,

337:
338:
339:
340: -- here's the delegated call to the old PL/SQL routine
341: ap_vendor_pub_pkg.create_vendor(p_api_version,
342: p_init_msg_list,
343: p_commit,
344: p_validation_level,
345: x_return_status,

Line 513: ddp_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

509: , p_vendor_id NUMBER
510: )
511:
512: as
513: ddp_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
514: ddindx binary_integer; indx binary_integer;
515: l_debug_info VARCHAR2(2000);
516: l_api_name CONSTANT VARCHAR2(30) := 'Update_Vendor_W';
517: begin

Line 681: ap_vendor_pub_pkg.update_vendor(p_api_version,

677:
678: -- xili - test end
679:
680: -- here's the delegated call to the old PL/SQL routine
681: ap_vendor_pub_pkg.update_vendor(p_api_version,
682: p_init_msg_list,
683: p_commit,
684: p_validation_level,
685: x_return_status,

Line 854: ddp_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

850: , p_vendor_id NUMBER
851: )
852:
853: as
854: ddp_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
855: ddindx binary_integer; indx binary_integer;
856: begin
857:
858: -- copy data to the local IN or IN-OUT args, if any

Line 1011: ap_vendor_pub_pkg.validate_vendor(p_api_version,

1007:
1008:
1009:
1010: -- here's the delegated call to the old PL/SQL routine
1011: ap_vendor_pub_pkg.validate_vendor(p_api_version,
1012: p_init_msg_list,
1013: p_commit,
1014: p_validation_level,
1015: x_return_status,

Line 1346: ddp_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

1342: , x_location_id out nocopy NUMBER
1343: )
1344:
1345: as
1346: ddp_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
1347: ddindx binary_integer; indx binary_integer;
1348: begin
1349:
1350: -- copy data to the local IN or IN-OUT args, if any

Line 1518: ap_vendor_pub_pkg.create_vendor_site(p_api_version,

1514:
1515:
1516:
1517: -- here's the delegated call to the old PL/SQL routine
1518: ap_vendor_pub_pkg.create_vendor_site(p_api_version,
1519: p_init_msg_list,
1520: p_commit,
1521: p_validation_level,
1522: x_return_status,

Line 1709: ddp_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

1705: , p_vendor_site_id NUMBER
1706: )
1707:
1708: as
1709: ddp_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
1710: ddindx binary_integer; indx binary_integer;
1711: l_debug_info VARCHAR2(2000);
1712: l_api_name CONSTANT VARCHAR2(30) := 'Update_Vendor_W';
1713: begin

Line 1889: ap_vendor_pub_pkg.update_vendor_site(p_api_version,

1885: END IF;
1886: -- xili - test end
1887:
1888: -- here's the delegated call to the old PL/SQL routine
1889: ap_vendor_pub_pkg.update_vendor_site(p_api_version,
1890: p_init_msg_list,
1891: p_commit,
1892: p_validation_level,
1893: x_return_status,

Line 2081: ddp_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

2077: , p_vendor_site_id NUMBER
2078: )
2079:
2080: as
2081: ddp_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
2082: ddindx binary_integer; indx binary_integer;
2083: begin
2084:
2085: -- copy data to the local IN or IN-OUT args, if any

Line 2256: ap_vendor_pub_pkg.validate_vendor_site(p_api_version,

2252:
2253:
2254:
2255: -- here's the delegated call to the old PL/SQL routine
2256: ap_vendor_pub_pkg.validate_vendor_site(p_api_version,
2257: p_init_msg_list,
2258: p_commit,
2259: p_validation_level,
2260: x_return_status,

Line 2508: ddp_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;

2504: , x_party_site_id out nocopy NUMBER
2505: )
2506:
2507: as
2508: ddp_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
2509: ddindx binary_integer; indx binary_integer;
2510: begin
2511:
2512: -- copy data to the local IN or IN-OUT args, if any

Line 2578: ap_vendor_pub_pkg.create_vendor_contact(p_api_version,

2574:
2575:
2576:
2577: -- here's the delegated call to the old PL/SQL routine
2578: ap_vendor_pub_pkg.create_vendor_contact(p_api_version,
2579: p_init_msg_list,
2580: p_commit,
2581: p_validation_level,
2582: x_return_status,

Line 2669: ddp_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;

2665: , x_msg_data out nocopy VARCHAR2
2666: )
2667:
2668: as
2669: ddp_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
2670: ddindx binary_integer; indx binary_integer;
2671: begin
2672:
2673: -- copy data to the local IN or IN-OUT args, if any

Line 2733: ap_vendor_pub_pkg.update_vendor_contact(p_api_version,

2729:
2730:
2731:
2732: -- here's the delegated call to the old PL/SQL routine
2733: ap_vendor_pub_pkg.update_vendor_contact(p_api_version,
2734: p_init_msg_list,
2735: p_commit,
2736: p_validation_level,
2737: ddp_vendor_contact_rec,

Line 2819: ddp_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;

2815: , x_party_site_valid out nocopy VARCHAR2
2816: )
2817:
2818: as
2819: ddp_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
2820: ddindx binary_integer; indx binary_integer;
2821: begin
2822:
2823: -- copy data to the local IN or IN-OUT args, if any

Line 2890: ap_vendor_pub_pkg.validate_vendor_contact(p_api_version,

2886:
2887:
2888:
2889: -- here's the delegated call to the old PL/SQL routine
2890: ap_vendor_pub_pkg.validate_vendor_contact(p_api_version,
2891: p_init_msg_list,
2892: p_commit,
2893: p_validation_level,
2894: x_return_status,

Line 2973: end ap_vendor_pub_pkg_w;

2969:
2970:
2971: end;
2972:
2973: end ap_vendor_pub_pkg_w;