DBA Data[Home] [Help]

APPS.GL_COA_SEG_VAL_IMP_PKG dependencies on FND_GLOBAL

Line 18: g_n_user_id fnd_flex_values.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id

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.

Line 19: g_n_login_id fnd_flex_values.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id

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;

Line 332: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||

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

Line 333: gl_coa_flex_values_rec.allow_budgeting,FND_GLOBAL.newline);

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

Line 338: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.allow_posting;

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:

Line 339: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||

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

Line 340: gl_coa_flex_values_rec.allow_posting,FND_GLOBAL.newline);

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

Line 345: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.account_type;

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:

Line 346: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||

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

Line 347: gl_coa_flex_values_rec.account_type,FND_GLOBAL.newline);

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

Line 352: -- v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.reconcile;

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:

Line 353: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||

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

Line 354: gl_coa_flex_values_rec.reconcile,FND_GLOBAL.newline);

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

Line 359: --v_compiled_value_attribute_s := v_compiled_value_attribute_s||FND_GLOBAL.newline||gl_coa_flex_values_rec.third_party_control_account;

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;

Line 360: v_compiled_value_attribute_s := LTrim(v_compiled_value_attribute_s||FND_GLOBAL.newline||

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:

Line 361: gl_coa_flex_values_rec.third_party_control_account,FND_GLOBAL.newline);

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: