APPS.PN_LOC_ACC_MAP_HDR_PKG dependencies on PN_LOC_ACC_MAP_HDR_ALL

Line 39: FROM PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC

35: x_ORG_ID IN NUMBER default NULL
36: ) IS
37: CURSOR C IS
38: SELECT LOC_ACC_MAP_HDR_ID
39: FROM PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC
40: WHERE LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID;
41: BEGIN
42:
43: INSERT INTO PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC

Line 43: INSERT INTO PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC

39: FROM PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC
40: WHERE LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID;
41: BEGIN
42:
43: INSERT INTO PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC
44: (LOC_ACC_MAP_HDR_ID,
45: MAPPING_NAME,
46: last_update_date,
47: last_updated_by,

Line 138: UPDATE PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC

134: x_attribute14 IN VARCHAR2,
135: x_attribute15 IN VARCHAR2
136: ) IS
137: BEGIN
138: UPDATE PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC
139: SET last_update_date = x_last_update_date,
140: last_updated_by = x_last_updated_by,
141: last_update_login = x_last_update_login,
142: MAPPING_NAME = x_MAPPING_NAME,

Line 194: FROM PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC

190: x_attribute15 IN VARCHAR2
191: ) IS
192: CURSOR c1 IS
193: SELECT *
194: FROM PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC
195: WHERE LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID
196: FOR UPDATE OF LOC_ACC_MAP_HDR_ID NOWAIT;
197:
198: tlinfo c1%ROWTYPE;

Line 293: DELETE FROM PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC

289: PROCEDURE delete_row (
290: x_LOC_ACC_MAP_HDR_ID IN NUMBER
291: ) IS
292: BEGIN
293: DELETE FROM PN_LOC_ACC_MAP_HDR_ALL --sdm_MOAC
294: WHERE LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID;
295:
296: IF (SQL%NOTFOUND) THEN
297: RAISE NO_DATA_FOUND;