11: G_UNIT CONSTANT VARCHAR2(1) := 'U';
12: G_PART CONSTANT VARCHAR2(1) := 'I';
13:
14: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
15: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
16:
17: -----------------------------
18: -- CONVERT UNIT NAME TO ID --
19: -----------------------------
122: -- Initialize API return status to success
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: IF G_DEBUG='Y' THEN
126: AHL_DEBUG_PUB.ENABLE_DEBUG;
127: END IF;
128:
129: IF (p_x_assos_tbl.COUNT > 0)
130: THEN
148: CONVERT_UNIT_NAME_TO_ID(p_x_assos_tbl(i));
149: END IF;
150:
151: IF G_DEBUG='Y' THEN
152: AHL_DEBUG_PUB.debug('PCA -- PUB -- Calling ATTACH_UNIT for p_x_assos_tbl('||i||').unit_id'||p_x_assos_tbl(i).unit_item_id);
153: END IF;
154:
155: AHL_PC_ASSOCIATION_PVT.ATTACH_UNIT
156: (
171: CONVERT_PART_NAME_TO_ID(p_x_assos_tbl(i));
172: END IF;
173:
174: IF G_DEBUG='Y' THEN
175: AHL_DEBUG_PUB.debug('PCA -- PUB -- Calling ATTACH_PART for p_x_assos_tbl('||i||').item_id'||p_x_assos_tbl(i).unit_item_id);
176: END IF;
177:
178: AHL_PC_ASSOCIATION_PVT.ATTACH_ITEM
179: (
197: CONVERT_UNIT_NAME_TO_ID(p_x_assos_tbl(i));
198: END IF;
199:
200: IF G_DEBUG='Y' THEN
201: AHL_DEBUG_PUB.debug('PCA -- PUB -- Calling DETACH_UNIT for p_x_assos_tbl('||i||').unit_id'||p_x_assos_tbl(i).unit_item_id);
202: END IF;
203:
204: AHL_PC_ASSOCIATION_PVT.DETACH_UNIT
205: (
220: CONVERT_PART_NAME_TO_ID(p_x_assos_tbl(i));
221: END IF;
222:
223: IF G_DEBUG='Y' THEN
224: AHL_DEBUG_PUB.debug('PCA -- PUB -- Calling DETACH_PART for p_x_assos_tbl('||i||').item_id'||p_x_assos_tbl(i).unit_item_id);
225: END IF;
226:
227: AHL_PC_ASSOCIATION_PVT.DETACH_ITEM
228: (
323: -- Initialize API return status to success
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: IF G_DEBUG='Y' THEN
327: AHL_DEBUG_PUB.ENABLE_DEBUG;
328: END IF;
329:
330: AHL_PC_ASSOCIATION_PVT.PROCESS_DOCUMENT
331: (