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 361: p_vendor_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,

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

Line 434: ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,

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

Line 442: l_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;

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

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

534: -- so set it here temporarily
535: l_vendor_rec := p_vendor_rec;
536: hack_org_id(l_vendor_rec);
537:
538: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor';
539:
540: AP_VENDOR_PUB_PKG.Create_Vendor
541: ( p_api_version => 1.0,
542: p_init_msg_list => FND_API.G_TRUE,

Line 540: AP_VENDOR_PUB_PKG.Create_Vendor

536: hack_org_id(l_vendor_rec);
537:
538: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor';
539:
540: AP_VENDOR_PUB_PKG.Create_Vendor
541: ( p_api_version => 1.0,
542: p_init_msg_list => FND_API.G_TRUE,
543: p_commit => FND_API.G_FALSE,
544: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

585: END Create_Vendor;
586:
587: -- Notes: This API will not update any TCA tables. It updates vendor info only.
588: -- This is because the procedure calls the corresponding procedure in
589: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
590: PROCEDURE Update_Vendor
591: ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,
592: x_return_status OUT NOCOPY VARCHAR2,
593: x_msg_count OUT NOCOPY NUMBER,

Line 591: ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,

587: -- Notes: This API will not update any TCA tables. It updates vendor info only.
588: -- This is because the procedure calls the corresponding procedure in
589: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
590: PROCEDURE Update_Vendor
591: ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,
592: x_return_status OUT NOCOPY VARCHAR2,
593: x_msg_count OUT NOCOPY NUMBER,
594: x_msg_data OUT NOCOPY VARCHAR2
595: ) IS

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

605: l_step := 'Log vendor rec values';
606:
607: log_vendor_rec (p_vendor_rec, 'update vendor');
608:
609: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor';
610:
611: savepoint upd_vndr_a;
612: AP_VENDOR_PUB_PKG.Update_Vendor
613: ( p_api_version => 1.0,

Line 612: AP_VENDOR_PUB_PKG.Update_Vendor

608:
609: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor';
610:
611: savepoint upd_vndr_a;
612: AP_VENDOR_PUB_PKG.Update_Vendor
613: ( p_api_version => 1.0,
614: p_init_msg_list => FND_API.G_TRUE,
615: p_commit => FND_API.G_FALSE,
616: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

654: -- p_party_valid: Indicates how valid the calling program's party_id was
655: -- (V, N, F) Valid, Null or False
656:
657: PROCEDURE Validate_Vendor
658: ( p_vendor_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_rec_type,
659: p_mode IN VARCHAR2,
660: x_return_status OUT NOCOPY VARCHAR2,
661: x_msg_count OUT NOCOPY NUMBER,
662: x_msg_data OUT NOCOPY VARCHAR2,

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

691: x_msg_data := 'Invalid p_mode ' || p_mode || ' passed. Expects I or U.';
692: RETURN;
693: END IF;
694:
695: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor';
696:
697: AP_VENDOR_PUB_PKG.Validate_Vendor
698: ( p_api_version => 1.0,
699: p_init_msg_list => FND_API.G_TRUE,

Line 697: AP_VENDOR_PUB_PKG.Validate_Vendor

693: END IF;
694:
695: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor';
696:
697: AP_VENDOR_PUB_PKG.Validate_Vendor
698: ( p_api_version => 1.0,
699: p_init_msg_list => FND_API.G_TRUE,
700: p_commit => FND_API.G_FALSE,
701: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 739: (x_vendor_site_rec IN OUT nocopy ap_vendor_pub_pkg.r_vendor_site_rec_type

735:
736: END Validate_Vendor;
737:
738: PROCEDURE vendor_site_create_default
739: (x_vendor_site_rec IN OUT nocopy ap_vendor_pub_pkg.r_vendor_site_rec_type
740: )
741: IS
742: CURSOR l_phone_cur (p_party_site_id IN NUMBER) IS
743: SELECT phone_area_code,

Line 812: ( p_vendor_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,

808:
809: END vendor_site_create_default;
810:
811: PROCEDURE Create_Vendor_Site
812: ( p_vendor_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: x_vendor_site_id OUT NOCOPY NUMBER,

Line 821: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

817: x_party_site_id OUT NOCOPY NUMBER,
818: x_location_id OUT NOCOPY NUMBER
819: ) IS
820: l_step VARCHAR2(100);
821: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
822: BEGIN
823: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
824: fnd_log.string(FND_LOG.LEVEL_PROCEDURE
825: , g_module_name

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

854: return;
855: END IF;
856:
857: savepoint crt_vndr_st_a;
858: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor_Site';
859: AP_VENDOR_PUB_PKG.Create_Vendor_Site
860: ( p_api_version => 1.0,
861: p_init_msg_list => FND_API.G_TRUE,
862: p_commit => FND_API.G_FALSE,

Line 859: AP_VENDOR_PUB_PKG.Create_Vendor_Site

855: END IF;
856:
857: savepoint crt_vndr_st_a;
858: l_step := 'Call AP_VENDOR_PUB_PKG.Create_Vendor_Site';
859: AP_VENDOR_PUB_PKG.Create_Vendor_Site
860: ( p_api_version => 1.0,
861: p_init_msg_list => FND_API.G_TRUE,
862: p_commit => FND_API.G_FALSE,
863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

899:
900: -- Notes: This API will not update any TCA records.
901: -- It will only update vendor site info.
902: -- This is because the procedure calls the corresponding procedure in
903: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
904: --
905: PROCEDURE Update_Vendor_Site
906: ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
907: x_return_status OUT NOCOPY VARCHAR2,

Line 906: ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,

902: -- This is because the procedure calls the corresponding procedure in
903: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
904: --
905: PROCEDURE Update_Vendor_Site
906: ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
907: x_return_status OUT NOCOPY VARCHAR2,
908: x_msg_count OUT NOCOPY NUMBER,
909: x_msg_data OUT NOCOPY VARCHAR2
910: ) IS

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

941: return;
942: END IF;
943:
944: savepoint upd_vndr_st_a;
945: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor_Site';
946: AP_VENDOR_PUB_PKG.Update_Vendor_Site
947: ( p_api_version => 1.0,
948: p_init_msg_list => FND_API.G_TRUE,
949: p_commit => FND_API.G_FALSE,

Line 946: AP_VENDOR_PUB_PKG.Update_Vendor_Site

942: END IF;
943:
944: savepoint upd_vndr_st_a;
945: l_step := 'Call AP_VENDOR_PUB_PKG.Update_Vendor_Site';
946: AP_VENDOR_PUB_PKG.Update_Vendor_Site
947: ( p_api_version => 1.0,
948: p_init_msg_list => FND_API.G_TRUE,
949: p_commit => FND_API.G_FALSE,
950: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

988: -- x_party_site_valid: Indicates how valid the calling program's party_site_id was
989: -- (V, N, F) Valid, Null or False
990:
991: PROCEDURE Validate_Vendor_Site
992: ( p_vendor_site_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
993: p_mode IN VARCHAR2,
994: x_return_status OUT NOCOPY VARCHAR2,
995: x_msg_count OUT NOCOPY NUMBER,
996: x_msg_data OUT NOCOPY VARCHAR2,

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

1026: x_msg_data := 'Invalid p_mode ' || p_mode || ' passed. Expects I or U.';
1027: RETURN;
1028: END IF;
1029:
1030: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor_Site';
1031:
1032: AP_VENDOR_PUB_PKG.Validate_Vendor_Site
1033: ( p_api_version => 1.0,
1034: p_init_msg_list => FND_API.G_TRUE,

Line 1032: AP_VENDOR_PUB_PKG.Validate_Vendor_Site

1028: END IF;
1029:
1030: l_step := 'Call AP_VENDOR_PUB_PKG.Validate_Vendor_Site';
1031:
1032: AP_VENDOR_PUB_PKG.Validate_Vendor_Site
1033: ( p_api_version => 1.0,
1034: p_init_msg_list => FND_API.G_TRUE,
1035: p_commit => FND_API.G_FALSE,
1036: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1076: ( p_vendor_contact_rec IN ap_vendor_pub_pkg.r_vendor_contact_rec_type,

1072:
1073: END Validate_Vendor_Site;
1074:
1075: PROCEDURE create_vendor_contact
1076: ( p_vendor_contact_rec IN ap_vendor_pub_pkg.r_vendor_contact_rec_type,
1077: x_return_status OUT NOCOPY VARCHAR2,
1078: x_msg_count OUT NOCOPY NUMBER,
1079: x_msg_data OUT NOCOPY VARCHAR2,
1080: x_vendor_contact_id OUT NOCOPY NUMBER,

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

1086: )
1087: IS
1088: l_step VARCHAR2(100);
1089: BEGIN
1090: l_step := 'call ap_vendor_pub_pkg.create_vendor_contact';
1091: ap_vendor_pub_pkg.create_vendor_contact
1092: ( p_api_version => 1.0,
1093: p_init_msg_list => FND_API.G_TRUE,
1094: p_commit => FND_API.G_FALSE,

Line 1091: ap_vendor_pub_pkg.create_vendor_contact

1087: IS
1088: l_step VARCHAR2(100);
1089: BEGIN
1090: l_step := 'call ap_vendor_pub_pkg.create_vendor_contact';
1091: ap_vendor_pub_pkg.create_vendor_contact
1092: ( p_api_version => 1.0,
1093: p_init_msg_list => FND_API.G_TRUE,
1094: p_commit => FND_API.G_FALSE,
1095: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1290: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

1286: x_error_msg OUT NOCOPY VARCHAR2,
1287: x_vendor_id OUT NOCOPY NUMBER,
1288: x_party_id OUT NOCOPY NUMBER
1289: ) IS
1290: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
1291: l_msg_count NUMBER;
1292: l_msg_data VARCHAR2(4000);
1293: BEGIN
1294:

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

1426: END Create_Vendor;
1427:
1428: -- Notes: This API will not update any TCA tables. It updates vendor info only.
1429: -- This is because the procedure calls the corresponding procedure in
1430: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
1431: PROCEDURE Update_Vendor
1432: (
1433: p_vendor_id IN NUMBER ,
1434: p_segment1 IN VARCHAR2 ,

Line 1556: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

1552: x_return_status OUT NOCOPY VARCHAR2,
1553: x_error_msg OUT NOCOPY VARCHAR2
1554: )
1555: IS
1556: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
1557: l_msg_count NUMBER;
1558: l_msg_data VARCHAR2(4000);
1559: l_last_update_date DATE;
1560: is_supp_ccr VARCHAR2(1);

Line 1843: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

1839: x_error_msg OUT NOCOPY VARCHAR2,
1840: x_party_valid OUT NOCOPY VARCHAR2
1841: )
1842: IS
1843: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
1844: l_msg_count NUMBER;
1845: l_msg_data VARCHAR2(4000);
1846: is_supp_ccr VARCHAR2(1);
1847: BEGIN

Line 2134: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

2130: x_party_site_id OUT NOCOPY NUMBER,
2131: x_location_id OUT NOCOPY NUMBER
2132: )
2133: IS
2134: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
2135: l_msg_count NUMBER;
2136: l_msg_data VARCHAR2(4000);
2137: l_addr_pay_flag VARCHAR2(1);
2138: l_addr_pur_flag VARCHAR2(1);

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

2298:
2299: -- Notes: This API will not update any TCA records.
2300: -- It will only update vendor site info.
2301: -- This is because the procedure calls the corresponding procedure in
2302: -- AP_VENDOR_PUB_PKG which does not update TCA tables.
2303: --
2304: PROCEDURE Update_Vendor_Site
2305: (
2306: p_area_code IN VARCHAR2 ,

Line 2451: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

2447: x_return_status OUT NOCOPY VARCHAR2,
2448: x_error_msg OUT NOCOPY VARCHAR2
2449: )
2450: IS
2451: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
2452: l_msg_count NUMBER;
2453: l_msg_data VARCHAR2(4000);
2454: l_last_update_date DATE;
2455: is_site_ccr VARCHAR2(1);

Line 2817: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

2813: x_party_site_valid OUT NOCOPY VARCHAR2,
2814: x_location_valid OUT NOCOPY VARCHAR2
2815: )
2816: IS
2817: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
2818: l_msg_count NUMBER;
2819: l_msg_data VARCHAR2(4000);
2820: is_site_ccr VARCHAR2(1);
2821: BEGIN