[Home] [Help]
462: IF (p_plan_element_old.liability_account_id <> p_plan_element_new.liability_account_id) THEN
463: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_LIA_UPDATE');
464: SELECT
465: DECODE(LA.CODE_COMBINATION_ID,NULL,NULL, LA.SEGMENT1||'-'||LA.SEGMENT2||'-'||LA.SEGMENT3||'-'||LA.SEGMENT4 ||'-'||LA.SEGMENT5)
466: INTO l_temp_old FROM GL_CODE_COMBINATIONS LA
467: WHERE LA.CODE_COMBINATION_ID = p_plan_element_old.liability_account_id;
468: SELECT
469: DECODE(LA.CODE_COMBINATION_ID,NULL,NULL, LA.SEGMENT1||'-'||LA.SEGMENT2||'-'||LA.SEGMENT3||'-'||LA.SEGMENT4 ||'-'||LA.SEGMENT5)
470: INTO l_temp_new FROM GL_CODE_COMBINATIONS LA
466: INTO l_temp_old FROM GL_CODE_COMBINATIONS LA
467: WHERE LA.CODE_COMBINATION_ID = p_plan_element_old.liability_account_id;
468: SELECT
469: DECODE(LA.CODE_COMBINATION_ID,NULL,NULL, LA.SEGMENT1||'-'||LA.SEGMENT2||'-'||LA.SEGMENT3||'-'||LA.SEGMENT4 ||'-'||LA.SEGMENT5)
470: INTO l_temp_new FROM GL_CODE_COMBINATIONS LA
471: WHERE LA.CODE_COMBINATION_ID = p_plan_element_new.liability_account_id;
472: fnd_message.set_token('PE_OLD_LIA', l_temp_old);
473: fnd_message.set_token('PE_NEW_LIA', l_temp_new);
474: l_plan_element_id := p_plan_element_new.quota_id;
492: IF (p_plan_element_old.expense_account_id <> p_plan_element_new.expense_account_id) THEN
493: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_EXP_UPDATE');
494: SELECT
495: DECODE(LA.CODE_COMBINATION_ID,NULL,NULL, LA.SEGMENT1||'-'||LA.SEGMENT2||'-'||LA.SEGMENT3||'-'||LA.SEGMENT4 ||'-'||LA.SEGMENT5)
496: INTO l_temp_old FROM GL_CODE_COMBINATIONS LA
497: WHERE LA.CODE_COMBINATION_ID = p_plan_element_old.expense_account_id;
498: SELECT
499: DECODE(LA.CODE_COMBINATION_ID,NULL,NULL, LA.SEGMENT1||'-'||LA.SEGMENT2||'-'||LA.SEGMENT3||'-'||LA.SEGMENT4 ||'-'||LA.SEGMENT5)
500: INTO l_temp_new FROM GL_CODE_COMBINATIONS LA
496: INTO l_temp_old FROM GL_CODE_COMBINATIONS LA
497: WHERE LA.CODE_COMBINATION_ID = p_plan_element_old.expense_account_id;
498: SELECT
499: DECODE(LA.CODE_COMBINATION_ID,NULL,NULL, LA.SEGMENT1||'-'||LA.SEGMENT2||'-'||LA.SEGMENT3||'-'||LA.SEGMENT4 ||'-'||LA.SEGMENT5)
500: INTO l_temp_new FROM GL_CODE_COMBINATIONS LA
501: WHERE LA.CODE_COMBINATION_ID = p_plan_element_new.expense_account_id;
502: fnd_message.set_token('PE_EXP_OLD', l_temp_old);
503: fnd_message.set_token('PE_EXP_NEW', l_temp_new);
504: l_plan_element_id := p_plan_element_new.quota_id;
1143: where_stmt VARCHAR2 (2000);
1144: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
1145: ccid NUMBER;
1146: ccid_value VARCHAR2 (2000);
1147: l_account_type gl_code_combinations.account_type%TYPE;
1148:
1149: TYPE curtype IS REF CURSOR;
1150:
1151: ccid_cur curtype;
1181: END LOOP;
1182:
1183: sql_stmt :=
1184: sql_stmt
1185: || ' FROM gl_code_combinations '
1186: ||
1187: -- Modified By Hithanki for Bug Fix : 2938387 05-May-2003
1188: -- ' WHERE chart_of_accounts_id = '||l_chart_of_accounts_id||
1189: ' WHERE chart_of_accounts_id = :1 '
1245: END LOOP;
1246:
1247: sql_stmt :=
1248: sql_stmt
1249: || ' FROM gl_code_combinations '
1250: ||
1251: -- Modified By Hithanki for Bug Fix : 2938387 05-May-2003
1252: -- ' WHERE chart_of_accounts_id = '||l_chart_of_accounts_id||
1253: ' WHERE chart_of_accounts_id = :1 '
1293: ELSE
1294: BEGIN
1295: SELECT code_combination_id
1296: INTO l_id
1297: FROM gl_code_combinations
1298: WHERE code_combination_id = p_plan_element.liability_account_id AND account_type = 'L';
1299: EXCEPTION
1300: WHEN NO_DATA_FOUND
1301: THEN
1321: ELSE
1322: BEGIN
1323: SELECT code_combination_id
1324: INTO l_id
1325: FROM gl_code_combinations
1326: WHERE code_combination_id = p_plan_element.expense_account_id AND account_type = 'E';
1327: EXCEPTION
1328: WHEN NO_DATA_FOUND
1329: THEN