APPS.RRS_SITES_PKG dependencies on PN_LOCATIONS_ITF

Line 17: ,PN_LOCATIONS_ITF ITF

13: ,RRS.NAME
14: ,RRS.SITE_IDENTIFICATION_NUMBER
15: ,ITF.ERROR_MESSAGE
16: FROM RRS_SITES_VL RRS
17: ,PN_LOCATIONS_ITF ITF
18: WHERE ITF.BATCH_NAME = P_BATCH_NAME
19: AND RRS.SITE_ID = ITF.SITE_ID
20: AND ITF.ERROR_MESSAGE IS NOT NULL ;
21:

Line 39: ,PN_LOCATIONS_ITF PN

35: ,PN.SITE_ID
36: FROM
37: HZ_LOCATIONS HZ
38: ,RRS_SITES_B RRS
39: ,PN_LOCATIONS_ITF PN
40: WHERE HZ.LOCATION_ID = RRS.LOCATION_ID
41: AND PN.SITE_ID = RRS.SITE_ID
42: AND PN.BATCH_NAME = p_batch_name
43: FOR UPDATE;

Line 48: FROM PN_LOCATIONS_ITF

44:
45: CURSOR UPDATE_LOCATION_ID IS
46: SELECT SITE_ID
47: ,LOCATION_ID
48: FROM PN_LOCATIONS_ITF
49: WHERE BATCH_NAME = P_BATCH_NAME
50: AND ERROR_MESSAGE IS NULL ;
51:
52: l_debug_mode VARCHAR2(1);

Line 69: UPDATE PN_LOCATIONS_ITF

65: RAISE FND_API.G_EXC_ERROR;
66: END IF ;
67:
68: FOR rec IN UPDATE_ADDRESS_CUR LOOP
69: UPDATE PN_LOCATIONS_ITF
70: SET COUNTRY = rec.COUNTRY
71: ,ADDRESS_LINE1 = rec.ADDRESS1
72: ,ADDRESS_LINE2 = rec.ADDRESS2
73: ,ADDRESS_LINE3 = rec.ADDRESS3

Line 85: UPDATE PN_LOCATIONS_ITF

81: WHERE CURRENT OF UPDATE_ADDRESS_CUR;
82: END LOOP ;
83:
84: /*FOR rec IN UPDATE_ADDRESS_CUR LOOP
85: UPDATE PN_LOCATIONS_ITF
86: SET COUNTRY = rec.COUNTRY
87: ,ADDRESS_LINE1 = rec.ADDRESS1
88: ,ADDRESS_LINE2 = rec.ADDRESS2
89: ,ADDRESS_LINE3 = rec.ADDRESS3

Line 129: DELETE FROM PN_LOCATIONS_ITF WHERE BATCH_NAME = p_batch_name ;

125: UPDATE RRS_SITES_B RRS
126: SET RRS.PROPERTY_LOCATION_ID = rec.LOCATION_ID
127: WHERE RRS.SITE_ID = rec.SITE_ID ;
128: END LOOP ;
129: DELETE FROM PN_LOCATIONS_ITF WHERE BATCH_NAME = p_batch_name ;
130: COMMIT ;
131: END IF ;
132: EXCEPTION
133: WHEN FND_API.G_EXC_ERROR THEN