DBA Data[Home] [Help]

APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on FND_GLOBAL

Line 22: pv_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;

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;

Line 23: pv_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;

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:

Line 64: FND_GLOBAL.NEWLINE ||

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 ||

Line 66: 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,

Line 68: 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

Line 70: FND_GLOBAL.NEWLINE,

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

Line 71: 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
75: ),

Line 84: FND_GLOBAL.NEWLINE ||

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 ||

Line 86: 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,

Line 88: 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

Line 90: FND_GLOBAL.NEWLINE,

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

Line 91: 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
95: ),

Line 696: FND_GLOBAL.NEWLINE ||

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 ||

Line 698: 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,

Line 700: 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

Line 702: FND_GLOBAL.NEWLINE,

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

Line 703: 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
707: ),

Line 718: FND_GLOBAL.NEWLINE ||

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 ||

Line 720: 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,

Line 722: 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

Line 724: FND_GLOBAL.NEWLINE,

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

Line 725: 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
729: ),

Line 764: FND_GLOBAL.NEWLINE ||

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 ||

Line 766: 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,

Line 768: 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

Line 770: FND_GLOBAL.NEWLINE,

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

Line 771: 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
775: ),