[Home] [Help]
513: DELETE FROM PO_HEADERS_INTERFACE WHERE
514: INTERFACE_HEADER_ID = l_old_intf_header_id;
515: DELETE FROM PO_LINES_INTERFACE WHERE
516: INTERFACE_HEADER_ID = l_old_intf_header_id;
517: DELETE FROM PO_DISTRIBUTIONS_INTERFACE WHERE
518: INTERFACE_HEADER_ID = l_old_intf_header_id;
519: ELSIF (l_curr_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN
520: -- Requisition Submission had failed earlier
521: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all
1945: -- Added by jaramana on Jan 5, 2006 for ER 4736326
1946: -- Check the profile OSP Default PO Distribution Creation to see if the Distribution is to be created
1947: IF (NVL(FND_PROFILE.VALUE('AHL_OSP_DEF_PO_DIST'), 'N') = 'Y') THEN
1948: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740
1949: -- Insert row into PO_DISTRIBUTIONS_INTERFACE to create a distribution
1950: IF p_po_line_tbl(i).task_id IS NOT NULL THEN
1951: OPEN get_prj_task_comp_date_csr(p_po_line_tbl(i).task_id);
1952: FETCH get_prj_task_comp_date_csr INTO l_task_completion_date;
1953: CLOSE get_prj_task_comp_date_csr;
1974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_expenditure_item_type : '|| l_expenditure_item_type);
1975: END IF;
1976: --mpothuku End
1977:
1978: INSERT INTO PO_DISTRIBUTIONS_INTERFACE (
1979: INTERFACE_HEADER_ID,
1980: INTERFACE_LINE_ID,
1981: INTERFACE_DISTRIBUTION_ID,
1982: QUANTITY_ORDERED,
1997:
1998: ) VALUES (
1999: p_intf_header_id,
2000: l_intf_line_id,
2001: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL,
2002: p_po_line_tbl(i).QUANTITY,
2003: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
2004: AHL_GLOBAL.AHL_APPLICATION_ID,
2005: SYSDATE,
2017: );
2018: --Added by mpothuku on 10-oct-2007 to fix bug 6431740
2019: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2020: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
2021: ' Inserting into PO_DISTRIBUTIONS_INTERFACE. INTERFACE_HEADER_ID = ' || p_intf_header_id ||
2022: ', INTERFACE_LINE_ID = ' || l_intf_line_id ||
2023: ', WIP_ENTITY_ID = ' || p_po_line_tbl(i).wip_entity_id ||
2024: ', PROJECT_ID = ' || p_po_line_tbl(i).project_id ||
2025: ', TASK_ID = ' || p_po_line_tbl(i).task_id ||