eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_QUERY_PKG dependencies on FND_GLOBAL

Line 255: fnd_global.user_id, sysdate, fnd_global.user_id,

251: p_LEVEL_VALUE, p_PARENT_QUERY_ID, p_SAVED_QUERY,
252: p_QUERY_OUTPUT_FORMAT, p_MIME_TYPE, p_WORK_FLOW,
253: p_RETENTION_POLICY, p_RETENTION_DAYS, p_TEMPLATE,
254: p_TEMPLATE_FILE, p_EXECUTION_MODE, sysdate,
255: fnd_global.user_id, sysdate, fnd_global.user_id,
256: fnd_global.login_id, 'N', p_PROCEDURE,
257: p_EMAIL_ENABLED, p_RESTRICTED_FLAG, p_DISABLED_FLAG);
258:
259: --Insert the QUERY DESCRIPTION into the TL table

Line 256: fnd_global.login_id, 'N', p_PROCEDURE,

252: p_QUERY_OUTPUT_FORMAT, p_MIME_TYPE, p_WORK_FLOW,
253: p_RETENTION_POLICY, p_RETENTION_DAYS, p_TEMPLATE,
254: p_TEMPLATE_FILE, p_EXECUTION_MODE, sysdate,
255: fnd_global.user_id, sysdate, fnd_global.user_id,
256: fnd_global.login_id, 'N', p_PROCEDURE,
257: p_EMAIL_ENABLED, p_RESTRICTED_FLAG, p_DISABLED_FLAG);
258:
259: --Insert the QUERY DESCRIPTION into the TL table
260: INSERT INTO CSM_QUERY_TL ( QUERY_ID, DESCRIPTION, LANGUAGE,

Line 264: sysdate, fnd_global.user_id,

260: INSERT INTO CSM_QUERY_TL ( QUERY_ID, DESCRIPTION, LANGUAGE,
261: CREATION_DATE, CREATED_BY,
262: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN )
263: VALUES ( l_query_id, P_QUERY_DESC, l_language,
264: sysdate, fnd_global.user_id,
265: sysdate, fnd_global.user_id, fnd_global.login_id);
266:
267: IF l_qry_with_no_var = 'N' THEN --Proces only if the query has variables
268: l_variable_count := p_VARIABLE_NAME.COUNT;

Line 265: sysdate, fnd_global.user_id, fnd_global.login_id);

261: CREATION_DATE, CREATED_BY,
262: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN )
263: VALUES ( l_query_id, P_QUERY_DESC, l_language,
264: sysdate, fnd_global.user_id,
265: sysdate, fnd_global.user_id, fnd_global.login_id);
266:
267: IF l_qry_with_no_var = 'N' THEN --Proces only if the query has variables
268: l_variable_count := p_VARIABLE_NAME.COUNT;
269:

Line 281: fnd_global.user_id, sysdate, fnd_global.user_id,

277: LAST_UPDATE_LOGIN )
278: VALUES ( l_query_id, i, p_VARIABLE_NAME(i),
279: p_VARIABLE_TYPE(i), l_VARIABLE_VALUE_CHAR, p_VARIABLE_VALUE_DATE(i),
280: NVL(p_HIDDEN_FLAG(i),'N'), NVL(p_DEFAULT_FLAG(i),'N'), sysdate,
281: fnd_global.user_id, sysdate, fnd_global.user_id,
282: fnd_global.login_id );
283:
284: END LOOP;
285: END IF;

Line 282: fnd_global.login_id );

278: VALUES ( l_query_id, i, p_VARIABLE_NAME(i),
279: p_VARIABLE_TYPE(i), l_VARIABLE_VALUE_CHAR, p_VARIABLE_VALUE_DATE(i),
280: NVL(p_HIDDEN_FLAG(i),'N'), NVL(p_DEFAULT_FLAG(i),'N'), sysdate,
281: fnd_global.user_id, sysdate, fnd_global.user_id,
282: fnd_global.login_id );
283:
284: END LOOP;
285: END IF;
286:

Line 528: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = fnd_global.user_id,

524: QUERY_OUTPUT_FORMAT = p_QUERY_OUTPUT_FORMAT, MIME_TYPE = p_MIME_TYPE,
525: WORK_FLOW = p_WORK_FLOW, RETENTION_DAYS = p_RETENTION_DAYS,
526: RETENTION_POLICY = p_RETENTION_POLICY, TEMPLATE = p_TEMPLATE,
527: TEMPLATE_FILE = p_TEMPLATE_FILE, EXECUTION_MODE= p_EXECUTION_MODE,
528: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = fnd_global.user_id,
529: LAST_UPDATE_LOGIN = fnd_global.login_id,
530: PROCEDURE_NAME = p_PROCEDURE,
531: EMAIL_ENABLED = p_EMAIL_ENABLED,
532: RESTRICTED_FLAG = p_RESTRICTED_FLAG,

Line 529: LAST_UPDATE_LOGIN = fnd_global.login_id,

525: WORK_FLOW = p_WORK_FLOW, RETENTION_DAYS = p_RETENTION_DAYS,
526: RETENTION_POLICY = p_RETENTION_POLICY, TEMPLATE = p_TEMPLATE,
527: TEMPLATE_FILE = p_TEMPLATE_FILE, EXECUTION_MODE= p_EXECUTION_MODE,
528: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = fnd_global.user_id,
529: LAST_UPDATE_LOGIN = fnd_global.login_id,
530: PROCEDURE_NAME = p_PROCEDURE,
531: EMAIL_ENABLED = p_EMAIL_ENABLED,
532: RESTRICTED_FLAG = p_RESTRICTED_FLAG,
533: DISABLED_FLAG = p_DISABLED_FLAG

Line 539: LAST_UPDATED_BY = fnd_global.user_id,

535:
536: UPDATE CSM_QUERY_TL
537: SET DESCRIPTION = P_QUERY_DESC,
538: LAST_UPDATE_DATE = sysdate,
539: LAST_UPDATED_BY = fnd_global.user_id,
540: LAST_UPDATE_LOGIN = fnd_global.login_id
541: WHERE QUERY_ID = p_QUERY_ID
542: AND LANGUAGE = l_language;
543:

Line 540: LAST_UPDATE_LOGIN = fnd_global.login_id

536: UPDATE CSM_QUERY_TL
537: SET DESCRIPTION = P_QUERY_DESC,
538: LAST_UPDATE_DATE = sysdate,
539: LAST_UPDATED_BY = fnd_global.user_id,
540: LAST_UPDATE_LOGIN = fnd_global.login_id
541: WHERE QUERY_ID = p_QUERY_ID
542: AND LANGUAGE = l_language;
543:
544: IF p_VARIABLE_NAME IS NOT NULL AND p_VARIABLE_TYPE IS NOT NULL THEN

Line 602: fnd_global.user_id, sysdate, fnd_global.user_id,

598: LAST_UPDATE_LOGIN )
599: VALUES ( p_QUERY_ID, i, p_VARIABLE_NAME(i),
600: p_VARIABLE_TYPE(i), l_VARIABLE_VALUE_CHAR, p_VARIABLE_VALUE_DATE(i),
601: NVL(p_HIDDEN_FLAG(i),'N'), NVL(p_DEFAULT_FLAG(i),'N'), sysdate,
602: fnd_global.user_id, sysdate, fnd_global.user_id,
603: fnd_global.login_id );
604:
605:
606: END LOOP;

Line 603: fnd_global.login_id );

599: VALUES ( p_QUERY_ID, i, p_VARIABLE_NAME(i),
600: p_VARIABLE_TYPE(i), l_VARIABLE_VALUE_CHAR, p_VARIABLE_VALUE_DATE(i),
601: NVL(p_HIDDEN_FLAG(i),'N'), NVL(p_DEFAULT_FLAG(i),'N'), sysdate,
602: fnd_global.user_id, sysdate, fnd_global.user_id,
603: fnd_global.login_id );
604:
605:
606: END LOOP;
607:

Line 621: LAST_UPDATED_BY = fnd_global.user_id,

617: VARIABLE_VALUE_DATE = p_VARIABLE_VALUE_DATE(i),
618: HIDDEN = NVL(p_HIDDEN_FLAG(i),'N'),
619: DEFAULT_FLAG = NVL(p_DEFAULT_FLAG(i),'N'),
620: LAST_UPDATE_DATE = sysdate,
621: LAST_UPDATED_BY = fnd_global.user_id,
622: LAST_UPDATE_LOGIN = fnd_global.login_id
623: WHERE QUERY_ID =p_QUERY_ID
624: AND VARIABLE_ID = i ;
625:

Line 622: LAST_UPDATE_LOGIN = fnd_global.login_id

618: HIDDEN = NVL(p_HIDDEN_FLAG(i),'N'),
619: DEFAULT_FLAG = NVL(p_DEFAULT_FLAG(i),'N'),
620: LAST_UPDATE_DATE = sysdate,
621: LAST_UPDATED_BY = fnd_global.user_id,
622: LAST_UPDATE_LOGIN = fnd_global.login_id
623: WHERE QUERY_ID =p_QUERY_ID
624: AND VARIABLE_ID = i ;
625:
626: END LOOP;

Line 665: LAST_UPDATED_BY = fnd_global.user_id,

661: --Update the Query Definition in the base table
662: UPDATE CSM_QUERY_B
663: SET DELETE_FLAG = 'Y',
664: LAST_UPDATE_DATE = sysdate,
665: LAST_UPDATED_BY = fnd_global.user_id,
666: LAST_UPDATE_LOGIN = fnd_global.login_id
667: WHERE QUERY_ID = p_QUERY_ID;
668:
669: --Update the Query Definition in the base table for parent queries

Line 666: LAST_UPDATE_LOGIN = fnd_global.login_id

662: UPDATE CSM_QUERY_B
663: SET DELETE_FLAG = 'Y',
664: LAST_UPDATE_DATE = sysdate,
665: LAST_UPDATED_BY = fnd_global.user_id,
666: LAST_UPDATE_LOGIN = fnd_global.login_id
667: WHERE QUERY_ID = p_QUERY_ID;
668:
669: --Update the Query Definition in the base table for parent queries
670: UPDATE CSM_QUERY_B

Line 673: LAST_UPDATED_BY = fnd_global.user_id,

669: --Update the Query Definition in the base table for parent queries
670: UPDATE CSM_QUERY_B
671: SET DELETE_FLAG = 'Y',
672: LAST_UPDATE_DATE = sysdate,
673: LAST_UPDATED_BY = fnd_global.user_id,
674: LAST_UPDATE_LOGIN = fnd_global.login_id
675: WHERE PARENT_QUERY_ID = p_QUERY_ID;
676:
677: COMMIT;

Line 674: LAST_UPDATE_LOGIN = fnd_global.login_id

670: UPDATE CSM_QUERY_B
671: SET DELETE_FLAG = 'Y',
672: LAST_UPDATE_DATE = sysdate,
673: LAST_UPDATED_BY = fnd_global.user_id,
674: LAST_UPDATE_LOGIN = fnd_global.login_id
675: WHERE PARENT_QUERY_ID = p_QUERY_ID;
676:
677: COMMIT;
678:

Line 1025: LAST_UPDATED_BY = fnd_global.user_id

1021: IF l_rs_access_id IS NOT NULL THEN
1022: UPDATE CSM_QUERY_RESULTS_ACC
1023: SET RESULT = l_xml_blob,
1024: LAST_UPDATE_DATE = sysdate,
1025: LAST_UPDATED_BY = fnd_global.user_id
1026: WHERE ACCESS_ID = l_rs_access_id;
1027:
1028: l_access_id := l_rs_access_id;
1029: ELSE

Line 1034: l_xml_blob, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id)

1030:
1031: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,
1032: RESULT ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1033: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, 1,
1034: l_xml_blob, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id)
1035: RETURNING ACCESS_ID into l_access_id;
1036:
1037: END IF;
1038: ELSE--empty results

Line 1043: LAST_UPDATED_BY = fnd_global.user_id

1039: IF l_rs_access_id IS NOT NULL THEN
1040: UPDATE CSM_QUERY_RESULTS_ACC
1041: SET RESULT = EMPTY_BLOB(),
1042: LAST_UPDATE_DATE = sysdate,
1043: LAST_UPDATED_BY = fnd_global.user_id
1044: WHERE ACCESS_ID = l_rs_access_id;
1045:
1046: l_access_id := l_rs_access_id;
1047: ELSE

Line 1051: EMPTY_BLOB(), fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id)

1047: ELSE
1048: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,
1049: RESULT ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1050: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, 1,
1051: EMPTY_BLOB(), fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id)
1052: RETURNING ACCESS_ID into l_access_id;
1053: END IF;
1054:
1055: END IF;

Line 1314: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);

1310: --Insert the Instance
1311: INSERT INTO CSM_QUERY_INSTANCES_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , INSTANCE_NAME,STATUS,
1312: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1313: VALUES (l_instance_id, p_USER_ID, p_QUERY_ID, l_instance_id,l_instance_name,'OPEN',
1314: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);
1315:
1316:
1317: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1318: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,

Line 1398: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id,l_qvariable_id)

1394: INSTANCE_ID , VARIABLE_ID,VARIABLE_VALUE_CHAR,VARIABLE_VALUE_DATE,
1395: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,GEN_PK)
1396: VALUES (l_qvariable_id, p_USER_ID, p_QUERY_ID,
1397: l_instance_id, i, l_VARIABLE_VALUE_CHAR, p_VARIABLE_VALUE_DATE(i),
1398: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id,l_qvariable_id)
1399: RETURNING ACCESS_ID into l_access_id;
1400:
1401: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1402: l_mark_dirty := asg_Download.mark_dirty(p_pub_item => g_pub_item_qval,

Line 1965: LAST_UPDATED_BY = fnd_global.user_id

1961: IF l_rs_access_id IS NOT NULL THEN
1962: UPDATE CSM_QUERY_RESULTS_ACC
1963: SET RESULT = p_QUERY_RESULT,
1964: LAST_UPDATE_DATE = sysdate,
1965: LAST_UPDATED_BY = fnd_global.user_id
1966: WHERE ACCESS_ID = l_rs_access_id;
1967:
1968: l_access_id := l_rs_access_id;
1969: ELSE

Line 1974: p_QUERY_RESULT, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id)

1970:
1971: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,
1972: RESULT ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1973: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, 1,
1974: p_QUERY_RESULT, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id)
1975: RETURNING ACCESS_ID into l_access_id;
1976:
1977: END IF;
1978: ELSE--empty results

Line 1983: LAST_UPDATED_BY = fnd_global.user_id

1979: IF l_rs_access_id IS NOT NULL THEN
1980: UPDATE CSM_QUERY_RESULTS_ACC
1981: SET RESULT = EMPTY_BLOB(),
1982: LAST_UPDATE_DATE = sysdate,
1983: LAST_UPDATED_BY = fnd_global.user_id
1984: WHERE ACCESS_ID = l_rs_access_id;
1985:
1986: l_access_id := l_rs_access_id;
1987: ELSE

Line 1991: EMPTY_BLOB(), fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id)

1987: ELSE
1988: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,
1989: RESULT ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1990: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, 1,
1991: EMPTY_BLOB(), fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id)
1992: RETURNING ACCESS_ID into l_access_id;
1993: END IF;
1994:
1995: END IF;