14: Change History (in reverse chronological order)
15: Who When What
16: ********************************************************************************************** */
17:
18: g_n_user_id fnd_flex_values.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
19: g_n_login_id fnd_flex_values.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
20: g_n_sysdate DATE := SYSDATE;
21:
22: --PL/SQL table to store the unique flex value set ids.
15: Who When What
16: ********************************************************************************************** */
17:
18: g_n_user_id fnd_flex_values.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
19: g_n_login_id fnd_flex_values.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
20: g_n_sysdate DATE := SYSDATE;
21:
22: --PL/SQL table to store the unique flex value set ids.
23: TYPE flex_vl_set_id_tbl_type IS TABLE OF fnd_flex_values.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER;
328: LOOP
329: IF rec_c_flex_val_qual.value_attribute_type = 'DETAIL_BUDGETING_ALLOWED' AND gl_coa_flex_values_rec.allow_budgeting IS NOT NULL THEN
330: -- DRM: Changed
331: -- v_compiled_value_attribute_s := gl_coa_flex_values_rec.allow_budgeting;
332: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
333: gl_coa_flex_values_rec.allow_budgeting,FND_GLOBAL.newline);
334: END IF;
335:
336: IF rec_c_flex_val_qual.value_attribute_type = 'DETAIL_POSTING_ALLOWED' AND gl_coa_flex_values_rec.allow_posting IS NOT NULL THEN
329: IF rec_c_flex_val_qual.value_attribute_type = 'DETAIL_BUDGETING_ALLOWED' AND gl_coa_flex_values_rec.allow_budgeting IS NOT NULL THEN
330: -- DRM: Changed
331: -- v_compiled_value_attribute_s := gl_coa_flex_values_rec.allow_budgeting;
332: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
333: gl_coa_flex_values_rec.allow_budgeting,FND_GLOBAL.newline);
334: END IF;
335:
336: IF rec_c_flex_val_qual.value_attribute_type = 'DETAIL_POSTING_ALLOWED' AND gl_coa_flex_values_rec.allow_posting IS NOT NULL THEN
337: -- DRM: Changed
334: END IF;
335:
336: IF rec_c_flex_val_qual.value_attribute_type = 'DETAIL_POSTING_ALLOWED' AND gl_coa_flex_values_rec.allow_posting IS NOT NULL THEN
337: -- DRM: Changed
338: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.allow_posting;
339: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
340: gl_coa_flex_values_rec.allow_posting,FND_GLOBAL.newline);
341: END IF;
342:
335:
336: IF rec_c_flex_val_qual.value_attribute_type = 'DETAIL_POSTING_ALLOWED' AND gl_coa_flex_values_rec.allow_posting IS NOT NULL THEN
337: -- DRM: Changed
338: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.allow_posting;
339: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
340: gl_coa_flex_values_rec.allow_posting,FND_GLOBAL.newline);
341: END IF;
342:
343: IF rec_c_flex_val_qual.value_attribute_type = 'GL_ACCOUNT_TYPE' AND gl_coa_flex_values_rec.account_type IS NOT NULL THEN
336: IF rec_c_flex_val_qual.value_attribute_type = 'DETAIL_POSTING_ALLOWED' AND gl_coa_flex_values_rec.allow_posting IS NOT NULL THEN
337: -- DRM: Changed
338: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.allow_posting;
339: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
340: gl_coa_flex_values_rec.allow_posting,FND_GLOBAL.newline);
341: END IF;
342:
343: IF rec_c_flex_val_qual.value_attribute_type = 'GL_ACCOUNT_TYPE' AND gl_coa_flex_values_rec.account_type IS NOT NULL THEN
344: -- DRM: Changed
341: END IF;
342:
343: IF rec_c_flex_val_qual.value_attribute_type = 'GL_ACCOUNT_TYPE' AND gl_coa_flex_values_rec.account_type IS NOT NULL THEN
344: -- DRM: Changed
345: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.account_type;
346: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
347: gl_coa_flex_values_rec.account_type,FND_GLOBAL.newline);
348: END IF;
349:
342:
343: IF rec_c_flex_val_qual.value_attribute_type = 'GL_ACCOUNT_TYPE' AND gl_coa_flex_values_rec.account_type IS NOT NULL THEN
344: -- DRM: Changed
345: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.account_type;
346: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
347: gl_coa_flex_values_rec.account_type,FND_GLOBAL.newline);
348: END IF;
349:
350: IF rec_c_flex_val_qual.value_attribute_type = 'RECONCILIATION FLAG' AND gl_coa_flex_values_rec.reconcile IS NOT NULL THEN
343: IF rec_c_flex_val_qual.value_attribute_type = 'GL_ACCOUNT_TYPE' AND gl_coa_flex_values_rec.account_type IS NOT NULL THEN
344: -- DRM: Changed
345: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.account_type;
346: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
347: gl_coa_flex_values_rec.account_type,FND_GLOBAL.newline);
348: END IF;
349:
350: IF rec_c_flex_val_qual.value_attribute_type = 'RECONCILIATION FLAG' AND gl_coa_flex_values_rec.reconcile IS NOT NULL THEN
351: -- DRM: Changed
348: END IF;
349:
350: IF rec_c_flex_val_qual.value_attribute_type = 'RECONCILIATION FLAG' AND gl_coa_flex_values_rec.reconcile IS NOT NULL THEN
351: -- DRM: Changed
352: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.reconcile;
353: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
354: gl_coa_flex_values_rec.reconcile,FND_GLOBAL.newline);
355: END IF;
356:
349:
350: IF rec_c_flex_val_qual.value_attribute_type = 'RECONCILIATION FLAG' AND gl_coa_flex_values_rec.reconcile IS NOT NULL THEN
351: -- DRM: Changed
352: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.reconcile;
353: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
354: gl_coa_flex_values_rec.reconcile,FND_GLOBAL.newline);
355: END IF;
356:
357: IF rec_c_flex_val_qual.value_attribute_type = 'GL_CONTROL_ACCOUNT' AND gl_coa_flex_values_rec.third_party_control_account IS NOT NULL THEN
350: IF rec_c_flex_val_qual.value_attribute_type = 'RECONCILIATION FLAG' AND gl_coa_flex_values_rec.reconcile IS NOT NULL THEN
351: -- DRM: Changed
352: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.reconcile;
353: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
354: gl_coa_flex_values_rec.reconcile,FND_GLOBAL.newline);
355: END IF;
356:
357: IF rec_c_flex_val_qual.value_attribute_type = 'GL_CONTROL_ACCOUNT' AND gl_coa_flex_values_rec.third_party_control_account IS NOT NULL THEN
358: -- DRM: Changed
355: END IF;
356:
357: IF rec_c_flex_val_qual.value_attribute_type = 'GL_CONTROL_ACCOUNT' AND gl_coa_flex_values_rec.third_party_control_account IS NOT NULL THEN
358: -- DRM: Changed
359: --v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.third_party_control_account;
360: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
361: gl_coa_flex_values_rec.third_party_control_account,FND_GLOBAL.newline);
362: END IF;
363: END LOOP;
356:
357: IF rec_c_flex_val_qual.value_attribute_type = 'GL_CONTROL_ACCOUNT' AND gl_coa_flex_values_rec.third_party_control_account IS NOT NULL THEN
358: -- DRM: Changed
359: --v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.third_party_control_account;
360: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
361: gl_coa_flex_values_rec.third_party_control_account,FND_GLOBAL.newline);
362: END IF;
363: END LOOP;
364:
357: IF rec_c_flex_val_qual.value_attribute_type = 'GL_CONTROL_ACCOUNT' AND gl_coa_flex_values_rec.third_party_control_account IS NOT NULL THEN
358: -- DRM: Changed
359: --v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.third_party_control_account;
360: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||
361: gl_coa_flex_values_rec.third_party_control_account,FND_GLOBAL.newline);
362: END IF;
363: END LOOP;
364:
365: