APPS.BIS_AUTOINC_SCHEDULE dependencies on BIS_USER_ATTRIBUTES

Line 78: v_session_value bis_user_attributes.session_value%type;

74: v_rowid_to varchar2(60);
75: v_rowid_from varchar2(60);
76:
77: v_rowid varchar2(60);
78: v_session_value bis_user_attributes.session_value%type;
79: v_session_description bis_user_attributes.session_description%type;
80: v_period_date bis_user_attributes.period_date%type;
81: v_attribute_name bis_user_attributes.attribute_name%type;
82:

Line 79: v_session_description bis_user_attributes.session_description%type;

75: v_rowid_from varchar2(60);
76:
77: v_rowid varchar2(60);
78: v_session_value bis_user_attributes.session_value%type;
79: v_session_description bis_user_attributes.session_description%type;
80: v_period_date bis_user_attributes.period_date%type;
81: v_attribute_name bis_user_attributes.attribute_name%type;
82:
83: v_parameter varchar2(120);

Line 80: v_period_date bis_user_attributes.period_date%type;

76:
77: v_rowid varchar2(60);
78: v_session_value bis_user_attributes.session_value%type;
79: v_session_description bis_user_attributes.session_description%type;
80: v_period_date bis_user_attributes.period_date%type;
81: v_attribute_name bis_user_attributes.attribute_name%type;
82:
83: v_parameter varchar2(120);
84:

Line 81: v_attribute_name bis_user_attributes.attribute_name%type;

77: v_rowid varchar2(60);
78: v_session_value bis_user_attributes.session_value%type;
79: v_session_description bis_user_attributes.session_description%type;
80: v_period_date bis_user_attributes.period_date%type;
81: v_attribute_name bis_user_attributes.attribute_name%type;
82:
83: v_parameter varchar2(120);
84:
85: v_org_param varchar2(80);

Line 94: from bis_user_attributes

90:
91:
92: cursor cStoredTimeParms(pScheduleId varchar2) is
93: select rowid, session_value, session_description, period_date, attribute_name
94: from bis_user_attributes
95: where dimension in('TIME','EDW_TIME_M')
96: and schedule_id = pScheduleId;
97:
98:

Line 101: from bis_user_attributes

97:
98:
99: cursor cStoredOrgParms(pScheduleId varchar2) is
100: select attribute_name, session_description
101: from bis_user_attributes
102: where dimension in('ORGANIZATION','EDW_ORGANIZATION_M')
103: and schedule_id = pScheduleId;
104:
105:

Line 213: update bis_user_attributes set

209: if(v_start_date_lov_from is not null) and (v_end_date_lov_to is not null)
210: and(v_to_flag = 'Y' and v_from_flag = 'Y') then
211:
212: -- 'from' record:
213: update bis_user_attributes set
214: session_value = v_dimn_level_id_from,
215: session_description = v_dimn_level_value_from,
216: period_date = v_start_date_lov_from
217: where rowid = v_rowid_from;

Line 220: update bis_user_attributes set

216: period_date = v_start_date_lov_from
217: where rowid = v_rowid_from;
218:
219: -- 'to' record:
220: update bis_user_attributes set
221: session_value = v_dimn_level_id_to,
222: session_description = v_dimn_level_value_to,
223: period_date = v_end_date_lov_to
224: where rowid = v_rowid_to;

Line 227: update bis_user_attributes set

223: period_date = v_end_date_lov_to
224: where rowid = v_rowid_to;
225:
226: -- BugFix 3006638 'as of date'
227: update bis_user_attributes set
228: --session_value = to_char(v_sys_date, 'DD-MON-RRRR'),
229: --session_description = to_char(v_sys_date, 'DD-MON-RRRR'),
230: --As of Date 3094234--dd/mm/rrrr format
231: session_value = to_char(v_sys_date, 'DD/MM/RRRR'),