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_MPFS_PROCESS_PKG dependencies on IGC_CC_PROCESS_DATA

Line 1352: l_approval_status igc_cc_process_data.old_approval_status%TYPE;

1348: l_return_status VARCHAR2(1);
1349: l_msg_count NUMBER;
1350: l_msg_data VARCHAR2(2000);
1351: G_FLAG VARCHAR2(1);
1352: l_approval_status igc_cc_process_data.old_approval_status%TYPE;
1353: l_Last_Updated_By NUMBER;
1354: l_Last_Update_Login NUMBER;
1355: l_Created_By NUMBER;
1356: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;

Line 1380: FROM igc_cc_process_data

1376: FOR UPDATE NOWAIT;
1377:
1378: SELECT old_approval_status
1379: INTO l_approval_status
1380: FROM igc_cc_process_data
1381: WHERE cc_header_id = p_cc_header_id AND
1382: request_id = p_request_id ;
1383:
1384: -- Fixed Bug 1633021 Removed the History Inserts for Header and Lines.

Line 1909: UPDATE igc_cc_process_data

1905: RETURN 'F';
1906: END IF;
1907:
1908: /* Update validation status, in temporary table*/
1909: UPDATE igc_cc_process_data
1910: SET
1911: processed = 'Y'
1912: WHERE request_id = p_request_id AND
1913: cc_header_id = P_cc_header_id ;

Line 1955: l_process_type igc_cc_process_data.process_type%TYPE;

1951: )
1952: AS
1953: l_request_id1 NUMBER;
1954: l_request_idt_id2 NUMBER;
1955: l_process_type igc_cc_process_data.process_type%TYPE;
1956: l_org_id NUMBER;
1957: l_sob_id NUMBER;
1958: l_start_date DATE;
1959: l_end_date DATE;

Line 2067: FROM igc_cc_process_data ccpd

2063:
2064: CURSOR c3
2065: IS
2066: SELECT *
2067: FROM igc_cc_process_data ccpd
2068: WHERE ccpd.set_of_books_id = l_sob_id
2069: AND ccpd.request_id = l_request_id1
2070: AND ccpd.org_id = l_org_id
2071: AND ccpd.process_type = l_process_type

Line 2094: igc_cc_process_data ccpd

2090: ccdpf.cc_det_pf_line_id, ccdpf.cc_det_pf_date
2091: FROM igc_cc_headers cchd,
2092: igc_cc_acct_lines ccal,
2093: igc_cc_det_pf ccdpf,
2094: igc_cc_process_data ccpd
2095: WHERE cchd.cc_header_id = ccpd.cc_header_id
2096: AND cchd.cc_header_id = ccal.cc_header_id
2097: AND ccal.cc_acct_line_id = ccdpf.cc_acct_line_id
2098: AND cchd.org_id = l_org_id

Line 2123: igc_cc_process_data ccpd

2119: )
2120: IS
2121: SELECT cchd.cc_header_id, cchd.cc_num
2122: FROM igc_cc_headers cchd,
2123: igc_cc_process_data ccpd
2124: WHERE cchd.cc_header_id = ccpd.cc_header_id
2125: AND cchd.org_id = l_org_id
2126: AND cchd.set_of_books_id = l_sob_id
2127: AND ccpd.request_id = p_request_id1

Line 2158: FROM igc_cc_process_data ccpd

2154:
2155: CURSOR c5
2156: IS
2157: SELECT *
2158: FROM igc_cc_process_data ccpd
2159: WHERE ccpd.request_id = l_request_id1
2160: AND ccpd.org_id = l_org_id
2161: AND ccpd.process_type = l_process_type
2162: AND ccpd.validation_status = 'P'

Line 2281: l_result_of_reservation igc_cc_process_data.reservation_status%TYPE;

2277: l_tgt_gl_open VARCHAR2 (1);
2278: l_tgt_cc_open VARCHAR2 (1);
2279: l_previous_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2280: l_dummy VARCHAR2 (1);
2281: l_result_of_reservation igc_cc_process_data.reservation_status%TYPE;
2282: l_result_mpfs_update VARCHAR2 (1);
2283: l_return_status VARCHAR2 (1);
2284: l_msg_count NUMBER;
2285: l_msg_data VARCHAR2 (12000);

Line 2535: /Perform the clean-up operation of IGC_CC_PROCESS_DATA and IGC_CC_PROCESS_EXCEPTIONS /

2531: RETURN;
2532: END IF;
2533:
2534: /* End bug fix 1576023 */
2535: /*Perform the clean-up operation of IGC_CC_PROCESS_DATA and IGC_CC_PROCESS_EXCEPTIONS */
2536: SAVEPOINT s1; /* Flag 1 Marked for the Complete Roll back */
2537:
2538: /* Deletes from IGC_CC_PROCESS_DATA with PHASE - Preliminary and TYPE - MPFS */
2539: DELETE FROM igc_cc_process_data a

Line 2538: /* Deletes from IGC_CC_PROCESS_DATA with PHASE - Preliminary and TYPE - MPFS */

2534: /* End bug fix 1576023 */
2535: /*Perform the clean-up operation of IGC_CC_PROCESS_DATA and IGC_CC_PROCESS_EXCEPTIONS */
2536: SAVEPOINT s1; /* Flag 1 Marked for the Complete Roll back */
2537:
2538: /* Deletes from IGC_CC_PROCESS_DATA with PHASE - Preliminary and TYPE - MPFS */
2539: DELETE FROM igc_cc_process_data a
2540: WHERE a.process_type = l_process_type
2541: AND a.process_phase = 'P'
2542: AND a.org_id = l_org_id

Line 2539: DELETE FROM igc_cc_process_data a

2535: /*Perform the clean-up operation of IGC_CC_PROCESS_DATA and IGC_CC_PROCESS_EXCEPTIONS */
2536: SAVEPOINT s1; /* Flag 1 Marked for the Complete Roll back */
2537:
2538: /* Deletes from IGC_CC_PROCESS_DATA with PHASE - Preliminary and TYPE - MPFS */
2539: DELETE FROM igc_cc_process_data a
2540: WHERE a.process_type = l_process_type
2541: AND a.process_phase = 'P'
2542: AND a.org_id = l_org_id
2543: AND a.set_of_books_id = l_sob_id;

Line 2554: DELETE FROM igc_cc_process_data a

2550:
2551: IF p_process_phase = 'F'
2552: THEN
2553: /* Deletes Unprocessed lines for Final Phase */
2554: DELETE FROM igc_cc_process_data a
2555: WHERE a.process_type = l_process_type
2556: AND a.process_phase IN ('F', 'P')
2557: AND (a.processed <> 'Y' OR a.processed IS NULL)
2558: AND a.org_id = l_org_id

Line 2562: UPDATE IGC_CC_PROCESS_DATA A

2558: AND a.org_id = l_org_id
2559: AND a.set_of_books_id = l_sob_id;
2560: /* Updates with new Request ID to those which were processed */
2561: /*
2562: UPDATE IGC_CC_PROCESS_DATA A
2563: SET REQUEST_ID = l_request_id1
2564: WHERE A.PROCESS_TYPE = l_process_type
2565: AND A.PROCESS_PHASE = 'F'
2566: AND A.PROCESSED = 'Y'

Line 2661: FROM igc_cc_process_data ccpd

2657: THEN
2658: BEGIN
2659: SELECT cc_header_id
2660: INTO l_header_id
2661: FROM igc_cc_process_data ccpd
2662: WHERE ccpd.cc_header_id = v1.cc_header_id
2663: AND ccpd.request_id = l_request_id1;
2664:
2665: UPDATE igc_cc_process_data ccpd

Line 2665: UPDATE igc_cc_process_data ccpd

2661: FROM igc_cc_process_data ccpd
2662: WHERE ccpd.cc_header_id = v1.cc_header_id
2663: AND ccpd.request_id = l_request_id1;
2664:
2665: UPDATE igc_cc_process_data ccpd
2666: SET old_approval_status = v1.cc_apprvl_status
2667: WHERE ccpd.cc_header_id = v1.cc_header_id
2668: AND ccpd.org_id = l_org_id
2669: AND ccpd.set_of_books_id = l_sob_id;

Line 2673: INSERT INTO igc_cc_process_data

2669: AND ccpd.set_of_books_id = l_sob_id;
2670: EXCEPTION
2671: WHEN NO_DATA_FOUND
2672: THEN
2673: INSERT INTO igc_cc_process_data
2674: (process_type, process_phase,
2675: cc_header_id, validation_status,
2676: reservation_status, processed,
2677: old_approval_status, org_id,

Line 2692: INSERT INTO igc_cc_process_data

2688:
2689: IF (v1.tot_unbilled_amt <= p_threshold_value)
2690: AND p_process_phase = 'P'
2691: THEN
2692: INSERT INTO igc_cc_process_data
2693: (process_type, process_phase,
2694: cc_header_id, validation_status,
2695: reservation_status, processed,
2696: old_approval_status, org_id, set_of_books_id,

Line 2780: FROM igc_cc_process_data ccpd

2776: THEN
2777: BEGIN
2778: SELECT cc_header_id
2779: INTO l_header_id
2780: FROM igc_cc_process_data ccpd
2781: WHERE ccpd.cc_header_id = v2.cc_header_id
2782: AND ccpd.request_id = l_request_id1;
2783:
2784: UPDATE igc_cc_process_data ccpd

Line 2784: UPDATE igc_cc_process_data ccpd

2780: FROM igc_cc_process_data ccpd
2781: WHERE ccpd.cc_header_id = v2.cc_header_id
2782: AND ccpd.request_id = l_request_id1;
2783:
2784: UPDATE igc_cc_process_data ccpd
2785: SET old_approval_status = v2.cc_apprvl_status
2786: WHERE ccpd.cc_header_id = v2.cc_header_id
2787: AND ccpd.org_id = l_org_id
2788: AND ccpd.set_of_books_id = l_sob_id;

Line 2796: ' IGCCMPSB -- ************ Insert data into igc_cc_process_data '

2792: IF (g_debug_mode = 'Y')
2793: THEN
2794: output_debug
2795: (l_full_path,
2796: ' IGCCMPSB -- ************ Insert data into igc_cc_process_data '
2797: || TO_CHAR (SYSDATE, 'DD-MON-YY:MI:SS')
2798: || ' *************************'
2799: );
2800: END IF;

Line 2802: INSERT INTO igc_cc_process_data

2798: || ' *************************'
2799: );
2800: END IF;
2801:
2802: INSERT INTO igc_cc_process_data
2803: (process_type, process_phase,
2804: cc_header_id, validation_status,
2805: reservation_status, processed,
2806: old_approval_status, org_id,

Line 2821: INSERT INTO igc_cc_process_data

2817:
2818: IF (v2.tot_unbilled_amt <= p_threshold_value)
2819: AND p_process_phase = 'P'
2820: THEN
2821: INSERT INTO igc_cc_process_data
2822: (process_type, process_phase,
2823: cc_header_id, validation_status,
2824: reservation_status, processed,
2825: old_approval_status, org_id, set_of_books_id,

Line 2844: FROM igc_cc_process_data

2840: /* End of Contract Selection and Filteration */
2841: -- Flag Mark 2
2842: SELECT COUNT (ROWID)
2843: INTO l_rec_found
2844: FROM igc_cc_process_data
2845: WHERE request_id = l_request_id1
2846: AND set_of_books_id = l_sob_id
2847: AND org_id = l_org_id
2848: AND process_type = l_process_type;

Line 3301: UPDATE igc_cc_process_data ccpd

3297: AND fnd_api.to_boolean (l_target_pf_found)
3298: AND NOT fnd_api.to_boolean (l_cc_inprocess)
3299: AND fnd_api.to_boolean (l_tgt_gl_open)
3300: THEN
3301: UPDATE igc_cc_process_data ccpd
3302: SET ccpd.validation_status = 'P'
3303: WHERE ccpd.cc_header_id = v4.cc_header_id
3304: AND ccpd.org_id = l_org_id
3305: AND ccpd.set_of_books_id = l_sob_id

Line 3311: UPDATE igc_cc_process_data ccpd

3307: AND ccpd.process_type = l_process_type;
3308: ELSE
3309: l_fail := fnd_api.g_true;
3310:
3311: UPDATE igc_cc_process_data ccpd
3312: SET ccpd.validation_status = 'F'
3313: WHERE ccpd.cc_header_id = v4.cc_header_id
3314: AND ccpd.org_id = l_org_id
3315: AND ccpd.set_of_books_id = l_sob_id

Line 4038: UPDATE igc_cc_process_data ccpd

4034: || ' *************************'
4035: );
4036: END IF;
4037:
4038: UPDATE igc_cc_process_data ccpd
4039: SET ccpd.validation_status = 'P'
4040: WHERE ccpd.cc_header_id = v4_1.cc_header_id
4041: AND ccpd.org_id = l_org_id
4042: AND ccpd.set_of_books_id = l_sob_id

Line 4104: UPDATE igc_cc_process_data ccpd

4100: END IF;
4101: ELSE
4102: l_fail := fnd_api.g_true;
4103:
4104: UPDATE igc_cc_process_data ccpd
4105: SET ccpd.validation_status = 'L'
4106: WHERE ccpd.cc_header_id = v4_1.cc_header_id
4107: AND ccpd.org_id = l_org_id
4108: AND ccpd.set_of_books_id = l_sob_id

Line 4183: UPDATE igc_cc_process_data ccpd

4179: END IF;
4180:
4181: IF l_result_of_reservation = 'P'
4182: THEN
4183: UPDATE igc_cc_process_data ccpd
4184: SET ccpd.reservation_status = 'P'
4185: WHERE ccpd.cc_header_id = v5.cc_header_id
4186: AND ccpd.request_id = l_request_id1;
4187:

Line 4282: UPDATE igc_cc_process_data ccpd

4278: l_exception, l_org_id, l_sob_id,
4279: l_request_id1
4280: );
4281:
4282: UPDATE igc_cc_process_data ccpd
4283: SET ccpd.reservation_status = 'F'
4284: WHERE ccpd.cc_header_id = v5.cc_header_id
4285: AND ccpd.set_of_books_id = l_sob_id
4286: AND ccpd.request_id = l_request_id1