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_COMPLETE_COVER_PKG dependencies on IGC_CC_HEADERS

Line 20: ,p_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE

16: g_path varchar2(500) := 'igc.plsql.igcccovb.igc_cc_complete_cover_pkg.';
17:
18: Procedure complete_cover ( errbuf OUT NOCOPY VARCHAR2
19: ,retcode OUT NOCOPY NUMBER
20: ,p_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
21: /*Bug No : 6341012. MOAC uptake SOB_ID,ORG_ID are retrieved from Packages rather than from Profile values */
22: -- ,p_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE
23: -- ,p_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE
24: ,p_comp_unmatched_rel IN VARCHAR2

Line 22: -- ,p_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE

18: Procedure complete_cover ( errbuf OUT NOCOPY VARCHAR2
19: ,retcode OUT NOCOPY NUMBER
20: ,p_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
21: /*Bug No : 6341012. MOAC uptake SOB_ID,ORG_ID are retrieved from Packages rather than from Profile values */
22: -- ,p_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE
23: -- ,p_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE
24: ,p_comp_unmatched_rel IN VARCHAR2
25: ,p_comp_cover IN VARCHAR2 ) IS
26:

Line 23: -- ,p_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE

19: ,retcode OUT NOCOPY NUMBER
20: ,p_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
21: /*Bug No : 6341012. MOAC uptake SOB_ID,ORG_ID are retrieved from Packages rather than from Profile values */
22: -- ,p_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE
23: -- ,p_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE
24: ,p_comp_unmatched_rel IN VARCHAR2
25: ,p_comp_cover IN VARCHAR2 ) IS
26:
27: /*Bug No : 6341012. MOAC uptake. Local variables for SOB_ID,ORG_ID,SOB_NAME */

Line 28: l_org_id IGC_CC_HEADERS.ORG_ID%TYPE;

24: ,p_comp_unmatched_rel IN VARCHAR2
25: ,p_comp_cover IN VARCHAR2 ) IS
26:
27: /*Bug No : 6341012. MOAC uptake. Local variables for SOB_ID,ORG_ID,SOB_NAME */
28: l_org_id IGC_CC_HEADERS.ORG_ID%TYPE;
29: l_set_of_books_id IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE;
30: l_sob_name VARCHAR2(30);
31:
32: l_request_id NUMBER;

Line 29: l_set_of_books_id IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE;

25: ,p_comp_cover IN VARCHAR2 ) IS
26:
27: /*Bug No : 6341012. MOAC uptake. Local variables for SOB_ID,ORG_ID,SOB_NAME */
28: l_org_id IGC_CC_HEADERS.ORG_ID%TYPE;
29: l_set_of_books_id IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE;
30: l_sob_name VARCHAR2(30);
31:
32: l_request_id NUMBER;
33: l_validation_error_code VARCHAR2(1);

Line 67: from igc_cc_headers

63: -- Cursor C_releases selects all releases for a cover commitment
64:
65: Cursor C_releases is
66: Select *
67: from igc_cc_headers
68: where parent_header_id = p_cc_header_id
69: and set_of_books_id = l_set_of_books_id
70: and org_id = l_org_id;
71:

Line 76: from igc_cc_headers

72: -- Cursor C_cover selects the cover commitment information
73:
74: Cursor C_cover is
75: Select *
76: from igc_cc_headers
77: where cc_header_id = p_cc_header_id
78: and set_of_books_id = l_set_of_books_id
79: and org_id = l_org_id;
80:

Line 114: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE ) IS

110: -- in the current fiscal year for a particular CC Release
111:
112: Cursor C_payment_forecast ( x_start_date IN DATE
113: , x_end_date IN DATE
114: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE ) IS
115: Select count(*) lines
116: from igc_cc_det_pf_v pf
117: where pf.cc_acct_line_id in ( select al.cc_acct_line_id
118: from igc_cc_acct_lines al

Line 125: Cursor C_purchase_orders ( x_cc_num IN IGC_CC_HEADERS.CC_NUM%TYPE ) IS

121: */
122:
123: -- Cursor C_purchase_orders selects the purchase orders created from a CC Release
124:
125: Cursor C_purchase_orders ( x_cc_num IN IGC_CC_HEADERS.CC_NUM%TYPE ) IS
126: Select po_header_id
127: from PO_HEADERS
128: where segment1 = x_cc_num
129: and type_lookup_code = 'STANDARD';

Line 158: -- Procedure update_releases update the columns of igc_cc_headers table

154: l_msg_count := NULL;
155: l_msg_data := NULL;
156: End;
157:
158: -- Procedure update_releases update the columns of igc_cc_headers table
159:
160: Procedure Update_releases ( x_cc_state IN IGC_CC_HEADERS.CC_STATE%TYPE
161: , x_cc_apprvl_status IN IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE
162: , x_ctrl_status IN IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE

Line 160: Procedure Update_releases ( x_cc_state IN IGC_CC_HEADERS.CC_STATE%TYPE

156: End;
157:
158: -- Procedure update_releases update the columns of igc_cc_headers table
159:
160: Procedure Update_releases ( x_cc_state IN IGC_CC_HEADERS.CC_STATE%TYPE
161: , x_cc_apprvl_status IN IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE
162: , x_ctrl_status IN IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE
163: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
164: , x_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE

Line 161: , x_cc_apprvl_status IN IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE

157:
158: -- Procedure update_releases update the columns of igc_cc_headers table
159:
160: Procedure Update_releases ( x_cc_state IN IGC_CC_HEADERS.CC_STATE%TYPE
161: , x_cc_apprvl_status IN IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE
162: , x_ctrl_status IN IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE
163: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
164: , x_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE
165: , x_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE ) IS

Line 162: , x_ctrl_status IN IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE

158: -- Procedure update_releases update the columns of igc_cc_headers table
159:
160: Procedure Update_releases ( x_cc_state IN IGC_CC_HEADERS.CC_STATE%TYPE
161: , x_cc_apprvl_status IN IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE
162: , x_ctrl_status IN IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE
163: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
164: , x_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE
165: , x_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE ) IS
166: Begin

Line 163: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE

159:
160: Procedure Update_releases ( x_cc_state IN IGC_CC_HEADERS.CC_STATE%TYPE
161: , x_cc_apprvl_status IN IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE
162: , x_ctrl_status IN IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE
163: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
164: , x_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE
165: , x_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE ) IS
166: Begin
167: Update igc_cc_headers

Line 164: , x_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE

160: Procedure Update_releases ( x_cc_state IN IGC_CC_HEADERS.CC_STATE%TYPE
161: , x_cc_apprvl_status IN IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE
162: , x_ctrl_status IN IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE
163: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
164: , x_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE
165: , x_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE ) IS
166: Begin
167: Update igc_cc_headers
168: set cc_state = x_cc_state

Line 165: , x_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE ) IS

161: , x_cc_apprvl_status IN IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE
162: , x_ctrl_status IN IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE
163: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
164: , x_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE
165: , x_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE ) IS
166: Begin
167: Update igc_cc_headers
168: set cc_state = x_cc_state
169: , cc_apprvl_status = x_cc_apprvl_status

Line 167: Update igc_cc_headers

163: , x_cc_header_id IN IGC_CC_HEADERS.CC_HEADER_ID%TYPE
164: , x_set_of_books_id IN IGC_CC_HEADERS.SET_OF_BOOKS_ID%TYPE
165: , x_org_id IN IGC_CC_HEADERS.ORG_ID%TYPE ) IS
166: Begin
167: Update igc_cc_headers
168: set cc_state = x_cc_state
169: , cc_apprvl_status = x_cc_apprvl_status
170: , cc_ctrl_status = x_ctrl_status
171: where cc_header_id = x_cc_header_id