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 STANDARD

Line 1815: -- AND pha2.type_lookup_code = 'STANDARD');

1811: -- po_headers pha2
1812: -- WHERE cchd.org_id = p_org_id
1813: -- AND cchd.cc_header_id = l_cc_headers_rec.cc_header_id
1814: -- AND cchd.cc_num = pha2.segment1
1815: -- AND pha2.type_lookup_code = 'STANDARD');
1816: SELECT 'Y'
1817: INTO l_dummy
1818: FROM po_headers_all pha1,
1819: igc_cc_headers cchd

Line 1823: AND pha1.type_lookup_code = 'STANDARD'

1819: igc_cc_headers cchd
1820: WHERE cchd.org_id = p_org_id
1821: AND cchd.cc_header_id = l_cc_headers_rec.cc_header_id
1822: AND cchd.cc_num = pha1.segment1
1823: AND pha1.type_lookup_code = 'STANDARD'
1824: AND pha1.org_id = p_org_id;
1825:
1826: l_return_status := FND_API.G_RET_STS_SUCCESS;
1827: IF (g_debug_mode = 'Y') THEN

Line 2380: /* This procedure checks the Encumbrance setup for Standard and Commitment Budgets */

2376: MO_UTILS.get_ledger_info(l_org_id,l_sob_id,l_sob_name);
2377:
2378:
2379: /* Begin bug fix 1576023 */
2380: /* This procedure checks the Encumbrance setup for Standard and Commitment Budgets */
2381: l_msg_data := NULL;
2382: l_msg_count := 0;
2383: l_usr_msg := NULL;
2384:

Line 4066: -- AND pha2.type_lookup_code = 'STANDARD');

4062: -- po_headers pha2
4063: -- WHERE cchd.org_id = l_org_id
4064: -- AND cchd.cc_header_id = V4.cc_header_id
4065: -- AND cchd.cc_num = pha2.segment1
4066: -- AND pha2.type_lookup_code = 'STANDARD');
4067: SELECT 'Y'
4068: INTO l_dummy
4069: FROM po_headers_all pha1, igc_cc_headers cchd
4070: WHERE cchd.org_id = l_org_id

Line 4073: AND pha1.type_lookup_code = 'STANDARD'

4069: FROM po_headers_all pha1, igc_cc_headers cchd
4070: WHERE cchd.org_id = l_org_id
4071: AND cchd.cc_header_id = v4_1.cc_header_id
4072: AND cchd.cc_num = pha1.segment1
4073: AND pha1.type_lookup_code = 'STANDARD'
4074: AND pha1.org_id = l_org_id;
4075:
4076: -- Performance Tuning
4077: -- Replaced the following update with the one below

Line 4086: -- AND pha2.type_lookup_code = 'STANDARD');

4082: -- FROM po_headers pha2, igc_cc_headers cchd
4083: -- WHERE cchd.cc_header_id = V4.cc_header_id
4084: -- AND pha2.segment1 = cchd.cc_num
4085: -- AND pha2.org_id = cchd.org_id
4086: -- AND pha2.type_lookup_code = 'STANDARD');
4087: UPDATE po_headers_all pha1
4088: SET pha1.approved_flag = 'N'
4089: WHERE pha1.type_lookup_code = 'STANDARD'
4090: AND pha1.org_id = l_org_id

Line 4089: WHERE pha1.type_lookup_code = 'STANDARD'

4085: -- AND pha2.org_id = cchd.org_id
4086: -- AND pha2.type_lookup_code = 'STANDARD');
4087: UPDATE po_headers_all pha1
4088: SET pha1.approved_flag = 'N'
4089: WHERE pha1.type_lookup_code = 'STANDARD'
4090: AND pha1.org_id = l_org_id
4091: AND pha1.segment1 =
4092: (SELECT cchd.cc_num
4093: FROM igc_cc_headers cchd

Line 4309: -- AND pha2.type_lookup_code = 'STANDARD');

4305: -- po_headers pha2
4306: -- WHERE cchd.org_id = l_org_id
4307: -- AND cchd.cc_header_id = V5.cc_header_id
4308: -- AND cchd.cc_num = pha2.segment1
4309: -- AND pha2.type_lookup_code = 'STANDARD');
4310: SELECT 'Y'
4311: INTO l_dummy
4312: FROM po_headers_all pha1, igc_cc_headers cchd
4313: WHERE cchd.org_id = l_org_id

Line 4316: AND pha1.type_lookup_code = 'STANDARD'

4312: FROM po_headers_all pha1, igc_cc_headers cchd
4313: WHERE cchd.org_id = l_org_id
4314: AND cchd.cc_header_id = v5.cc_header_id
4315: AND cchd.cc_num = pha1.segment1
4316: AND pha1.type_lookup_code = 'STANDARD'
4317: AND pha1.org_id = l_org_id;
4318:
4319: -- Performance Tuning
4320: -- Replaced the following update with the one below

Line 4329: -- AND pha2.type_lookup_code = 'STANDARD');

4325: -- FROM po_headers pha2, igc_cc_headers cchd
4326: -- WHERE cchd.cc_header_id = V5.cc_header_id
4327: -- AND pha2.segment1 = cchd.cc_num
4328: -- AND pha2.org_id = cchd.org_id
4329: -- AND pha2.type_lookup_code = 'STANDARD');
4330: UPDATE po_headers_all pha1
4331: SET pha1.approved_flag = 'Y'
4332: WHERE pha1.type_lookup_code = 'STANDARD'
4333: AND pha1.org_id = l_org_id

Line 4332: WHERE pha1.type_lookup_code = 'STANDARD'

4328: -- AND pha2.org_id = cchd.org_id
4329: -- AND pha2.type_lookup_code = 'STANDARD');
4330: UPDATE po_headers_all pha1
4331: SET pha1.approved_flag = 'Y'
4332: WHERE pha1.type_lookup_code = 'STANDARD'
4333: AND pha1.org_id = l_org_id
4334: AND pha1.segment1 =
4335: (SELECT cchd.cc_num
4336: FROM igc_cc_headers cchd