eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_APPROVAL_PROCESS dependencies on IGC_CC_HEADERS

Line 42: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE

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

Line 43: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%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

Line 44: , p_cc_state IN IGC_CC_HEADERS.cc_state%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

Line 45: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%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

Line 46: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE

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

Line 47: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%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
51: ) ;

Line 455: FROM igc_cc_headers

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);

Line 610: l_cc_header_id IGC_CC_HEADERS.cc_header_id%TYPE := p_cc_header_id;

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:

Line 618: FROM igc_cc_headers

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:

Line 644: UPDATE IGC_CC_HEADERS

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

Line 667: -- update database table IGC_CC_HEADERS

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:

Line 673: ( p_cc_header_id IN IGC_CC_HEADERS.cc_header_id%TYPE

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

Line 674: , p_cc_version_num IN IGC_CC_HEADERS.cc_version_num%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

Line 675: , p_cc_state IN IGC_CC_HEADERS.cc_state%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

Line 676: , p_cc_old_cc_state IN IGC_CC_HEADERS.cc_state%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

Line 677: , p_cc_ctrl_status IN IGC_CC_HEADERS.cc_ctrl_status%TYPE

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

Line 678: , p_cc_apprvl_status IN IGC_CC_HEADERS.cc_apprvl_status%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
682: ) IS