APPS.CSM_MOBILE_QUERY_PKG dependencies on FND_GLOBAL

Line 199: fnd_global.login_id, 'N' );

195: p_QUERY_OUTPUT_FORMAT, p_MIME_TYPE, p_WORK_FLOW,
196: p_RETENTION_POLICY, p_RETENTION_DAYS, p_TEMPLATE,
197: p_TEMPLATE_FILE, p_EXECUTION_MODE, sysdate,
198: p_LEVEL_VALUE, sysdate, p_LEVEL_VALUE,
199: fnd_global.login_id, 'N' );
200:
201: --Insert the QUERY DESCRIPTION into the TL table
202: INSERT INTO CSM_QUERY_TL ( QUERY_ID, DESCRIPTION, LANGUAGE,
203: CREATION_DATE, CREATED_BY,

Line 207: sysdate, p_LEVEL_VALUE, fnd_global.login_id);

203: CREATION_DATE, CREATED_BY,
204: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN )
205: VALUES ( l_query_id, P_QUERY_DESC, l_language,
206: sysdate, p_LEVEL_VALUE,
207: sysdate, p_LEVEL_VALUE, fnd_global.login_id);
208:
209: IF l_qry_with_no_var = 'N' THEN --Proces only if the query has variables
210: l_variable_count := p_VARIABLE_NAME.COUNT;
211:

Line 223: fnd_global.login_id );

219: VALUES ( l_query_id, i, p_VARIABLE_NAME(i),
220: p_VARIABLE_TYPE(i), p_VARIABLE_VALUE_CHAR(i), p_VARIABLE_VALUE_DATE(i),
221: NVL(p_HIDDEN_FLAG(i),'N'), NVL(p_DEFAULT_FLAG(i),'N'), sysdate,
222: p_LEVEL_VALUE, sysdate, p_LEVEL_VALUE,
223: fnd_global.login_id );
224:
225: END LOOP;
226: END IF;
227:

Line 471: LAST_UPDATED_BY = fnd_global.user_id,

467: --Update the Query Definition in the base table
468: UPDATE CSM_QUERY_B
469: SET DELETE_FLAG = 'Y',
470: LAST_UPDATE_DATE = sysdate,
471: LAST_UPDATED_BY = fnd_global.user_id,
472: LAST_UPDATE_LOGIN = fnd_global.login_id
473: WHERE QUERY_ID = l_QUERY_ID;
474:
475: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_DELETE for Query ID : ' || p_record.QUERY_ID ,

Line 472: LAST_UPDATE_LOGIN = fnd_global.login_id

468: UPDATE CSM_QUERY_B
469: SET DELETE_FLAG = 'Y',
470: LAST_UPDATE_DATE = sysdate,
471: LAST_UPDATED_BY = fnd_global.user_id,
472: LAST_UPDATE_LOGIN = fnd_global.login_id
473: WHERE QUERY_ID = l_QUERY_ID;
474:
475: CSM_UTIL_PKG.LOG('Leaving CSM_MOBILE_QUERY_PKG.APPLY_DELETE for Query ID : ' || p_record.QUERY_ID ,
476: 'CSM_MOBILE_QUERY_PKG.APPLY_DELETE',FND_LOG.LEVEL_PROCEDURE);