APPS.AHL_OSP_PO_REQ_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 90: -- Insert a record into the PO_REQUISITIONS_INTERFACE_ALL table

86: PROCEDURE Validate_PO_Req_Lines(
87: p_po_req_line_tbl IN PO_Req_Line_Tbl_Type,
88: p_osp_order_id IN NUMBER);
89:
90: -- Insert a record into the PO_REQUISITIONS_INTERFACE_ALL table
91: PROCEDURE Insert_Into_Req_Interface(
92: p_po_req_hdr_rec IN PO_Req_Header_Rec_Type,
93: p_po_req_line_tbl IN PO_Req_Line_Tbl_Type,
94: x_batch_id OUT NOCOPY NUMBER);

Line 378: -- Insert Rows into PO_REQUISITIONS_INTERFACE_ALL

374: IF x_msg_count > 0 THEN
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: -- Insert Rows into PO_REQUISITIONS_INTERFACE_ALL
379:
380: -- Purge Error records from prior submission (if any)
381: IF (l_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN
382: DELETE FROM po_interface_errors

Line 385: FROM po_requisitions_interface_all

381: IF (l_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN
382: DELETE FROM po_interface_errors
383: WHERE INTERFACE_TRANSACTION_ID in
384: (SELECT transaction_id
385: FROM po_requisitions_interface_all
386: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
387: AND INTERFACE_SOURCE_LINE_ID = l_po_req_header.OSP_ORDER_ID);
388: DELETE FROM po_requisitions_interface_all
389: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

Line 388: DELETE FROM po_requisitions_interface_all

384: (SELECT transaction_id
385: FROM po_requisitions_interface_all
386: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
387: AND INTERFACE_SOURCE_LINE_ID = l_po_req_header.OSP_ORDER_ID);
388: DELETE FROM po_requisitions_interface_all
389: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
390: AND INTERFACE_SOURCE_LINE_ID = l_po_req_header.OSP_ORDER_ID;
391:
392: ELSIF(l_status = G_OSP_SUB_FAILED_STATUS and l_old_intf_header_id IS NOT NULL) THEN

Line 863: -- This Procedure inserts a record into the PO_REQUISITIONS_INTERFACE_ALL table

859:
860: END Associate_All_New_Reqs;
861:
862: -------------------------------------------------------------------------
863: -- This Procedure inserts a record into the PO_REQUISITIONS_INTERFACE_ALL table
864: -------------------------------------------------------------------------
865: PROCEDURE Insert_Into_Req_Interface
866: (
867: p_po_req_hdr_rec IN PO_Req_Header_Rec_Type,

Line 920: -- Insert row into PO_REQUISITIONS_INTERFACE_ALL

916: */
917: l_price := null;
918: END IF;
919:
920: -- Insert row into PO_REQUISITIONS_INTERFACE_ALL
921: l_charge_acct_id := get_charge_account_id(p_po_req_line_tbl(i).SHIP_TO_ORG_ID, p_po_req_line_tbl(i).ITEM_ID);
922:
923: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
924: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_charge_acct_id before inserting: '|| l_charge_acct_id);

Line 946: INSERT INTO po_requisitions_interface_all

942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_task_completion_date : '|| to_char(l_task_completion_date, 'DD-MON-YYYY HH24:MI:SS'));
943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'l_expenditure_item_type : '|| l_expenditure_item_type);
944: END IF;
945:
946: INSERT INTO po_requisitions_interface_all
947: (
948: INTERFACE_SOURCE_CODE,
949: INTERFACE_SOURCE_LINE_ID,
950: REFERENCE_NUM,

Line 1036: ' Inserting into po_requisitions_interface_all: '||

1032: );
1033:
1034: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
1036: ' Inserting into po_requisitions_interface_all: '||
1037: ' WIP_ENTITY_ID = ' || p_po_req_line_tbl(i).WIP_ENTITY_ID ||
1038: ', PROJECT_ID = ' || p_po_req_line_tbl(i).PROJECT_ID ||
1039: ', TASK_ID = ' || p_po_req_line_tbl(i).TASK_ID ||
1040: ', EXPENDITURE_TYPE = ' || l_expenditure_item_type ||