[Home] [Help]
902: g_progress := '400';
903: IF g_debug_stmt THEN
904: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
905: p_token => g_progress,
906: p_message => 'Before calling PO_HEADERS_PKG_S0.Insert_Row');
907: END IF;
908: l_current_org := PO_GA_PVT.get_current_org; --
909: PO_HEADERS_PKG_S0.Insert_Row(
910: X_Rowid => l_rowid,
905: p_token => g_progress,
906: p_message => 'Before calling PO_HEADERS_PKG_S0.Insert_Row');
907: END IF;
908: l_current_org := PO_GA_PVT.get_current_org; --
909: PO_HEADERS_PKG_S0.Insert_Row(
910: X_Rowid => l_rowid,
911: X_Po_Header_Id => l_po_header_id,
912: X_Agent_Id => g_cpa_csr.agent_id,
913: X_Type_Lookup_Code => g_cpa_csr.document_subtype,
1032: g_progress := '401';
1033: IF g_debug_stmt THEN
1034: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1035: p_token => g_progress,
1036: p_message => 'After calling PO_HEADERS_PKG_S0.Insert_Row. po_header_id = '||l_po_header_id||': Segment1 = '||l_document_num);
1037:
1038: END IF;
1039:
1040: -- After insert into po_headers, insert a row into org_assignments for a global agreement
1441:
1442: --SQL WHAT: Updates Conterms_exist_flag, segment1 and document_creation_method
1443: --SQL WHY: To handle creation of an automatic document_number when the po_num_code is AUTOMATIC
1444: -- Update pf conterms_exist_flag and document_creation_method should have been
1445: -- handled in PO_HEADERS_PKG_S0.Insert_Row table handler.
1446: -- As this file is not allowed to update for 11.5.10, added separate update statement.
1447: --SQl Join:None
1448:
1449: UPDATE PO_HEADERS_ALL