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.PNT_LOCATIONS_PKG dependencies on PN_LOCATIONS_ALL

Line 9: G_LOC_RECINFO pn_locations_all%rowtype; -- Delclare global record type for lock row which will be used

5:
6: G_START_OF_TIME DATE := to_date('01/01/0001','MM/DD/YYYY');
7: G_END_OF_TIME DATE := to_date('12/31/4712','MM/DD/YYYY');
8: G_PN_LOCATIONS_ROWID ROWID; -- Global rowid which will be save during lock row and used during update
9: G_LOC_RECINFO pn_locations_all%rowtype; -- Delclare global record type for lock row which will be used
10: -- by correct_update_row procedure
11: g_loc_recinfo_tmp pn_locations_all%ROWTYPE;
12: g_loc_adrinfo_tmp pn_addresses_all%ROWTYPE;
13:

Line 11: g_loc_recinfo_tmp pn_locations_all%ROWTYPE;

7: G_END_OF_TIME DATE := to_date('12/31/4712','MM/DD/YYYY');
8: G_PN_LOCATIONS_ROWID ROWID; -- Global rowid which will be save during lock row and used during update
9: G_LOC_RECINFO pn_locations_all%rowtype; -- Delclare global record type for lock row which will be used
10: -- by correct_update_row procedure
11: g_loc_recinfo_tmp pn_locations_all%ROWTYPE;
12: g_loc_adrinfo_tmp pn_addresses_all%ROWTYPE;
13:
14:
15: Procedure check_location_overlap (

Line 49: p_pn_locations_rec IN pn_locations_all%ROWTYPE

45: x_return_status OUT NOCOPY VARCHAR2,
46: x_return_message OUT NOCOPY VARCHAR2) ;
47:
48: PROCEDURE correct_update_row(
49: p_pn_locations_rec IN pn_locations_all%ROWTYPE
50: ,p_pn_addresses_rec IN pn_addresses_all%ROWTYPE
51: ,p_change_mode IN VARCHAR2
52: ,p_as_of_date IN DATE
53: ,p_active_start_date_old IN DATE

Line 361: p_pn_locations_rec pn_locations_all%rowtype,

357: x_return_status OUT NOCOPY VARCHAR2,
358: x_return_message OUT NOCOPY VARCHAR2) ;
359:
360: Procedure check_for_popup (
361: p_pn_locations_rec pn_locations_all%rowtype,
362: p_start_date_old IN DATE,
363: p_end_date_old IN DATE,
364: x_flag OUT NOCOPY VARCHAR2,
365: x_return_status OUT NOCOPY VARCHAR2,

Line 444: p_loc_recinfo IN pn_locations_all%ROWTYPE

440: )
441: RETURN BOOLEAN;
442:
443: PROCEDURE Insert_Locn_Row (
444: p_loc_recinfo IN pn_locations_all%ROWTYPE
445: ,p_adr_recinfo IN pn_addresses_all%ROWTYPE
446: ,p_change_mode IN VARCHAR2
447: ,x_return_status IN OUT NOCOPY VARCHAR2
448: ,x_return_message IN OUT NOCOPY VARCHAR2

Line 452: p_loc_recinfo IN pn_locations_all%ROWTYPE

448: ,x_return_message IN OUT NOCOPY VARCHAR2
449: );
450:
451: PROCEDURE Update_Locn_Row (
452: p_loc_recinfo IN pn_locations_all%ROWTYPE
453: ,p_adr_recinfo IN pn_addresses_all%ROWTYPE
454: ,p_assgn_area_chgd_flag IN VARCHAR2
455: ,x_return_status IN OUT NOCOPY VARCHAR2
456: ,x_return_message IN OUT NOCOPY VARCHAR2