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 311: FROM igc_cc_headers_all cch

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

Line 378: l_CC_STATE igc_cc_headers.cc_state%type;

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

Line 379: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;

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

Line 380: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;

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

Line 381: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;

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

Line 398: FROM IGC_CC_HEADERS

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

Line 426: FROM IGC_CC_HEADERS

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

Line 489: FROM IGC_CC_HEADERS

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

Line 589: FROM IGC_CC_HEADERS

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