530: , p_document_subtype IN VARCHAR2
531: --
532: , p_document_level IN VARCHAR2
533: , p_document_level_id IN NUMBER
534: --
536: , p_check_asl IN BOOLEAN -- bug 2757450
537: , p_req_chg_initiator IN VARCHAR2 -- bug 4957243
538: , p_origin_doc_id IN NUMBER := NULL --Bug#5462677
531: --
532: , p_document_level IN VARCHAR2
533: , p_document_level_id IN NUMBER
534: --
535: , p_requested_changes IN PO_CHANGES_REC_TYPE
536: , p_check_asl IN BOOLEAN -- bug 2757450
537: , p_req_chg_initiator IN VARCHAR2 -- bug 4957243
538: , p_origin_doc_id IN NUMBER := NULL --Bug#5462677
539: , x_return_status OUT NOCOPY VARCHAR2
10332: */
10333: PROCEDURE update_global_temp_tables(p_document_type IN VARCHAR2,
10334: p_document_subtype IN VARCHAR2,
10335: p_document_id IN NUMBER,
10336: --
10338: x_return_status OUT NOCOPY VARCHAR2) IS
10339:
10340: l_api_name CONSTANT varchar2(40) := 'UPDATE_GLOBAL_TEMP_TABLES';
10333: PROCEDURE update_global_temp_tables(p_document_type IN VARCHAR2,
10334: p_document_subtype IN VARCHAR2,
10335: p_document_id IN NUMBER,
10336: --
10337: p_requested_changes IN PO_CHANGES_REC_TYPE,
10338: x_return_status OUT NOCOPY VARCHAR2) IS
10339:
10340: l_api_name CONSTANT varchar2(40) := 'UPDATE_GLOBAL_TEMP_TABLES';
10341: l_progress VARCHAR2(3);