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

Line 76: | coded fields stored at the header level in igc_cc_headers |

72: /*=======================================================================+
73: | PROCEDURE Get_Header_Desc
74: | |
75: | Note : This procedure is designed to get the descriptions of all the |
76: | coded fields stored at the header level in igc_cc_headers |
77: | It is used by forms like IGCCSUMM to get the descriptions |
78: | of the field to be displayed to the user. |
79: | |
80: | |

Line 94: | p_cc_header_id igc_cc_headers.cc_header_id |

90: | p_msg_count Number of messages on stack returned |
91: | p_msg_data Message text information returned |
92: | |
93: | Parameters for Procedure to process properly. |
94: | p_cc_header_id igc_cc_headers.cc_header_id |
95: | |
96: +=======================================================================*/
97: PROCEDURE Get_Header_Desc
98: (

Line 141: FROM igc_cc_headers_all

137: location_id,
138: cc_owner_user_id,
139: cc_preparer_user_id,
140: parent_header_id
141: FROM igc_cc_headers_all
142: WHERE cc_header_id = p_cc_header_id;
143:
144:
145: l_header_rec c_get_header%ROWTYPE;

Line 309: FROM igc_cc_headers_all cch

305: -- Parent CC Num
306: BEGIN
307: SELECT cch.cc_num
308: INTO p_parent_cc_num
309: FROM igc_cc_headers_all cch
310: WHERE cch.cc_header_id = l_header_rec.parent_header_id;
311: EXCEPTION
312: WHEN NO_DATA_FOUND THEN
313: p_parent_cc_num := NULL;

Line 376: l_CC_STATE igc_cc_headers.cc_state%type;

372: IS
373:
374: l_cc_num po_headers.segment1%type; /* cc number */
375: l_pf_date igc_cc_det_pf.cc_det_pf_date%type; /* Payment forecast date */
376: l_CC_STATE igc_cc_headers.cc_state%type;
377: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;
378: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;
379: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;
380: l_status BOOLEAN; /* holds value whether the CC can be matched or not */

Line 377: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;

373:
374: l_cc_num po_headers.segment1%type; /* cc number */
375: l_pf_date igc_cc_det_pf.cc_det_pf_date%type; /* Payment forecast date */
376: l_CC_STATE igc_cc_headers.cc_state%type;
377: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;
378: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;
379: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;
380: l_status BOOLEAN; /* holds value whether the CC can be matched or not */
381: l_fiscal_year_invoice gl_period_statuses.period_year%type; /* fiscal year of invoice */

Line 378: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;

374: l_cc_num po_headers.segment1%type; /* cc number */
375: l_pf_date igc_cc_det_pf.cc_det_pf_date%type; /* Payment forecast date */
376: l_CC_STATE igc_cc_headers.cc_state%type;
377: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;
378: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;
379: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;
380: l_status BOOLEAN; /* holds value whether the CC can be matched or not */
381: l_fiscal_year_invoice gl_period_statuses.period_year%type; /* fiscal year of invoice */
382: l_fiscal_year_pf gl_period_statuses.period_year%type; /* fiscal year of specific Payment Forecast line */

Line 379: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;

375: l_pf_date igc_cc_det_pf.cc_det_pf_date%type; /* Payment forecast date */
376: l_CC_STATE igc_cc_headers.cc_state%type;
377: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;
378: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;
379: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;
380: l_status BOOLEAN; /* holds value whether the CC can be matched or not */
381: l_fiscal_year_invoice gl_period_statuses.period_year%type; /* fiscal year of invoice */
382: l_fiscal_year_pf gl_period_statuses.period_year%type; /* fiscal year of specific Payment Forecast line */
383: l_period gl_period_statuses.period_name%TYPE;

Line 396: FROM IGC_CC_HEADERS

392: IS
393: SELECT CC_acct_LINE_ID
394: FROM IGC_CC_ACCT_LINES
395: WHERE cc_header_id = (SELECT cc_header_id
396: FROM IGC_CC_HEADERS
397: WHERE CC_NUM = p_cc_num)
398: AND CC_ACCT_LINE_NUM = x_shipment_num;
399:
400: -- Cursor to get the distribution numbers of all the distributions for the CC

Line 424: FROM IGC_CC_HEADERS

420: CURSOR c_get_cc_acct_line_id(p_shipment_num po_line_locations.shipment_num%type)
421: IS SELECT cc_acct_line_id
422: FROM igc_cc_acct_lines
423: WHERE cc_header_id = (SELECT cc_header_id
424: FROM IGC_CC_HEADERS
425: WHERE CC_NUM = l_cc_num)
426: AND cc_acct_line_num = p_shipment_num;
427:
428: CURSOR c_get_distribution_num(p_po_line_id po_lines_all.po_line_id%type,

Line 487: FROM IGC_CC_HEADERS

483: INTO l_CC_STATE,
484: l_CC_CTRL_STATUS,
485: l_CC_ENCMBRNC_STATUS,
486: l_CC_APPRVL_STATUS
487: FROM IGC_CC_HEADERS
488: WHERE CC_NUM = l_cc_num;
489: EXCEPTION
490: /* No need to check for validation if its a PO, bug # 5687596*/
491: WHEN NO_DATA_FOUND THEN

Line 587: FROM IGC_CC_HEADERS

583: FROM IGC_CC_DET_PF
584: WHERE CC_acct_LINE_ID = (SELECT CC_acct_LINE_ID
585: FROM IGC_CC_ACCT_LINES
586: WHERE cc_header_id = (SELECT cc_header_id
587: FROM IGC_CC_HEADERS
588: WHERE CC_NUM = l_cc_num)
589: AND CC_ACCT_LINE_NUM = x_shipment_num)
590: AND CC_DET_PF_LINE_NUM = x_po_dist_num;
591: EXCEPTION