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 CSM_QUERY_RESULTS_ACC

Line 850: FROM CSM_QUERY_RESULTS_ACC

846:
847: CURSOR c_check_results(c_USER_ID NUMBER,c_QUERY_ID NUMBER,c_INSTANCE_ID NUMBER)
848: IS
849: SELECT ACCESS_ID
850: FROM CSM_QUERY_RESULTS_ACC
851: WHERE QUERY_ID = c_QUERY_ID
852: AND USER_ID = c_USER_ID
853: AND INSTANCE_ID = c_INSTANCE_ID;
854:

Line 1022: UPDATE CSM_QUERY_RESULTS_ACC

1018: dbms_lob.createtemporary(l_xml_blob,TRUE);
1019: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,
1020: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);
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;

Line 1031: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,

1027:
1028: l_access_id := l_rs_access_id;
1029: ELSE
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;

Line 1033: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, 1,

1029: ELSE
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;

Line 1040: UPDATE CSM_QUERY_RESULTS_ACC

1036:
1037: END IF;
1038: ELSE--empty results
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;

Line 1048: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,

1044: WHERE ACCESS_ID = l_rs_access_id;
1045:
1046: l_access_id := l_rs_access_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;

Line 1050: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, 1,

1046: l_access_id := l_rs_access_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:

Line 1632: FROM CSM_QUERY_RESULTS_ACC

1628:
1629: CURSOR c_get_results (c_USER_ID NUMBER, c_QUERY_ID NUMBER, c_INSTANCE_ID NUMBER )
1630: IS
1631: SELECT ACCESS_ID
1632: FROM CSM_QUERY_RESULTS_ACC
1633: WHERE QUERY_ID = c_QUERY_ID
1634: AND USER_ID = c_USER_ID
1635: AND INSTANCE_ID = c_INSTANCE_ID;
1636:

Line 1698: DELETE FROM CSM_QUERY_RESULTS_ACC WHERE ACCESS_ID = l_access_id_list(i);

1694: FETCH c_get_results BULK COLLECT INTO l_access_id_list;
1695: CLOSE c_get_results;
1696:
1697: FORALL i in 1..l_access_id_list.COUNT
1698: DELETE FROM CSM_QUERY_RESULTS_ACC WHERE ACCESS_ID = l_access_id_list(i);
1699:
1700: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1701: FOR i in 1..l_access_id_list.COUNT LOOP
1702: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,

Line 1936: FROM CSM_QUERY_RESULTS_ACC

1932: AS
1933: CURSOR c_check_results(c_USER_ID NUMBER,c_QUERY_ID NUMBER,c_INSTANCE_ID NUMBER)
1934: IS
1935: SELECT ACCESS_ID
1936: FROM CSM_QUERY_RESULTS_ACC
1937: WHERE QUERY_ID = c_QUERY_ID
1938: AND USER_ID = c_USER_ID
1939: AND INSTANCE_ID = c_INSTANCE_ID;
1940:

Line 1962: UPDATE CSM_QUERY_RESULTS_ACC

1958: SAVEPOINT INSERT_RESULT;
1959:
1960: IF p_QUERY_RESULT IS NOT NULL THEN
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;

Line 1971: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,

1967:
1968: l_access_id := l_rs_access_id;
1969: ELSE
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;

Line 1973: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, 1,

1969: ELSE
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;

Line 1980: UPDATE CSM_QUERY_RESULTS_ACC

1976:
1977: END IF;
1978: ELSE--empty results
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;

Line 1988: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,

1984: WHERE ACCESS_ID = l_rs_access_id;
1985:
1986: l_access_id := l_rs_access_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;

Line 1990: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, p_USER_ID, p_QUERY_ID, p_INSTANCE_ID, 1,

1986: l_access_id := l_rs_access_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: