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_YEP_PROCESS_PKG dependencies on IGC_CC_HEADERS

Line 38: FROM IGC_CC_HEADERS

34: RETURN VARCHAR2 AS
35:
36: CURSOR C14 IS
37: SELECT *
38: FROM IGC_CC_HEADERS
39: WHERE IGC_CC_HEADERS.CC_HEADER_ID = p_CC_HEADER_ID;
40:
41: CURSOR C15(p_cc_header_id NUMBER, p_yr_start_date DATE, p_yr_end_date DATE) IS
42: SELECT *

Line 39: WHERE IGC_CC_HEADERS.CC_HEADER_ID = p_CC_HEADER_ID;

35:
36: CURSOR C14 IS
37: SELECT *
38: FROM IGC_CC_HEADERS
39: WHERE IGC_CC_HEADERS.CC_HEADER_ID = p_CC_HEADER_ID;
40:
41: CURSOR C15(p_cc_header_id NUMBER, p_yr_start_date DATE, p_yr_end_date DATE) IS
42: SELECT *
43: FROM IGC_CC_ACCT_LINES A

Line 64: l_CC_STATE IGC_CC_HEADERS.CC_STATE%TYPE;

60: l_ACTION_ROWID VARCHAR2(18);
61: l_HEADERS_ROWID VARCHAR2(18);
62: l_DET_PF_LINE_ROWID VARCHAR2(18);
63: l_ACCT_ROWID VARCHAR2(18);
64: l_CC_STATE IGC_CC_HEADERS.CC_STATE%TYPE;
65: l_next_yr_start_date DATE;
66: l_min_period_num gl_periods.period_num%TYPE;
67: V14 C14%ROWTYPE;
68: V15 C15%ROWTYPE;

Line 78: l_CC_VERSION_NUM IGC_CC_HEADERS.CC_VERSION_NUM%TYPE;

74: l_return_status VARCHAR2(1);
75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2(2000);
77: G_FLAG VARCHAR2(1);
78: l_CC_VERSION_NUM IGC_CC_HEADERS.CC_VERSION_NUM%TYPE;
79: l_application_id fnd_application.application_id%TYPE;
80: l_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
81: l_PROVISIONAL_COUNTER NUMBER;
82: l_CC_ACCT_DATE DATE;

Line 80: l_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;

76: l_msg_data VARCHAR2(2000);
77: G_FLAG VARCHAR2(1);
78: l_CC_VERSION_NUM IGC_CC_HEADERS.CC_VERSION_NUM%TYPE;
79: l_application_id fnd_application.application_id%TYPE;
80: l_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
81: l_PROVISIONAL_COUNTER NUMBER;
82: l_CC_ACCT_DATE DATE;
83: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;
84: l_cc_det_pf_encmbrnc_date igc_cc_det_pf.cc_det_pf_encmbrnc_date%TYPE;

Line 90: l_CC_ENCMBRNC_STATUS IGC_CC_HEADERS.CC_ENCMBRNC_STATUS%TYPE;

86: l_Last_Update_Login NUMBER := FND_GLOBAL.LOGIN_ID;
87: l_Created_By NUMBER := FND_GLOBAL.USER_ID;
88: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;
89: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE:= NULL;
90: l_CC_ENCMBRNC_STATUS IGC_CC_HEADERS.CC_ENCMBRNC_STATUS%TYPE;
91:
92: l_func_amt NUMBER;
93: l_func_billed_amt NUMBER;
94: l_unbilled_amt NUMBER;

Line 111: FROM IGC_CC_HEADERS A

107:
108:
109: SELECT CC_STATE,CC_ENCMBRNC_STATUS
110: INTO l_CC_STATE,l_CC_ENCMBRNC_STATUS
111: FROM IGC_CC_HEADERS A
112: WHERE A.CC_HEADER_ID = p_CC_HEADER_ID;
113:
114:
115: SELECT min(gp.period_num)

Line 157: FROM IGC_CC_HEADERS A

153:
154: FETCH C14 INTO V14;
155:
156: SELECT ROWID INTO l_HEADERS_ROWID
157: FROM IGC_CC_HEADERS A
158: WHERE A.CC_HEADER_ID = V14.CC_HEADER_ID;
159:
160: l_CC_VERSION_NUM := V14.CC_VERSION_NUM;
161:

Line 723: FROM IGC_CC_HEADERS A

719: END IF;
720:
721:
722: SELECT ROWID INTO l_HEADERS_ROWID
723: FROM IGC_CC_HEADERS A
724: WHERE A.CC_HEADER_ID = V14.CC_HEADER_ID;
725:
726:
727: IGC_CC_HEADERS_PKG.Update_Row(

Line 727: IGC_CC_HEADERS_PKG.Update_Row(

723: FROM IGC_CC_HEADERS A
724: WHERE A.CC_HEADER_ID = V14.CC_HEADER_ID;
725:
726:
727: IGC_CC_HEADERS_PKG.Update_Row(
728: l_api_version,
729: l_init_msg_list,
730: l_commit,
731: l_validation_level,

Line 942: -- FROM IGC_CC_HEADERS

938: c_ORG_ID NUMBER) IS
939: -- Performance tuning, replaced the following
940: -- query with the one below.
941: -- SELECT *
942: -- FROM IGC_CC_HEADERS
943: -- WHERE CC_HEADER_ID IN
944: -- (
945: -- SELECT IGC_CC_HEADERS.CC_HEADER_ID
946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF

Line 945: -- SELECT IGC_CC_HEADERS.CC_HEADER_ID

941: -- SELECT *
942: -- FROM IGC_CC_HEADERS
943: -- WHERE CC_HEADER_ID IN
944: -- (
945: -- SELECT IGC_CC_HEADERS.CC_HEADER_ID
946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF
947: -- WHERE IGC_CC_DET_PF. CC_ACCT_LINE_ID = IGC_CC_ACCT_LINES. CC_ACCT_LINE_ID
948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID
949: -- AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = c_SOB_ID

Line 946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF

942: -- FROM IGC_CC_HEADERS
943: -- WHERE CC_HEADER_ID IN
944: -- (
945: -- SELECT IGC_CC_HEADERS.CC_HEADER_ID
946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF
947: -- WHERE IGC_CC_DET_PF. CC_ACCT_LINE_ID = IGC_CC_ACCT_LINES. CC_ACCT_LINE_ID
948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID
949: -- AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = c_SOB_ID
950: -- AND IGC_CC_HEADERS.ORG_ID = c_ORG_ID

Line 948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID

944: -- (
945: -- SELECT IGC_CC_HEADERS.CC_HEADER_ID
946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF
947: -- WHERE IGC_CC_DET_PF. CC_ACCT_LINE_ID = IGC_CC_ACCT_LINES. CC_ACCT_LINE_ID
948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID
949: -- AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = c_SOB_ID
950: -- AND IGC_CC_HEADERS.ORG_ID = c_ORG_ID
951: -- AND CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE )
952: --

Line 949: -- AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = c_SOB_ID

945: -- SELECT IGC_CC_HEADERS.CC_HEADER_ID
946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF
947: -- WHERE IGC_CC_DET_PF. CC_ACCT_LINE_ID = IGC_CC_ACCT_LINES. CC_ACCT_LINE_ID
948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID
949: -- AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = c_SOB_ID
950: -- AND IGC_CC_HEADERS.ORG_ID = c_ORG_ID
951: -- AND CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE )
952: --
953: -- AND ( ( CC_STATE = 'PR' )

Line 950: -- AND IGC_CC_HEADERS.ORG_ID = c_ORG_ID

946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF
947: -- WHERE IGC_CC_DET_PF. CC_ACCT_LINE_ID = IGC_CC_ACCT_LINES. CC_ACCT_LINE_ID
948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID
949: -- AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = c_SOB_ID
950: -- AND IGC_CC_HEADERS.ORG_ID = c_ORG_ID
951: -- AND CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE )
952: --
953: -- AND ( ( CC_STATE = 'PR' )
954: -- OR ( CC_STATE = 'CM' )

Line 962: FROM IGC_CC_HEADERS A

958: -- AND ( CC_END_DATE > END_DATE OR CC_END_DATE IS NULL);
959:
960:
961: SELECT *
962: FROM IGC_CC_HEADERS A
963: WHERE (( A.CC_STATE = 'PR' )
964: OR ( A.CC_STATE = 'CM' )
965: OR ( A.CC_STATE = 'CT' AND A.CC_APPRVL_STATUS <> 'AP' )
966: OR ( A.CC_STATE = 'CL' AND A.CC_APPRVL_STATUS <> 'AP' ) )

Line 1057: FROM IGC_CC_HEADERS

1053: */
1054:
1055: CURSOR C11(H_ID NUMBER) IS
1056: SELECT *
1057: FROM IGC_CC_HEADERS
1058: WHERE CC_HEADER_ID IN (SELECT IGC_CC_HEADERS.CC_HEADER_ID
1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA
1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID
1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID

Line 1058: WHERE CC_HEADER_ID IN (SELECT IGC_CC_HEADERS.CC_HEADER_ID

1054:
1055: CURSOR C11(H_ID NUMBER) IS
1056: SELECT *
1057: FROM IGC_CC_HEADERS
1058: WHERE CC_HEADER_ID IN (SELECT IGC_CC_HEADERS.CC_HEADER_ID
1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA
1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID
1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID
1062: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id

Line 1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA

1055: CURSOR C11(H_ID NUMBER) IS
1056: SELECT *
1057: FROM IGC_CC_HEADERS
1058: WHERE CC_HEADER_ID IN (SELECT IGC_CC_HEADERS.CC_HEADER_ID
1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA
1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID
1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID
1062: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1063: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

Line 1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID

1056: SELECT *
1057: FROM IGC_CC_HEADERS
1058: WHERE CC_HEADER_ID IN (SELECT IGC_CC_HEADERS.CC_HEADER_ID
1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA
1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID
1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID
1062: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1063: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
1064: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

Line 1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID

1057: FROM IGC_CC_HEADERS
1058: WHERE CC_HEADER_ID IN (SELECT IGC_CC_HEADERS.CC_HEADER_ID
1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA
1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID
1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID
1062: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1063: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
1064: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
1065: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id);

Line 1086: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;

1082: l_RESULT_OF_RESERVATION IGC_CC_PROCESS_DATA.RESERVATION_STATUS%TYPE;
1083: l_RESULT_OF_YEAR_END_UPDATE IGC_CC_PROCESS_DATA.PROCESSED%TYPE;
1084: l_VALIDATION_COUNTER NUMBER;
1085: l_PROCESSED_COUNTER NUMBER;
1086: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
1087: l_CC_TYPE IGC_CC_HEADERS.CC_TYPE%TYPE;
1088: l_CONTRACT_COUNTER NUMBER := 0;
1089: l_CC_CTRL_STATUS IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE;
1090: l_APPROVED_FLAG PO_HEADERS_ALL.APPROVED_FLAG%TYPE;

Line 1087: l_CC_TYPE IGC_CC_HEADERS.CC_TYPE%TYPE;

1083: l_RESULT_OF_YEAR_END_UPDATE IGC_CC_PROCESS_DATA.PROCESSED%TYPE;
1084: l_VALIDATION_COUNTER NUMBER;
1085: l_PROCESSED_COUNTER NUMBER;
1086: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
1087: l_CC_TYPE IGC_CC_HEADERS.CC_TYPE%TYPE;
1088: l_CONTRACT_COUNTER NUMBER := 0;
1089: l_CC_CTRL_STATUS IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE;
1090: l_APPROVED_FLAG PO_HEADERS_ALL.APPROVED_FLAG%TYPE;
1091: l_HEADER_ID IGC_CC_HEADERS.CC_HEADER_ID%TYPE;

Line 1089: l_CC_CTRL_STATUS IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE;

1085: l_PROCESSED_COUNTER NUMBER;
1086: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
1087: l_CC_TYPE IGC_CC_HEADERS.CC_TYPE%TYPE;
1088: l_CONTRACT_COUNTER NUMBER := 0;
1089: l_CC_CTRL_STATUS IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE;
1090: l_APPROVED_FLAG PO_HEADERS_ALL.APPROVED_FLAG%TYPE;
1091: l_HEADER_ID IGC_CC_HEADERS.CC_HEADER_ID%TYPE;
1092: RELEASE_YEAR_END_COUNTER NUMBER;
1093: l_api_version CONSTANT NUMBER := 1.0;

Line 1091: l_HEADER_ID IGC_CC_HEADERS.CC_HEADER_ID%TYPE;

1087: l_CC_TYPE IGC_CC_HEADERS.CC_TYPE%TYPE;
1088: l_CONTRACT_COUNTER NUMBER := 0;
1089: l_CC_CTRL_STATUS IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE;
1090: l_APPROVED_FLAG PO_HEADERS_ALL.APPROVED_FLAG%TYPE;
1091: l_HEADER_ID IGC_CC_HEADERS.CC_HEADER_ID%TYPE;
1092: RELEASE_YEAR_END_COUNTER NUMBER;
1093: l_api_version CONSTANT NUMBER := 1.0;
1094: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1095: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 1103: l_CC_NUM IGC_CC_HEADERS.CC_NUM%TYPE;

1099: l_msg_data VARCHAR2(12000);
1100: l_usr_msg igc_cc_process_exceptions.exception_reason%TYPE;
1101: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;
1102: l_error_text VARCHAR2(12000);
1103: l_CC_NUM IGC_CC_HEADERS.CC_NUM%TYPE;
1104: l_invalid_counter NUMBER;
1105:
1106: /********************** ENCUMBRANCE DECLARATION *******************/
1107:

Line 1131: l_Type IGC_CC_HEADERS.CC_TYPE%TYPE;

1127: -- l_cc_conf_enc_type_id NUMBER;
1128:
1129: l_COUNTER NUMBER := 0;
1130: l_REQUEST_ID NUMBER;
1131: l_Type IGC_CC_HEADERS.CC_TYPE%TYPE;
1132: l_STATE IGC_CC_HEADERS.CC_STATE%TYPE;
1133: l_PREVIOUS_APPRVL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
1134: l_DUMMY VARCHAR2(1);
1135:

Line 1132: l_STATE IGC_CC_HEADERS.CC_STATE%TYPE;

1128:
1129: l_COUNTER NUMBER := 0;
1130: l_REQUEST_ID NUMBER;
1131: l_Type IGC_CC_HEADERS.CC_TYPE%TYPE;
1132: l_STATE IGC_CC_HEADERS.CC_STATE%TYPE;
1133: l_PREVIOUS_APPRVL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
1134: l_DUMMY VARCHAR2(1);
1135:
1136:

Line 1133: l_PREVIOUS_APPRVL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;

1129: l_COUNTER NUMBER := 0;
1130: l_REQUEST_ID NUMBER;
1131: l_Type IGC_CC_HEADERS.CC_TYPE%TYPE;
1132: l_STATE IGC_CC_HEADERS.CC_STATE%TYPE;
1133: l_PREVIOUS_APPRVL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
1134: l_DUMMY VARCHAR2(1);
1135:
1136:
1137: /******************** END OF ENCUMBRANCE DECLARATION ********************/

Line 1434: /* Fetching Rows from IGC_CC_HEADERS into IGC_CC_PROCESS_DATA depending upon Parameters */

1430:
1431: /******************* END ENCUMBRANCE CODE ************************/
1432:
1433:
1434: /* Fetching Rows from IGC_CC_HEADERS into IGC_CC_PROCESS_DATA depending upon Parameters */
1435:
1436: l_PROCESS_TYPE := 'Y';
1437:
1438: DELETE FROM IGC_CC_PROCESS_DATA A

Line 1646: FROM IGC_CC_HEADERS

1642: EXIT WHEN C2%NOTFOUND;
1643:
1644: SELECT CC_TYPE
1645: INTO l_Type
1646: FROM IGC_CC_HEADERS
1647: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
1648:
1649: IF l_type = 'S' OR l_Type = 'C'
1650: THEN

Line 1695: FROM IGC_CC_HEADERS

1691: EXIT WHEN C2%NOTFOUND;
1692:
1693: SELECT CC_NUM
1694: INTO l_CC_NUM
1695: FROM IGC_CC_HEADERS
1696: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
1697:
1698: l_LOCK_CC_STATUS := IGC_CC_REP_YEP_PVT.LOCK_CC(V2.CC_HEADER_ID);
1699:

Line 1737: FROM IGC_CC_HEADERS

1733:
1734:
1735: SELECT CC_TYPE
1736: INTO l_Type
1737: FROM IGC_CC_HEADERS
1738: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
1739:
1740: IF l_type <> 'C'
1741: THEN

Line 2129: FROM IGC_CC_HEADERS

2125: EXIT WHEN C2%NOTFOUND;
2126:
2127: SELECT CC_TYPE,CC_STATE,CC_APPRVL_STATUS
2128: INTO l_TYPE,l_STATE,l_PREVIOUS_APPRVL_STATUS
2129: FROM IGC_CC_HEADERS
2130: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2131:
2132: IF l_type = 'S' OR l_Type = 'C'
2133: THEN

Line 2160: /* Changing IGC_CC_HEADERS.APPRVL_STATUS => IN PROCESS */

2156: AND A.REQUEST_ID = l_REQUEST_ID1
2157: AND A.PROCESS_TYPE = l_PROCESS_TYPE;
2158:
2159:
2160: /* Changing IGC_CC_HEADERS.APPRVL_STATUS => IN PROCESS */
2161:
2162:
2163: UPDATE IGC_CC_HEADERS
2164: SET CC_APPRVL_STATUS = 'IP'

Line 2163: UPDATE IGC_CC_HEADERS

2159:
2160: /* Changing IGC_CC_HEADERS.APPRVL_STATUS => IN PROCESS */
2161:
2162:
2163: UPDATE IGC_CC_HEADERS
2164: SET CC_APPRVL_STATUS = 'IP'
2165: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V2.CC_HEADER_ID;
2166:
2167: IF l_TYPE = 'S' AND l_STATE = 'CM' AND l_PREVIOUS_APPRVL_STATUS = 'AP'

Line 2165: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V2.CC_HEADER_ID;

2161:
2162:
2163: UPDATE IGC_CC_HEADERS
2164: SET CC_APPRVL_STATUS = 'IP'
2165: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V2.CC_HEADER_ID;
2166:
2167: IF l_TYPE = 'S' AND l_STATE = 'CM' AND l_PREVIOUS_APPRVL_STATUS = 'AP'
2168: THEN
2169:

Line 2176: FROM IGC_CC_HEADERS B,

2172: INTO l_DUMMY
2173: FROM PO_HEADERS_ALL A
2174: WHERE
2175: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
2176: FROM IGC_CC_HEADERS B,
2177: PO_HEADERS_ALL C
2178: WHERE B.ORG_ID = C.ORG_ID AND
2179: B.CC_NUM = C.SEGMENT1 AND
2180: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

Line 2186: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

2182:
2183: UPDATE PO_HEADERS_ALL
2184: SET APPROVED_FLAG = 'N'
2185: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN ( SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2186: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
2187: WHERE a.SEGMENT1 = b.CC_NUM
2188: AND a.ORG_ID = b.ORG_ID
2189: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
2190: AND b.CC_HEADER_ID = V2.CC_HEADER_ID);

Line 2268: FROM IGC_CC_HEADERS

2264: IF l_invalid_counter = 0
2265: THEN
2266: SELECT CC_STATE
2267: INTO l_STATE
2268: FROM IGC_CC_HEADERS
2269: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2270:
2271: /* Reservation_Phase OR Encumberence Check */
2272:

Line 2315: FROM IGC_CC_HEADERS

2311:
2312:
2313: SELECT CC_TYPE
2314: INTO l_CC_TYPE
2315: FROM IGC_CC_HEADERS
2316: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V2.CC_HEADER_ID;
2317:
2318:
2319: /* Perform Year End Processing on Contract Commitment */

Line 2316: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V2.CC_HEADER_ID;

2312:
2313: SELECT CC_TYPE
2314: INTO l_CC_TYPE
2315: FROM IGC_CC_HEADERS
2316: WHERE IGC_CC_HEADERS.CC_HEADER_ID = V2.CC_HEADER_ID;
2317:
2318:
2319: /* Perform Year End Processing on Contract Commitment */
2320:

Line 2351: UPDATE IGC_CC_HEADERS

2347: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2348: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2349: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2350:
2351: UPDATE IGC_CC_HEADERS
2352: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2353: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2354:
2355:

Line 2358: FROM IGC_CC_HEADERS

2354:
2355:
2356: SELECT CC_STATE
2357: INTO l_STATE
2358: FROM IGC_CC_HEADERS
2359: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2360:
2361:
2362: IF l_STATE = 'CM'

Line 2371: FROM IGC_CC_HEADERS B,

2367: INTO l_DUMMY
2368: FROM PO_HEADERS_ALL A
2369: WHERE
2370: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
2371: FROM IGC_CC_HEADERS B,
2372: PO_HEADERS_ALL C
2373: WHERE B.ORG_ID = C.ORG_ID AND
2374: B.CC_NUM = C.SEGMENT1 AND
2375: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

Line 2407: UPDATE IGC_CC_HEADERS

2403: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2404: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2405: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;
2406:
2407: UPDATE IGC_CC_HEADERS
2408: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2409: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2410: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2411: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id

Line 2411: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id

2407: UPDATE IGC_CC_HEADERS
2408: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2409: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2410: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2411: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id
2412: AND IGC_CC_HEADERS.ORG_ID = l_org_id;
2413:
2414: END IF;
2415: END IF;

Line 2412: AND IGC_CC_HEADERS.ORG_ID = l_org_id;

2408: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2409: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2410: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2411: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id
2412: AND IGC_CC_HEADERS.ORG_ID = l_org_id;
2413:
2414: END IF;
2415: END IF;
2416:

Line 2528: UPDATE IGC_CC_HEADERS

2524: LOOP
2525: FETCH C11 INTO V11;
2526: EXIT WHEN C11%NOTFOUND;
2527:
2528: UPDATE IGC_CC_HEADERS
2529: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2530: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2531:
2532: SELECT CC_STATE

Line 2534: FROM IGC_CC_HEADERS

2530: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2531:
2532: SELECT CC_STATE
2533: INTO l_STATE
2534: FROM IGC_CC_HEADERS
2535: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2536:
2537:
2538: IF l_STATE = 'CM'

Line 2548: FROM IGC_CC_HEADERS B,

2544: FROM PO_HEADERS_ALL A
2545: WHERE
2546: A.PO_HEADER_ID =
2547: (SELECT C.PO_HEADER_ID
2548: FROM IGC_CC_HEADERS B,
2549: PO_HEADERS_ALL C
2550: WHERE B.ORG_ID = C.ORG_ID AND
2551: B.CC_NUM = C.SEGMENT1 AND
2552: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

Line 2588: UPDATE IGC_CC_HEADERS

2584: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2585: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2586:
2587:
2588: UPDATE IGC_CC_HEADERS
2589: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2590: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2591: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2592: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id

Line 2592: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id

2588: UPDATE IGC_CC_HEADERS
2589: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2590: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2591: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2592: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id
2593: AND IGC_CC_HEADERS.ORG_ID = l_org_id;
2594:
2595: OPEN C11(V2.CC_HEADER_ID);
2596: LOOP

Line 2593: AND IGC_CC_HEADERS.ORG_ID = l_org_id;

2589: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2590: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2591: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2592: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id
2593: AND IGC_CC_HEADERS.ORG_ID = l_org_id;
2594:
2595: OPEN C11(V2.CC_HEADER_ID);
2596: LOOP
2597:

Line 2618: FROM IGC_CC_HEADERS

2614: ELSE
2615:
2616: SELECT CC_NUM
2617: INTO l_CC_NUM
2618: FROM IGC_CC_HEADERS
2619: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2620:
2621: l_EXCEPTION := NULL;
2622: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_VAL_DUE_TO_ENC_FAIL');

Line 2681: UPDATE IGC_CC_HEADERS

2677:
2678: -- bug 2043221 ssmales - bug found during testing of topic 46 - approval status needs resetting
2679: -- update added below to process this
2680:
2681: UPDATE IGC_CC_HEADERS
2682: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2683: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2684: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2685: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id

Line 2685: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id

2681: UPDATE IGC_CC_HEADERS
2682: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2683: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2684: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2685: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id
2686: AND IGC_CC_HEADERS.ORG_ID = l_org_id ;
2687:
2688: END IF; -- CC has passed validation , Bug 1866713
2689:

Line 2686: AND IGC_CC_HEADERS.ORG_ID = l_org_id ;

2682: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2683: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2684: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2685: AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = l_sob_id
2686: AND IGC_CC_HEADERS.ORG_ID = l_org_id ;
2687:
2688: END IF; -- CC has passed validation , Bug 1866713
2689:
2690: END LOOP; -- C2

Line 2728: /* Reset the Values in IGC_CC_HEADERS AND PO_HEADERS_ALL When all Contracts are processed */

2724: l_REQUEST_ID1);
2725: END IF;
2726: */ -- 1866713 , End
2727:
2728: /* Reset the Values in IGC_CC_HEADERS AND PO_HEADERS_ALL When all Contracts are processed */
2729: l_PROCESSED_COUNTER := 0;
2730:
2731: SELECT COUNT(*)
2732: INTO l_PROCESSED_COUNTER

Line 2753: UPDATE IGC_CC_HEADERS

2749: EXIT WHEN C2%NOTFOUND;
2750:
2751: /* Restoring Original Values to IGC_CC_HAEDERS */
2752:
2753: UPDATE IGC_CC_HEADERS
2754: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2755: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2756:
2757: /* Fetching value for PO_HEADERS_ALL => APPROVED_FLAG from IGC_CC_HEADERS => CC_CTRL_STATUS */

Line 2757: /* Fetching value for PO_HEADERS_ALL => APPROVED_FLAG from IGC_CC_HEADERS => CC_CTRL_STATUS */

2753: UPDATE IGC_CC_HEADERS
2754: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2755: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2756:
2757: /* Fetching value for PO_HEADERS_ALL => APPROVED_FLAG from IGC_CC_HEADERS => CC_CTRL_STATUS */
2758:
2759: SELECT CC_CTRL_STATUS
2760: INTO l_CC_CTRL_STATUS
2761: FROM IGC_CC_HEADERS

Line 2761: FROM IGC_CC_HEADERS

2757: /* Fetching value for PO_HEADERS_ALL => APPROVED_FLAG from IGC_CC_HEADERS => CC_CTRL_STATUS */
2758:
2759: SELECT CC_CTRL_STATUS
2760: INTO l_CC_CTRL_STATUS
2761: FROM IGC_CC_HEADERS
2762: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2763:
2764: IF l_CC_CTRL_STATUS = 'O'
2765: THEN

Line 2775: FROM IGC_CC_HEADERS

2771: /* Restoring Original Values to PO_HEADERS_ALL */
2772:
2773: SELECT CC_TYPE,CC_STATE,CC_APPRVL_STATUS
2774: INTO l_TYPE,l_STATE,l_PREVIOUS_APPRVL_STATUS
2775: FROM IGC_CC_HEADERS
2776: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2777:
2778: IF (l_TYPE = 'S' OR l_TYPE = 'R') AND l_STATE = 'CM' AND l_PREVIOUS_APPRVL_STATUS = 'AP'
2779: THEN

Line 2787: FROM IGC_CC_HEADERS B,

2783: INTO l_DUMMY
2784: FROM PO_HEADERS_ALL A
2785: WHERE
2786: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
2787: FROM IGC_CC_HEADERS B,
2788: PO_HEADERS_ALL C
2789: WHERE B.ORG_ID = C.ORG_ID AND
2790: B.CC_NUM = C.SEGMENT1 AND
2791: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

Line 2797: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

2793:
2794: UPDATE PO_HEADERS_ALL
2795: SET APPROVED_FLAG = l_APPROVED_FLAG
2796: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN ( SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2797: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
2798: WHERE a.SEGMENT1 = b.CC_NUM
2799: AND a.ORG_ID = b.ORG_ID
2800: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
2801: AND b.CC_HEADER_ID = V2.CC_HEADER_ID);