[Home] [Help]
119: ( P_Header_Id OUT NOCOPY NUMBER)
120: IS
121: BEGIN
122: SELECT igc_cc_headers_s.nextval
123: INTO P_Header_Id FROM DUAL;
124: END;
125:
126: /***************************************************************************/
127: -- Get the value for Acct_Line_Id
130: ( P_Acct_Line_Id OUT NOCOPY NUMBER)
131: IS
132: BEGIN
133: SELECT igc_cc_acct_lines_s.nextval
134: INTO P_Acct_Line_Id FROM DUAL;
135: END;
136:
137: /***************************************************************************/
138: -- Get the value for Det_Pf_Line_Id
141: ( P_Det_Pf_Line_Id OUT NOCOPY NUMBER)
142: IS
143: BEGIN
144: SELECT igc_cc_det_pf_s.nextval
145: INTO P_Det_Pf_Line_Id FROM DUAL;
146: END;
147:
148: /***************************************************************************/
149: -- Insert the errors into the error table
1062:
1063: BEGIN
1064:
1065: IF p_cc_apprvl_status = 'AP'
1066: AND ((p_sbc_enable_flag = 'Y' AND p_cbc_enable_flag = 'Y' -- Dual Bdgt Control
1067: AND ((
1068: -- p_cc_conf_encmbrnc_flag = 'Y' Bug No : 6341012. SLA uptake. CC_CONF_ENCUMBRANCE_FLAG no more exists
1069: p_cc_state = 'CM'
1070: AND p_cc_encmbrnc_status = 'C')
1427: GP.adjustment_period_flag = 'N';
1428:
1429: CURSOR c_cur_packet IS
1430: SELECT gl_bc_packets_s.nextval
1431: FROM dual;
1432:
1433: BEGIN
1434:
1435: -- 01/03/02, check to see if CC is installed
1496: -- l_current_set_of_books_id := TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID'));
1497: MO_UTILS.get_ledger_info(l_current_org_id,l_current_set_of_books_id,l_sob_name);
1498:
1499:
1500: -- Get the Dual Budgetary Control Enable Flag
1501: BEGIN
1502: SELECT NVL(cc_bc_enable_flag,'N') INTO l_cbc_enable_flag
1503: FROM igc_cc_bc_enable
1504: WHERE set_of_books_id = l_current_set_of_books_id;