38: , p_cc_action_request IN VARCHAR2
39: , p_error_code OUT NOCOPY NUMBER
40: ) ;
41: PROCEDURE Create_Action_History
42: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
43: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
44: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
45: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
46: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
39: , p_error_code OUT NOCOPY NUMBER
40: ) ;
41: PROCEDURE Create_Action_History
42: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
43: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
44: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
45: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
46: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
47: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
40: ) ;
41: PROCEDURE Create_Action_History
42: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
43: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
44: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
45: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
46: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
47: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
48: , p_cc_notes IN IGC_CC_ACTIONS.cc_action_notes%TYPE
41: PROCEDURE Create_Action_History
42: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
43: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
44: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
45: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
46: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
47: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
48: , p_cc_notes IN IGC_CC_ACTIONS.cc_action_notes%TYPE
49: , p_action_requested IN VARCHAR2
42: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
43: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
44: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
45: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
46: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
47: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
48: , p_cc_notes IN IGC_CC_ACTIONS.cc_action_notes%TYPE
49: , p_action_requested IN VARCHAR2
50: , p_error_code OUT NOCOPY NUMBER
43: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
44: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
45: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
46: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
47: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
48: , p_cc_notes IN IGC_CC_ACTIONS.cc_action_notes%TYPE
49: , p_action_requested IN VARCHAR2
50: , p_error_code OUT NOCOPY NUMBER
51: ) ;
451: -- read the new encumbrance status from the database.
452:
453: SELECT cc_encmbrnc_status
454: INTO l_cc_encumb_status
455: FROM igc_cc_headers
456: WHERE cc_header_id = l_cc_header_id;
457:
458: IF (g_debug_mode = 'Y') THEN
459: Put_Debug_Msg(l_full_path, 'New enc status is: '||l_cc_encumb_status);
606: , p_error_code OUT NOCOPY NUMBER
607: ) IS
608:
609:
610: l_cc_header_id IGC_CC_HEADERS.cc_header_id%TYPE := p_cc_header_id;
611: l_cc_state VARCHAR2(100) := p_cc_state;
612: l_cc_encumbrnc_status VARCHAR2(100) := p_cc_encumb_status;
613:
614:
614:
615: l_cc_number VARCHAR2(255);
616: CURSOR c_ccnum IS
617: SELECT cc_num
618: FROM igc_cc_headers
619: WHERE cc_header_id = l_cc_header_id;
620:
621: l_full_path VARCHAR2(255);
622:
640: Put_Debug_Msg(l_full_path, 'Updating headers to Approved status');
641: END IF;
642:
643:
644: UPDATE IGC_CC_HEADERS
645: SET cc_apprvl_status = 'AP'
646: WHERE cc_header_id = l_cc_header_id;
647:
648: ELSE
663: RAISE FND_API.G_EXC_ERROR;
664:
665: END IF;
666:
667: -- update database table IGC_CC_HEADERS
668:
669: END; -- END procedure change_document_status, overloaded.
670:
671:
669: END; -- END procedure change_document_status, overloaded.
670:
671:
672: PROCEDURE Create_Action_History
673: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
674: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
675: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
676: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
677: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
670:
671:
672: PROCEDURE Create_Action_History
673: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
674: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
675: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
676: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
677: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
678: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
671:
672: PROCEDURE Create_Action_History
673: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
674: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
675: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
676: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
677: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
678: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
679: , p_cc_notes IN IGC_CC_ACTIONS.cc_action_notes%TYPE
672: PROCEDURE Create_Action_History
673: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
674: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
675: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
676: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
677: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
678: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
679: , p_cc_notes IN IGC_CC_ACTIONS.cc_action_notes%TYPE
680: , p_action_requested IN VARCHAR2
673: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE
674: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
675: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
676: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
677: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
678: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
679: , p_cc_notes IN IGC_CC_ACTIONS.cc_action_notes%TYPE
680: , p_action_requested IN VARCHAR2
681: , p_error_code OUT NOCOPY NUMBER
674: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%TYPE
675: , p_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
676: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%TYPE
677: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE
678: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%TYPE
679: , p_cc_notes IN IGC_CC_ACTIONS.cc_action_notes%TYPE
680: , p_action_requested IN VARCHAR2
681: , p_error_code OUT NOCOPY NUMBER
682: ) IS