APPS.PN_LOC_ACC_MAP_PKG dependencies on PN_LOC_ACC_MAP_ALL

Line 107: FROM PN_LOC_ACC_MAP_ALL

103: ) IS
104:
105: CURSOR C IS
106: SELECT LOC_ACC_MAP_ID
107: FROM PN_LOC_ACC_MAP_ALL
108: WHERE LOC_ACC_MAP_ID = x_LOC_ACC_MAP_ID;
109:
110: CURSOR org_cur IS
111: SELECT org_id

Line 127: INSERT INTO PN_LOC_ACC_MAP_ALL

123: ELSE
124: l_org_id := x_org_id;
125: END IF;
126:
127: INSERT INTO PN_LOC_ACC_MAP_ALL
128: (LOC_ACC_MAP_ID,
129: LOC_ACC_MAP_HDR_ID,
130: last_update_date,
131: last_updated_by,

Line 426: UPDATE PN_LOC_ACC_MAP_ALL --sdm_MOAC

422: x_attribute14 IN VARCHAR2,
423: x_attribute15 IN VARCHAR2
424: ) IS
425: BEGIN
426: UPDATE PN_LOC_ACC_MAP_ALL --sdm_MOAC
427: SET last_update_date = x_last_update_date,
428: last_updated_by = x_last_updated_by,
429: last_update_login = x_last_update_login,
430: LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID,

Line 618: FROM PN_LOC_ACC_MAP_ALL

614: x_attribute15 IN VARCHAR2
615: ) IS
616: CURSOR c1 IS
617: SELECT *
618: FROM PN_LOC_ACC_MAP_ALL
619: WHERE LOC_ACC_MAP_ID = x_LOC_ACC_MAP_ID
620: FOR UPDATE OF LOC_ACC_MAP_ID NOWAIT;
621:
622: tlinfo c1%ROWTYPE;

Line 1070: DELETE FROM PN_LOC_ACC_MAP_ALL --sdm_MOAC

1066: PROCEDURE delete_row (
1067: x_LOC_ACC_MAP_ID IN NUMBER
1068: ) IS
1069: BEGIN
1070: DELETE FROM PN_LOC_ACC_MAP_ALL --sdm_MOAC
1071: WHERE LOC_ACC_MAP_ID = x_LOC_ACC_MAP_ID;
1072:
1073: IF (SQL%NOTFOUND) THEN
1074: RAISE NO_DATA_FOUND;