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_REVALUE_PROCESS_PKG dependencies on STANDARD

Line 1734: /* Fetch the cover-standard data from temporary table */

1730: /* bug 1622969 */
1731: b.cc_type = 'C';
1732:
1733:
1734: /* Fetch the cover-standard data from temporary table */
1735: CURSOR c_reval_data(p_request_id NUMBER)
1736: IS
1737: SELECT a.cc_header_id
1738: FROM igc_cc_process_data a ,

Line 2322: /* Begin Standard Revaluation */

2318: EXIT WHEN c_revalue_process_cc%NOTFOUND;
2319:
2320: l_process_data_count := l_process_data_count + 1;
2321:
2322: /* Begin Standard Revaluation */
2323: IF (l_cc_headers_rec.cc_type = 'S')
2324: THEN
2325: -- IF l_debug_mode = 'Y' THEN
2326: -- Output_Debug (' IGCCREPB -- Inserting CC type S record into process data table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

Line 2365: /* End Standard Revaluation */

2361:
2362: COMMIT;
2363:
2364: END IF;
2365: /* End Standard Revaluation */
2366:
2367: /* Begin release Revaluation */
2368:
2369: IF (l_cc_headers_rec.cc_type = 'R')

Line 2770: /* Standard */

2766: WHERE cc_header_id = l_cc_header_id;
2767:
2768: l_lock_cc_po := TRUE;
2769:
2770: /* Standard */
2771: IF (l_cc_headers_rec.cc_type = 'S')
2772: THEN
2773: -- IF l_debug_mode = 'Y' THEN
2774: -- Output_Debug (' IGCCREPB -- Attempting lock cc po ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

Line 3904: -- Output_Debug (' IGCCREPB -- Checking CC type Standard ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

3900:
3901: /* Added the following code for bug 1613811 */
3902: /* Change begin */
3903: -- IF l_debug_mode = 'Y' THEN
3904: -- Output_Debug (' IGCCREPB -- Checking CC type Standard ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3905: -- END IF;
3906:
3907: -- bug 3199488, start block
3908: IF (l_state_level >= l_debug_level) THEN

Line 3910: ' IGCCREPB -- Checking CC type Standard ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

3906:
3907: -- bug 3199488, start block
3908: IF (l_state_level >= l_debug_level) THEN
3909: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg72',
3910: ' IGCCREPB -- Checking CC type Standard ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3911: END IF;
3912: -- bug 3199488, end block
3913:
3914: IF (l_cc_headers_rec.cc_type = 'S')

Line 3917: -- Output_Debug (' IGCCREPB -- Standard CC getting PO line count ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

3913:
3914: IF (l_cc_headers_rec.cc_type = 'S')
3915: THEN
3916: -- IF l_debug_mode = 'Y' THEN
3917: -- Output_Debug (' IGCCREPB -- Standard CC getting PO line count ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3918: -- END IF;
3919:
3920: -- bug 3199488, start block
3921: IF (l_state_level >= l_debug_level) THEN

Line 3923: ' IGCCREPB -- Standard CC getting PO line count ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

3919:
3920: -- bug 3199488, start block
3921: IF (l_state_level >= l_debug_level) THEN
3922: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg73',
3923: ' IGCCREPB -- Standard CC getting PO line count ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3924: END IF;
3925: -- bug 3199488, end block
3926:
3927: l_po_count := 0;

Line 3935: type_lookup_code = 'STANDARD' ;

3931: INTO l_po_count
3932: FROM po_headers_all
3933: WHERE segment1 = l_cc_headers_rec.cc_num AND
3934: org_id = l_cc_headers_rec.org_id AND
3935: type_lookup_code = 'STANDARD' ;
3936: EXCEPTION
3937: WHEN NO_DATA_FOUND
3938: THEN
3939: l_po_count := 0;

Line 3967: type_lookup_code = 'STANDARD' AND

3963: UPDATE po_headers_all
3964: SET approved_flag = 'N'
3965: WHERE segment1 = l_cc_headers_rec.cc_num AND
3966: org_id = l_cc_headers_rec.org_id AND
3967: type_lookup_code = 'STANDARD' AND
3968: approved_flag = 'Y';
3969: END;
3970: END IF;
3971:

Line 4053: type_lookup_code = 'STANDARD' ;

4049: INTO l_po_count
4050: FROM po_headers_all
4051: WHERE segment1 = l_rel_cc_headers_rec.cc_num AND
4052: org_id = l_rel_cc_headers_rec.org_id AND
4053: type_lookup_code = 'STANDARD' ;
4054: EXCEPTION
4055: WHEN NO_DATA_FOUND
4056: THEN
4057: l_po_count := 0;

Line 4077: type_lookup_code = 'STANDARD' AND

4073: UPDATE po_headers_all
4074: SET approved_flag = 'N'
4075: WHERE segment1 = l_rel_cc_headers_rec.cc_num AND
4076: org_id = l_rel_cc_headers_rec.org_id AND
4077: type_lookup_code = 'STANDARD' AND
4078: /* Changed condition below from approved_flag = Y to approved flag = N to fix bug 1613811 */
4079: approved_flag = 'Y';
4080: END;
4081: END IF;

Line 4117: -- Output_Debug (' IGCCREPB -- Updating Cover or Standard in process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4113:
4114: IF (l_cc_headers_rec.cc_type = 'C') OR (l_cc_headers_rec.cc_type = 'S')
4115: THEN
4116: -- IF l_debug_mode = 'Y' THEN
4117: -- Output_Debug (' IGCCREPB -- Updating Cover or Standard in process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4118: -- END IF;
4119: -- bug 3199488, start block
4120: IF (l_state_level >= l_debug_level) THEN
4121: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg84',

Line 4122: ' IGCCREPB -- Updating cover or Standard in process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4118: -- END IF;
4119: -- bug 3199488, start block
4120: IF (l_state_level >= l_debug_level) THEN
4121: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg84',
4122: ' IGCCREPB -- Updating cover or Standard in process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4123: END IF;
4124: -- bug 3199488, end block
4125:
4126: UPDATE igc_cc_process_data

Line 4709: -- Output_Debug (' IGCCREPB -- Standard reval ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4705: END IF;
4706: ELSIF (l_cc_headers_rec.cc_type = 'S')
4707: THEN
4708: -- IF l_debug_mode = 'Y' THEN
4709: -- Output_Debug (' IGCCREPB -- Standard reval ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4710: -- END IF;
4711:
4712: -- bug 3199488, start block
4713: IF (l_state_level >= l_debug_level) THEN

Line 4714: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg106','IGCCREPB -- Standard reval ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4710: -- END IF;
4711:
4712: -- bug 3199488, start block
4713: IF (l_state_level >= l_debug_level) THEN
4714: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg106','IGCCREPB -- Standard reval ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4715: END IF;
4716: -- bug 3199488, end block
4717:
4718: SAVEPOINT REVALUE6;

Line 4726: -- Output_Debug (' IGCCREPB -- Standard reval P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4722:
4723: IF (l_reservation_status = 'P')
4724: THEN
4725: -- IF l_debug_mode = 'Y' THEN
4726: -- Output_Debug (' IGCCREPB -- Standard reval P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4727: -- END IF;
4728: -- bug 3199488, start block
4729: IF (l_state_level >= l_debug_level) THEN
4730: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg107','IGCCREPB -- Standard reval P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

Line 4730: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg107','IGCCREPB -- Standard reval P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4726: -- Output_Debug (' IGCCREPB -- Standard reval P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4727: -- END IF;
4728: -- bug 3199488, start block
4729: IF (l_state_level >= l_debug_level) THEN
4730: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg107','IGCCREPB -- Standard reval P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4731: END IF;
4732: -- bug 3199488, end block
4733: l_message := NULL;
4734: l_err_header_id := NULL;

Line 4756: -- Output_Debug (' IGCCREPB -- Standard reval F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4752: l_err_det_pf_line_id);
4753: ELSIF (l_reservation_status = 'F')
4754: THEN
4755: -- IF l_debug_mode = 'Y' THEN
4756: -- Output_Debug (' IGCCREPB -- Standard reval F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4757: -- END IF;
4758: -- bug 3199488, start block
4759: IF (l_state_level >= l_debug_level) THEN
4760: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg108',

Line 4761: 'IGCCREPB -- Standard reval F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4757: -- END IF;
4758: -- bug 3199488, start block
4759: IF (l_state_level >= l_debug_level) THEN
4760: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg108',
4761: 'IGCCREPB -- Standard reval F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4762: END IF;
4763: -- bug 3199488, end block
4764:
4765: l_message := NULL;

Line 4790: -- Output_Debug (' IGCCREPB -- Standard Rollback revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4786:
4787: IF (l_process_flag = 'F')
4788: THEN
4789: -- IF l_debug_mode = 'Y' THEN
4790: -- Output_Debug (' IGCCREPB -- Standard Rollback revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4791: -- END IF;
4792: -- bug 3199488, start block
4793: IF (l_state_level >= l_debug_level) THEN
4794: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg109',

Line 4795: 'IGCCREPB -- Standard Rollback revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4791: -- END IF;
4792: -- bug 3199488, start block
4793: IF (l_state_level >= l_debug_level) THEN
4794: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg109',
4795: 'IGCCREPB -- Standard Rollback revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4796: END IF;
4797: -- bug 3199488, end block
4798: ROLLBACK TO REVALUE6;
4799:

Line 4825: -- Output_Debug (' IGCCREPB -- Standard Commit revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4821: ELSIF (l_process_flag = 'P')
4822: THEN
4823:
4824: -- IF l_debug_mode = 'Y' THEN
4825: -- Output_Debug (' IGCCREPB -- Standard Commit revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4826: -- END IF;
4827: -- bug 3199488, start block
4828: IF (l_state_level >= l_debug_level) THEN
4829: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg110',

Line 4830: 'IGCCREPB -- Standard Commit revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4826: -- END IF;
4827: -- bug 3199488, start block
4828: IF (l_state_level >= l_debug_level) THEN
4829: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg110',
4830: 'IGCCREPB -- Standard Commit revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4831: END IF;
4832: -- bug 3199488, end block
4833: COMMIT;
4834: END IF;

Line 4836: END IF; /* STANDARD */

4832: -- bug 3199488, end block
4833: COMMIT;
4834: END IF;
4835:
4836: END IF; /* STANDARD */
4837: END IF; /* validation_status = P */
4838:
4839: END LOOP;
4840: