1148: , p_document_subtype IN VARCHAR2
1149: --
1150: , p_document_level IN VARCHAR2
1151: , p_document_level_id IN NUMBER
1152: --
1154: , p_check_asl IN BOOLEAN -- bug 2757450
1155: , p_draft_id IN NUMBER := -1
1156: , p_req_chg_initiator IN VARCHAR2 -- bug 4957243
1149: --
1150: , p_document_level IN VARCHAR2
1151: , p_document_level_id IN NUMBER
1152: --
1153: , p_requested_changes IN PO_CHANGES_REC_TYPE
1154: , p_check_asl IN BOOLEAN -- bug 2757450
1155: , p_draft_id IN NUMBER := -1
1156: , p_req_chg_initiator IN VARCHAR2 -- bug 4957243
1157: , p_origin_doc_id IN NUMBER := NULL --Bug#5462677
13690: */
13691: PROCEDURE update_global_temp_tables(p_document_type IN VARCHAR2,
13692: p_document_subtype IN VARCHAR2,
13693: p_document_id IN NUMBER,
13694: --
13696: x_return_status OUT NOCOPY VARCHAR2) IS
13697:
13698: l_api_name CONSTANT varchar2(40) := 'UPDATE_GLOBAL_TEMP_TABLES';
13691: PROCEDURE update_global_temp_tables(p_document_type IN VARCHAR2,
13692: p_document_subtype IN VARCHAR2,
13693: p_document_id IN NUMBER,
13694: --
13695: p_requested_changes IN PO_CHANGES_REC_TYPE,
13696: x_return_status OUT NOCOPY VARCHAR2) IS
13697:
13698: l_api_name CONSTANT varchar2(40) := 'UPDATE_GLOBAL_TEMP_TABLES';
13699: l_progress VARCHAR2(3);