[Home] [Help]
505: DELETE FROM PO_HEADERS_INTERFACE WHERE
506: INTERFACE_HEADER_ID = l_old_intf_header_id;
507: DELETE FROM PO_LINES_INTERFACE WHERE
508: INTERFACE_HEADER_ID = l_old_intf_header_id;
509: DELETE FROM PO_DISTRIBUTIONS_INTERFACE WHERE
510: INTERFACE_HEADER_ID = l_old_intf_header_id;
511: ELSIF (l_curr_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN
512: -- Requisition Submission had failed earlier
513: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all
1931: -- Added by jaramana on Jan 5, 2006 for ER 4736326
1932: -- Check the profile OSP Default PO Distribution Creation to see if the Distribution is to be created
1933: IF (NVL(FND_PROFILE.VALUE('AHL_OSP_DEF_PO_DIST'), 'N') = 'Y') THEN
1934: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740
1935: -- Insert row into PO_DISTRIBUTIONS_INTERFACE to create a distribution
1936: IF p_po_line_tbl(i).task_id IS NOT NULL THEN
1937: OPEN get_prj_task_comp_date_csr(p_po_line_tbl(i).task_id);
1938: FETCH get_prj_task_comp_date_csr INTO l_task_completion_date;
1939: CLOSE get_prj_task_comp_date_csr;
1960: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_expenditure_item_type : '|| l_expenditure_item_type);
1961: END IF;
1962: --mpothuku End
1963:
1964: INSERT INTO PO_DISTRIBUTIONS_INTERFACE (
1965: INTERFACE_HEADER_ID,
1966: INTERFACE_LINE_ID,
1967: INTERFACE_DISTRIBUTION_ID,
1968: QUANTITY_ORDERED,
1983:
1984: ) VALUES (
1985: p_intf_header_id,
1986: l_intf_line_id,
1987: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL,
1988: p_po_line_tbl(i).QUANTITY,
1989: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1990: AHL_GLOBAL.AHL_APPLICATION_ID,
1991: SYSDATE,
2003: );
2004: --Added by mpothuku on 10-oct-2007 to fix bug 6431740
2005: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2006: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
2007: ' Inserting into PO_DISTRIBUTIONS_INTERFACE. INTERFACE_HEADER_ID = ' || p_intf_header_id ||
2008: ', INTERFACE_LINE_ID = ' || l_intf_line_id ||
2009: ', WIP_ENTITY_ID = ' || p_po_line_tbl(i).wip_entity_id ||
2010: ', PROJECT_ID = ' || p_po_line_tbl(i).project_id ||
2011: ', TASK_ID = ' || p_po_line_tbl(i).task_id ||