18: pv_progress VARCHAR2(100);
19: pv_crlf CONSTANT VARCHAR2(1) := '
20: ';
21:
22: pv_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
23: pv_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
24:
25: pv_dim_id NUMBER;
26: pv_dim_vs_id NUMBER;
19: pv_crlf CONSTANT VARCHAR2(1) := '
20: ';
21:
22: pv_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
23: pv_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
24:
25: pv_dim_id NUMBER;
26: pv_dim_vs_id NUMBER;
27:
60: A.ATTRIBUTE_VARCHAR_LABEL,
61: 'EXTENDED_ACCOUNT_TYPE',
62: DECODE(
63: SUBSTR(
64: FND_GLOBAL.NEWLINE ||
65: V.COMPILED_VALUE_ATTRIBUTES ||
66: FND_GLOBAL.NEWLINE,
67: INSTR(
68: FND_GLOBAL.NEWLINE ||
62: DECODE(
63: SUBSTR(
64: FND_GLOBAL.NEWLINE ||
65: V.COMPILED_VALUE_ATTRIBUTES ||
66: FND_GLOBAL.NEWLINE,
67: INSTR(
68: FND_GLOBAL.NEWLINE ||
69: V.COMPILED_VALUE_ATTRIBUTES ||
70: FND_GLOBAL.NEWLINE,
64: FND_GLOBAL.NEWLINE ||
65: V.COMPILED_VALUE_ATTRIBUTES ||
66: FND_GLOBAL.NEWLINE,
67: INSTR(
68: FND_GLOBAL.NEWLINE ||
69: V.COMPILED_VALUE_ATTRIBUTES ||
70: FND_GLOBAL.NEWLINE,
71: FND_GLOBAL.NEWLINE,
72: 1, :v_account_type_pos
66: FND_GLOBAL.NEWLINE,
67: INSTR(
68: FND_GLOBAL.NEWLINE ||
69: V.COMPILED_VALUE_ATTRIBUTES ||
70: FND_GLOBAL.NEWLINE,
71: FND_GLOBAL.NEWLINE,
72: 1, :v_account_type_pos
73: )+1,
74: 1
67: INSTR(
68: FND_GLOBAL.NEWLINE ||
69: V.COMPILED_VALUE_ATTRIBUTES ||
70: FND_GLOBAL.NEWLINE,
71: FND_GLOBAL.NEWLINE,
72: 1, :v_account_type_pos
73: )+1,
74: 1
75: ),
80: 'O', 'EQUITY'
81: ),
82: 'BUDGET_ALLOWED_FLAG',
83: SUBSTR(
84: FND_GLOBAL.NEWLINE ||
85: V.COMPILED_VALUE_ATTRIBUTES ||
86: FND_GLOBAL.NEWLINE,
87: INSTR(
88: FND_GLOBAL.NEWLINE ||
82: 'BUDGET_ALLOWED_FLAG',
83: SUBSTR(
84: FND_GLOBAL.NEWLINE ||
85: V.COMPILED_VALUE_ATTRIBUTES ||
86: FND_GLOBAL.NEWLINE,
87: INSTR(
88: FND_GLOBAL.NEWLINE ||
89: V.COMPILED_VALUE_ATTRIBUTES ||
90: FND_GLOBAL.NEWLINE,
84: FND_GLOBAL.NEWLINE ||
85: V.COMPILED_VALUE_ATTRIBUTES ||
86: FND_GLOBAL.NEWLINE,
87: INSTR(
88: FND_GLOBAL.NEWLINE ||
89: V.COMPILED_VALUE_ATTRIBUTES ||
90: FND_GLOBAL.NEWLINE,
91: FND_GLOBAL.NEWLINE,
92: 1, :v_budget_pos
86: FND_GLOBAL.NEWLINE,
87: INSTR(
88: FND_GLOBAL.NEWLINE ||
89: V.COMPILED_VALUE_ATTRIBUTES ||
90: FND_GLOBAL.NEWLINE,
91: FND_GLOBAL.NEWLINE,
92: 1, :v_budget_pos
93: )+1,
94: 1
87: INSTR(
88: FND_GLOBAL.NEWLINE ||
89: V.COMPILED_VALUE_ATTRIBUTES ||
90: FND_GLOBAL.NEWLINE,
91: FND_GLOBAL.NEWLINE,
92: 1, :v_budget_pos
93: )+1,
94: 1
95: ),
692: A.ATTRIBUTE_VARCHAR_LABEL,
693: ''EXTENDED_ACCOUNT_TYPE'',
694: DECODE(
695: SUBSTR(
696: FND_GLOBAL.NEWLINE ||
697: V.COMPILED_VALUE_ATTRIBUTES ||
698: FND_GLOBAL.NEWLINE,
699: INSTR(
700: FND_GLOBAL.NEWLINE ||
694: DECODE(
695: SUBSTR(
696: FND_GLOBAL.NEWLINE ||
697: V.COMPILED_VALUE_ATTRIBUTES ||
698: FND_GLOBAL.NEWLINE,
699: INSTR(
700: FND_GLOBAL.NEWLINE ||
701: V.COMPILED_VALUE_ATTRIBUTES ||
702: FND_GLOBAL.NEWLINE,
696: FND_GLOBAL.NEWLINE ||
697: V.COMPILED_VALUE_ATTRIBUTES ||
698: FND_GLOBAL.NEWLINE,
699: INSTR(
700: FND_GLOBAL.NEWLINE ||
701: V.COMPILED_VALUE_ATTRIBUTES ||
702: FND_GLOBAL.NEWLINE,
703: FND_GLOBAL.NEWLINE,
704: 1, :v_account_type_pos
698: FND_GLOBAL.NEWLINE,
699: INSTR(
700: FND_GLOBAL.NEWLINE ||
701: V.COMPILED_VALUE_ATTRIBUTES ||
702: FND_GLOBAL.NEWLINE,
703: FND_GLOBAL.NEWLINE,
704: 1, :v_account_type_pos
705: )+1,
706: 1
699: INSTR(
700: FND_GLOBAL.NEWLINE ||
701: V.COMPILED_VALUE_ATTRIBUTES ||
702: FND_GLOBAL.NEWLINE,
703: FND_GLOBAL.NEWLINE,
704: 1, :v_account_type_pos
705: )+1,
706: 1
707: ),
714:
715: v_dim_attr_varchar_member2 :=
716: ' ''BUDGET_ALLOWED_FLAG'',
717: SUBSTR(
718: FND_GLOBAL.NEWLINE ||
719: V.COMPILED_VALUE_ATTRIBUTES ||
720: FND_GLOBAL.NEWLINE,
721: INSTR(
722: FND_GLOBAL.NEWLINE ||
716: ' ''BUDGET_ALLOWED_FLAG'',
717: SUBSTR(
718: FND_GLOBAL.NEWLINE ||
719: V.COMPILED_VALUE_ATTRIBUTES ||
720: FND_GLOBAL.NEWLINE,
721: INSTR(
722: FND_GLOBAL.NEWLINE ||
723: V.COMPILED_VALUE_ATTRIBUTES ||
724: FND_GLOBAL.NEWLINE,
718: FND_GLOBAL.NEWLINE ||
719: V.COMPILED_VALUE_ATTRIBUTES ||
720: FND_GLOBAL.NEWLINE,
721: INSTR(
722: FND_GLOBAL.NEWLINE ||
723: V.COMPILED_VALUE_ATTRIBUTES ||
724: FND_GLOBAL.NEWLINE,
725: FND_GLOBAL.NEWLINE,
726: 1, :v_budget_pos
720: FND_GLOBAL.NEWLINE,
721: INSTR(
722: FND_GLOBAL.NEWLINE ||
723: V.COMPILED_VALUE_ATTRIBUTES ||
724: FND_GLOBAL.NEWLINE,
725: FND_GLOBAL.NEWLINE,
726: 1, :v_budget_pos
727: )+1,
728: 1
721: INSTR(
722: FND_GLOBAL.NEWLINE ||
723: V.COMPILED_VALUE_ATTRIBUTES ||
724: FND_GLOBAL.NEWLINE,
725: FND_GLOBAL.NEWLINE,
726: 1, :v_budget_pos
727: )+1,
728: 1
729: ),
760: A.ATTRIBUTE_VARCHAR_LABEL,
761: ''EXTENDED_ACCOUNT_TYPE'',
762: DECODE(
763: SUBSTR(
764: FND_GLOBAL.NEWLINE ||
765: V.COMPILED_VALUE_ATTRIBUTES ||
766: FND_GLOBAL.NEWLINE,
767: INSTR(
768: FND_GLOBAL.NEWLINE ||
762: DECODE(
763: SUBSTR(
764: FND_GLOBAL.NEWLINE ||
765: V.COMPILED_VALUE_ATTRIBUTES ||
766: FND_GLOBAL.NEWLINE,
767: INSTR(
768: FND_GLOBAL.NEWLINE ||
769: V.COMPILED_VALUE_ATTRIBUTES ||
770: FND_GLOBAL.NEWLINE,
764: FND_GLOBAL.NEWLINE ||
765: V.COMPILED_VALUE_ATTRIBUTES ||
766: FND_GLOBAL.NEWLINE,
767: INSTR(
768: FND_GLOBAL.NEWLINE ||
769: V.COMPILED_VALUE_ATTRIBUTES ||
770: FND_GLOBAL.NEWLINE,
771: FND_GLOBAL.NEWLINE,
772: 1, :v_account_type_pos
766: FND_GLOBAL.NEWLINE,
767: INSTR(
768: FND_GLOBAL.NEWLINE ||
769: V.COMPILED_VALUE_ATTRIBUTES ||
770: FND_GLOBAL.NEWLINE,
771: FND_GLOBAL.NEWLINE,
772: 1, :v_account_type_pos
773: )+1,
774: 1
767: INSTR(
768: FND_GLOBAL.NEWLINE ||
769: V.COMPILED_VALUE_ATTRIBUTES ||
770: FND_GLOBAL.NEWLINE,
771: FND_GLOBAL.NEWLINE,
772: 1, :v_account_type_pos
773: )+1,
774: 1
775: ),