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.POS_VENDOR_PUB_PKG dependencies on AP_VENDOR_PUB_PKG

Line 7: (p_vendor_rec IN ap_vendor_pub_pkg.r_vendor_rec_type, p_flow IN VARCHAR2)

3:
4: g_module_name VARCHAR2(30) := 'POS_VENDOR_PUB_PKG';
5:
6: PROCEDURE log_vendor_rec
7: (p_vendor_rec IN ap_vendor_pub_pkg.r_vendor_rec_type, p_flow IN VARCHAR2)
8: IS
9: BEGIN
10:
11: IF (fnd_log.level_procedure < fnd_log.g_current_runtime_level) THEN

Line 143: (p_vendor_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type, p_flow IN VARCHAR2)

139:
140: END log_vendor_rec;
141:
142: PROCEDURE log_vendor_site_rec
143: (p_vendor_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type, p_flow IN VARCHAR2)
144: IS
145: BEGIN
146: IF (fnd_log.level_procedure < fnd_log.g_current_runtime_level) THEN
147: RETURN;

Line 295: (px_vendor_rec IN OUT nocopy AP_VENDOR_PUB_PKG.r_vendor_rec_type)

291:
292: END log_vendor_site_rec;
293:
294: procedure hack_org_id
295: (px_vendor_rec IN OUT nocopy AP_VENDOR_PUB_PKG.r_vendor_rec_type)
296: IS
297: CURSOR l_cur IS
298: SELECT organization_id
299: FROM hr_operating_units m

Line 360: p_vendor_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,

356:
357:
358: PROCEDURE check_for_site_errors
359: (
360: p_vendor_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_count OUT NOCOPY NUMBER,
363: x_msg_data OUT NOCOPY VARCHAR2
364: )

Line 433: ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,

429:
430: END;
431:
432: PROCEDURE Create_Vendor
433: ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,
434: x_return_status OUT NOCOPY VARCHAR2,
435: x_msg_count OUT NOCOPY NUMBER,
436: x_msg_data OUT NOCOPY VARCHAR2,
437: x_vendor_id OUT NOCOPY NUMBER,

Line 441: l_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;

437: x_vendor_id OUT NOCOPY NUMBER,
438: x_party_id OUT NOCOPY NUMBER
439: ) IS
440: l_step VARCHAR2(100);
441: l_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;
442: --l_temp_party_id number;
443: l_party_usage_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
444: BEGIN
445:

Line 514: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor';

510: -- so set it here temporarily
511: l_vendor_rec := p_vendor_rec;
512: hack_org_id(l_vendor_rec);
513:
514: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor';
515:
516: AP_VENDOR_PUB_PKG.Create_Vendor
517: ( p_api_version => 1.0,
518: p_init_msg_list => FND_API.G_TRUE,

Line 516: AP_VENDOR_PUB_PKG.Create_Vendor

512: hack_org_id(l_vendor_rec);
513:
514: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor';
515:
516: AP_VENDOR_PUB_PKG.Create_Vendor
517: ( p_api_version => 1.0,
518: p_init_msg_list => FND_API.G_TRUE,
519: p_commit => FND_API.G_FALSE,
520: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 558: -- AP_VENDOR_PUB_PKG which does not update TCA tables.

554: END Create_Vendor;
555:
556: -- Notes: This API will not update any TCA tables. It updates vendor info only.
557: -- This is because the procedure calls the corresponding procedure in
558: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
559: PROCEDURE Update_Vendor
560: ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,
561: x_return_status OUT NOCOPY VARCHAR2,
562: x_msg_count OUT NOCOPY NUMBER,

Line 560: ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,

556: -- Notes: This API will not update any TCA tables. It updates vendor info only.
557: -- This is because the procedure calls the corresponding procedure in
558: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
559: PROCEDURE Update_Vendor
560: ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,
561: x_return_status OUT NOCOPY VARCHAR2,
562: x_msg_count OUT NOCOPY NUMBER,
563: x_msg_data OUT NOCOPY VARCHAR2
564: ) IS

Line 578: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor';

574: l_step := 'Log vendor rec values';
575:
576: log_vendor_rec (p_vendor_rec, 'update vendor');
577:
578: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor';
579:
580: savepoint upd_vndr_a;
581: AP_VENDOR_PUB_PKG.Update_Vendor
582: ( p_api_version => 1.0,

Line 581: AP_VENDOR_PUB_PKG.Update_Vendor

577:
578: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor';
579:
580: savepoint upd_vndr_a;
581: AP_VENDOR_PUB_PKG.Update_Vendor
582: ( p_api_version => 1.0,
583: p_init_msg_list => FND_API.G_TRUE,
584: p_commit => FND_API.G_FALSE,
585: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 627: ( p_vendor_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_rec_type,

623: -- p_party_valid: Indicates how valid the calling program's party_id was
624: -- (V, N, F) Valid, Null or False
625:
626: PROCEDURE Validate_Vendor
627: ( p_vendor_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_rec_type,
628: p_mode IN VARCHAR2,
629: x_return_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2,

Line 664: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor';

660: x_msg_data := 'Invalid p_mode ' || p_mode || ' passed. Expects I or U.';
661: RETURN;
662: END IF;
663:
664: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor';
665:
666: AP_VENDOR_PUB_PKG.Validate_Vendor
667: ( p_api_version => 1.0,
668: p_init_msg_list => FND_API.G_TRUE,

Line 666: AP_VENDOR_PUB_PKG.Validate_Vendor

662: END IF;
663:
664: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor';
665:
666: AP_VENDOR_PUB_PKG.Validate_Vendor
667: ( p_api_version => 1.0,
668: p_init_msg_list => FND_API.G_TRUE,
669: p_commit => FND_API.G_FALSE,
670: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 708: (x_vendor_site_rec IN OUT nocopy ap_vendor_pub_pkg.r_vendor_site_rec_type

704:
705: END Validate_Vendor;
706:
707: PROCEDURE vendor_site_create_default
708: (x_vendor_site_rec IN OUT nocopy ap_vendor_pub_pkg.r_vendor_site_rec_type
709: )
710: IS
711: CURSOR l_phone_cur (p_party_site_id IN NUMBER) IS
712: SELECT phone_area_code,

Line 781: ( p_vendor_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,

777:
778: END vendor_site_create_default;
779:
780: PROCEDURE Create_Vendor_Site
781: ( p_vendor_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2,
785: x_vendor_site_id OUT NOCOPY NUMBER,

Line 790: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

786: x_party_site_id OUT NOCOPY NUMBER,
787: x_location_id OUT NOCOPY NUMBER
788: ) IS
789: l_step VARCHAR2(100);
790: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
791: BEGIN
792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: fnd_log.string(FND_LOG.LEVEL_PROCEDURE
794: , g_module_name

Line 827: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor_Site';

823: return;
824: END IF;
825:
826: savepoint crt_vndr_st_a;
827: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor_Site';
828: AP_VENDOR_PUB_PKG.Create_Vendor_Site
829: ( p_api_version => 1.0,
830: p_init_msg_list => FND_API.G_TRUE,
831: p_commit => FND_API.G_FALSE,

Line 828: AP_VENDOR_PUB_PKG.Create_Vendor_Site

824: END IF;
825:
826: savepoint crt_vndr_st_a;
827: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor_Site';
828: AP_VENDOR_PUB_PKG.Create_Vendor_Site
829: ( p_api_version => 1.0,
830: p_init_msg_list => FND_API.G_TRUE,
831: p_commit => FND_API.G_FALSE,
832: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 872: -- AP_VENDOR_PUB_PKG which does not update TCA tables.

868:
869: -- Notes: This API will not update any TCA records.
870: -- It will only update vendor site info.
871: -- This is because the procedure calls the corresponding procedure in
872: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
873: --
874: PROCEDURE Update_Vendor_Site
875: ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
876: x_return_status OUT NOCOPY VARCHAR2,

Line 875: ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,

871: -- This is because the procedure calls the corresponding procedure in
872: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
873: --
874: PROCEDURE Update_Vendor_Site
875: ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
876: x_return_status OUT NOCOPY VARCHAR2,
877: x_msg_count OUT NOCOPY NUMBER,
878: x_msg_data OUT NOCOPY VARCHAR2
879: ) IS

Line 914: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor_Site';

910: return;
911: END IF;
912:
913: savepoint upd_vndr_st_a;
914: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor_Site';
915: AP_VENDOR_PUB_PKG.Update_Vendor_Site
916: ( p_api_version => 1.0,
917: p_init_msg_list => FND_API.G_TRUE,
918: p_commit => FND_API.G_FALSE,

Line 915: AP_VENDOR_PUB_PKG.Update_Vendor_Site

911: END IF;
912:
913: savepoint upd_vndr_st_a;
914: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor_Site';
915: AP_VENDOR_PUB_PKG.Update_Vendor_Site
916: ( p_api_version => 1.0,
917: p_init_msg_list => FND_API.G_TRUE,
918: p_commit => FND_API.G_FALSE,
919: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 961: ( p_vendor_site_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,

957: -- x_party_site_valid: Indicates how valid the calling program's party_site_id was
958: -- (V, N, F) Valid, Null or False
959:
960: PROCEDURE Validate_Vendor_Site
961: ( p_vendor_site_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
962: p_mode IN VARCHAR2,
963: x_return_status OUT NOCOPY VARCHAR2,
964: x_msg_count OUT NOCOPY NUMBER,
965: x_msg_data OUT NOCOPY VARCHAR2,

Line 999: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor_Site';

995: x_msg_data := 'Invalid p_mode ' || p_mode || ' passed. Expects I or U.';
996: RETURN;
997: END IF;
998:
999: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor_Site';
1000:
1001: AP_VENDOR_PUB_PKG.Validate_Vendor_Site
1002: ( p_api_version => 1.0,
1003: p_init_msg_list => FND_API.G_TRUE,

Line 1001: AP_VENDOR_PUB_PKG.Validate_Vendor_Site

997: END IF;
998:
999: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor_Site';
1000:
1001: AP_VENDOR_PUB_PKG.Validate_Vendor_Site
1002: ( p_api_version => 1.0,
1003: p_init_msg_list => FND_API.G_TRUE,
1004: p_commit => FND_API.G_FALSE,
1005: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1045: ( p_vendor_contact_rec IN ap_vendor_pub_pkg.r_vendor_contact_rec_type,

1041:
1042: END Validate_Vendor_Site;
1043:
1044: PROCEDURE create_vendor_contact
1045: ( p_vendor_contact_rec IN ap_vendor_pub_pkg.r_vendor_contact_rec_type,
1046: x_return_status OUT NOCOPY VARCHAR2,
1047: x_msg_count OUT NOCOPY NUMBER,
1048: x_msg_data OUT NOCOPY VARCHAR2,
1049: x_vendor_contact_id OUT NOCOPY NUMBER,

Line 1059: l_step := 'call ap_vendor_pub_pkg.create_vendor_contact';

1055: )
1056: IS
1057: l_step VARCHAR2(100);
1058: BEGIN
1059: l_step := 'call ap_vendor_pub_pkg.create_vendor_contact';
1060: ap_vendor_pub_pkg.create_vendor_contact
1061: ( p_api_version => 1.0,
1062: p_init_msg_list => FND_API.G_TRUE,
1063: p_commit => FND_API.G_FALSE,

Line 1060: ap_vendor_pub_pkg.create_vendor_contact

1056: IS
1057: l_step VARCHAR2(100);
1058: BEGIN
1059: l_step := 'call ap_vendor_pub_pkg.create_vendor_contact';
1060: ap_vendor_pub_pkg.create_vendor_contact
1061: ( p_api_version => 1.0,
1062: p_init_msg_list => FND_API.G_TRUE,
1063: p_commit => FND_API.G_FALSE,
1064: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1259: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

1255: x_error_msg OUT NOCOPY VARCHAR2,
1256: x_vendor_id OUT NOCOPY NUMBER,
1257: x_party_id OUT NOCOPY NUMBER
1258: ) IS
1259: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
1260: l_msg_count NUMBER;
1261: l_msg_data VARCHAR2(4000);
1262: BEGIN
1263:

Line 1399: -- AP_VENDOR_PUB_PKG which does not update TCA tables.

1395: END Create_Vendor;
1396:
1397: -- Notes: This API will not update any TCA tables. It updates vendor info only.
1398: -- This is because the procedure calls the corresponding procedure in
1399: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
1400: PROCEDURE Update_Vendor
1401: (
1402: p_vendor_id IN NUMBER ,
1403: p_segment1 IN VARCHAR2 ,

Line 1525: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

1521: x_return_status OUT NOCOPY VARCHAR2,
1522: x_error_msg OUT NOCOPY VARCHAR2
1523: )
1524: IS
1525: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
1526: l_msg_count NUMBER;
1527: l_msg_data VARCHAR2(4000);
1528: l_last_update_date DATE;
1529: is_supp_ccr VARCHAR2(1);

Line 1812: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

1808: x_error_msg OUT NOCOPY VARCHAR2,
1809: x_party_valid OUT NOCOPY VARCHAR2
1810: )
1811: IS
1812: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
1813: l_msg_count NUMBER;
1814: l_msg_data VARCHAR2(4000);
1815: is_supp_ccr VARCHAR2(1);
1816: BEGIN

Line 2102: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

2098: x_party_site_id OUT NOCOPY NUMBER,
2099: x_location_id OUT NOCOPY NUMBER
2100: )
2101: IS
2102: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
2103: l_msg_count NUMBER;
2104: l_msg_data VARCHAR2(4000);
2105: l_addr_pay_flag VARCHAR2(1);
2106: l_addr_pur_flag VARCHAR2(1);

Line 2269: -- AP_VENDOR_PUB_PKG which does not update TCA tables.

2265:
2266: -- Notes: This API will not update any TCA records.
2267: -- It will only update vendor site info.
2268: -- This is because the procedure calls the corresponding procedure in
2269: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
2270: --
2271: PROCEDURE Update_Vendor_Site
2272: (
2273: p_area_code IN VARCHAR2 ,

Line 2410: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

2406: x_return_status OUT NOCOPY VARCHAR2,
2407: x_error_msg OUT NOCOPY VARCHAR2
2408: )
2409: IS
2410: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
2411: l_msg_count NUMBER;
2412: l_msg_data VARCHAR2(4000);
2413: l_last_update_date DATE;
2414: is_site_ccr VARCHAR2(1);

Line 2747: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

2743: x_party_site_valid OUT NOCOPY VARCHAR2,
2744: x_location_valid OUT NOCOPY VARCHAR2
2745: )
2746: IS
2747: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
2748: l_msg_count NUMBER;
2749: l_msg_data VARCHAR2(4000);
2750: is_site_ccr VARCHAR2(1);
2751: BEGIN