APPS.IGC_CC_REVAL_FIX_PROCESS_PKG dependencies on STANDARD

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

1698: a.cc_header_id = b.cc_header_id AND
1699: b.cc_type = 'C';
1700:
1701:
1702: /* Fetch the cover-standard data from temporary table */
1703: CURSOR c_reval_data(p_request_id NUMBER)
1704: IS
1705: SELECT a.cc_header_id
1706: FROM igc_cc_process_data a ,

Line 2180: /* Begin Standard Revaluation */

2176: INTO l_cc_headers_rec;
2177:
2178: EXIT WHEN c_revalue_process_cc%NOTFOUND;
2179:
2180: /* Begin Standard Revaluation */
2181: IF (l_cc_headers_rec.cc_type = 'S')
2182: THEN
2183: INSERT INTO igc_cc_process_data
2184: (

Line 2213: /* End Standard Revaluation */

2209:
2210: COMMIT;
2211:
2212: END IF;
2213: /* End Standard Revaluation */
2214:
2215: /* Begin release Revaluation */
2216:
2217: IF (l_cc_headers_rec.cc_type = 'R')

Line 2387: /* Standard */

2383: WHERE cc_header_id = l_cc_header_id;
2384:
2385: l_lock_cc_po := TRUE;
2386:
2387: /* Standard */
2388: IF (l_cc_headers_rec.cc_type = 'S')
2389: THEN
2390: /* Bug No : 6341012. R12 Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id */
2391: l_lock_cc_po := lock_cc_po(l_sob_id,l_org_id,l_cc_header_id, l_request_id1);

Line 2765: type_lookup_code = 'STANDARD' ;

2761: INTO l_po_count
2762: FROM po_headers_all
2763: WHERE segment1 = l_cc_headers_rec.cc_num AND
2764: org_id = l_cc_headers_rec.org_id AND
2765: type_lookup_code = 'STANDARD' ;
2766: EXCEPTION
2767: WHEN NO_DATA_FOUND
2768: THEN
2769: l_po_count := 0;

Line 2780: type_lookup_code = 'STANDARD' AND

2776: UPDATE po_headers_all
2777: SET approved_flag = 'N'
2778: WHERE segment1 = l_cc_headers_rec.cc_num AND
2779: org_id = l_cc_headers_rec.org_id AND
2780: type_lookup_code = 'STANDARD' AND
2781: approved_flag = 'Y';
2782: END;
2783: END IF;
2784:

Line 2816: type_lookup_code = 'STANDARD' ;

2812: INTO l_po_count
2813: FROM po_headers_all
2814: WHERE segment1 = l_rel_cc_headers_rec.cc_num AND
2815: org_id = l_rel_cc_headers_rec.org_id AND
2816: type_lookup_code = 'STANDARD' ;
2817: EXCEPTION
2818: WHEN NO_DATA_FOUND
2819: THEN
2820: l_po_count := 0;

Line 2831: type_lookup_code = 'STANDARD' AND

2827: UPDATE po_headers_all
2828: SET approved_flag = 'N'
2829: WHERE segment1 = l_rel_cc_headers_rec.cc_num AND
2830: org_id = l_rel_cc_headers_rec.org_id AND
2831: type_lookup_code = 'STANDARD' AND
2832: /* Changed statement below from approved_flag = N to approved_flag = Y to fix bug 1632984 */
2833: approved_flag = 'Y';
2834: END;
2835: END IF;

Line 3384: END IF; /* cc_type = STANDARD */

3380: THEN
3381: COMMIT;
3382: END IF;
3383:
3384: END IF; /* cc_type = STANDARD */
3385: END IF; /* validation_status = P */
3386:
3387: END IF; /* Final Phase */
3388: /* End Reservation Phase */