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.EDR_PSIG dependencies on EDR_PSIG_DETAILS

Line 84: SELECT SIGNATURE_STATUS from EDR_PSIG_DETAILS

80: X_STATUS OUT NOCOPY VARCHAR2,
81: X_ERROR OUT NOCOPY NUMBER,
82: X_ERROR_MSG OUT NOCOPY VARCHAR2) IS
83: CURSOR C1 is
84: SELECT SIGNATURE_STATUS from EDR_PSIG_DETAILS
85: WHERE SIGNATURE_ID = P_SIGNATURE_ID;
86: L_Signature_status varchar2(240);
87: BEGIN
88: OPEN C1;

Line 729: SELECT count(*) from EDR_PSIG_DETAILS

725: L_LAST_UPDATE_DATE DATE;
726: L_LAST_UPDATED_BY NUMBER;
727: L_LAST_UPDATE_LOGIN NUMBER;
728: CURSOR C1 is
729: SELECT count(*) from EDR_PSIG_DETAILS
730: WHERE document_id =P_DOCUMENT_ID AND
731: SIGNATURE_STATUS='PENDING';
732: l_count number;
733: BEGIN

Line 976: SELECT count(*) from EDR_PSIG_DETAILS

972: P_ERROR_MSG OUT NOCOPY VARCHAR2
973: ) IS
974: l_status varchar2(240);
975: CURSOR C1 is
976: SELECT count(*) from EDR_PSIG_DETAILS
977: WHERE document_id =P_DOCUMENT_ID AND
978: SIGNATURE_STATUS='PENDING';
979: l_count number;
980: BEGIN

Line 1134: from EDR_PSIG_DETAILS

1130: -- and ADDED also
1131: /*
1132: CURSOR C1 is
1133: Select count(*)
1134: from EDR_PSIG_DETAILS
1135: where document_id=p_document_id and
1136: USER_NAME=P_USER_NAME and
1137: NVL(ORIGINAL_RECIPIENT,0)=NVL(P_ORIGINAL_RECIPIENT,0);
1138: */

Line 1141: from EDR_PSIG_DETAILS

1137: NVL(ORIGINAL_RECIPIENT,0)=NVL(P_ORIGINAL_RECIPIENT,0);
1138: */
1139: CURSOR C1 is
1140: Select count(*)
1141: from EDR_PSIG_DETAILS
1142: where document_id=p_document_id and
1143: USER_NAME=P_USER_NAME and
1144: NVL(ORIGINAL_RECIPIENT,0)=NVL(P_ORIGINAL_RECIPIENT,0) and
1145: NVL(ADHOC_STATUS,'0') <> 'DELETED';

Line 1211: select (nvl(max(signature_sequence),0) +1) into l_signer_seq from edr_psig_details

1207: --If the signature_sequence is not present in the argument
1208: --get the max and then add 1
1209: --raise error if the signature sequence is passed as 0
1210: IF (P_SIGNATURE_SEQUENCE is null ) then
1211: select (nvl(max(signature_sequence),0) +1) into l_signer_seq from edr_psig_details
1212: where document_id = P_DOCUMENT_ID;
1213: ELSIF ( P_SIGNATURE_SEQUENCE <= 0) THEN
1214: fnd_message.set_name('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');
1215: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_INVALID_SIGNATURE_SEQ');

Line 1234: select EDR_PSIG_DETAILS_S.nextval into l_signature_id from dual;

1230: END IF;
1231:
1232: --Bug 3330240 : end
1233: /* Get New Signature Id */
1234: select EDR_PSIG_DETAILS_S.nextval into l_signature_id from dual;
1235: /* Insert signature Details */
1236:
1237: --Bug 3330240 : Start
1238: --Inert the adhoc_status, signature_sequence also

Line 1241: INSERT into EDR_PSIG_DETAILS

1237: --Bug 3330240 : Start
1238: --Inert the adhoc_status, signature_sequence also
1239: -- and also the 5 WHO columns
1240: /*
1241: INSERT into EDR_PSIG_DETAILS
1242: (
1243: SIGNATURE_ID,
1244: DOCUMENT_ID,
1245: USER_NAME,

Line 1260: INSERT into EDR_PSIG_DETAILS

1256: P_OVERRIDING_COMMENTS,
1257: 'PENDING'
1258: );
1259: */
1260: INSERT into EDR_PSIG_DETAILS
1261: (
1262: SIGNATURE_ID,
1263: DOCUMENT_ID,
1264: USER_NAME,

Line 1352: select Signature_id from EDR_PSIG_DETAILS

1348: --we need to verify for signature_status CANCEL also
1349: -- as if a default signer is deleted we put the status as CANCEL
1350: /*
1351: CURSOR C1 IS
1352: select Signature_id from EDR_PSIG_DETAILS
1353: where DOCUMENT_ID=P_DOCUMENT_ID AND
1354: decode(P_ORIGINAL_RECIPIENT,NULL,USER_NAME,ORIGINAL_RECIPIENT)
1355: = nvl(P_ORIGINAL_RECIPIENT,P_USER_NAME)
1356: AND SIGNATURE_STATUS <> 'COMPLETE';

Line 1360: select Signature_id from EDR_PSIG_DETAILS

1356: AND SIGNATURE_STATUS <> 'COMPLETE';
1357: */
1358:
1359: CURSOR C1 IS
1360: select Signature_id from EDR_PSIG_DETAILS
1361: where DOCUMENT_ID=P_DOCUMENT_ID AND
1362: decode(P_ORIGINAL_RECIPIENT,NULL,USER_NAME,ORIGINAL_RECIPIENT)
1363: = nvl(P_ORIGINAL_RECIPIENT,P_USER_NAME)
1364: AND SIGNATURE_STATUS not in ('COMPLETE','CANCEL');

Line 1430: select count(*) into l_pending_count from edr_psig_details

1426: --Bug 3330240 : start
1427: -- validate if the posting is in conjuction with the signature
1428: -- sequence
1429:
1430: select count(*) into l_pending_count from edr_psig_details
1431: where signature_status = 'PENDING'
1432: and signature_sequence < (select signature_sequence
1433: from edr_psig_details
1434: where signature_id = l_signature_id)

Line 1433: from edr_psig_details

1429:
1430: select count(*) into l_pending_count from edr_psig_details
1431: where signature_status = 'PENDING'
1432: and signature_sequence < (select signature_sequence
1433: from edr_psig_details
1434: where signature_id = l_signature_id)
1435: and document_id = P_DOCUMENT_ID
1436: and adhoc_status <> 'DELETED';
1437:

Line 1449: UPDATE EDR_PSIG_DETAILS

1445:
1446: /* Above NVL logic is to make sure that we support old code */
1447: /* UPDATE signature Details */
1448: /*
1449: UPDATE EDR_PSIG_DETAILS
1450: SET
1451: EVIDENCE_STORE_ID=P_EVIDENCE_STORE_ID,
1452: USER_RESPONSE=P_USER_RESPONSE,
1453: ORIGINAL_RECIPIENT=nvl(P_ORIGINAL_RECIPIENT,ORIGINAL_RECIPIENT),

Line 1466: UPDATE EDR_PSIG_DETAILS

1462: */
1463:
1464: --Bug 3101047 : Start
1465: EDR_UTILITIES .getUserRoleInfo(p_user_name, l_user_display_name, l_orig_system, l_orig_system_id);
1466: UPDATE EDR_PSIG_DETAILS
1467: SET
1468: EVIDENCE_STORE_ID=P_EVIDENCE_STORE_ID,
1469: USER_RESPONSE=P_USER_RESPONSE,
1470: ORIGINAL_RECIPIENT=nvl(P_ORIGINAL_RECIPIENT,ORIGINAL_RECIPIENT),

Line 1528: from EDR_PSIG_DETAILS

1524: l_status varchar2(240);
1525: l_sig_status varchar2(100);
1526: CURSOR C1
1527: is SELECT DOCUMENT_ID,SIGNATURE_STATUS
1528: from EDR_PSIG_DETAILS
1529: where SIGNATURE_ID = P_SIGNATURE_ID;
1530: BEGIN
1531: /*12-26-2002 Start: Set the secure context to access edr_psig_documents table */
1532: edr_ctx_pkg.set_secure_attr;

Line 1570: UPDATE EDR_PSIG_DETAILS

1566: /* Document Exist */
1567: --Bug 3330240 : start
1568: --update the WHO columns also
1569: /*
1570: UPDATE EDR_PSIG_DETAILS
1571: set SIGNATURE_STATUS='CANCEL'
1572: where SIGNATURE_ID=P_SIGNATURE_ID;
1573: */
1574: UPDATE EDR_PSIG_DETAILS

Line 1574: UPDATE EDR_PSIG_DETAILS

1570: UPDATE EDR_PSIG_DETAILS
1571: set SIGNATURE_STATUS='CANCEL'
1572: where SIGNATURE_ID=P_SIGNATURE_ID;
1573: */
1574: UPDATE EDR_PSIG_DETAILS
1575: set SIGNATURE_STATUS='CANCEL',
1576: LAST_UPDATE_DATE=SYSDATE,
1577: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
1578: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID

Line 1743: (select Document_id from EDR_PSIG_DETAILS

1739: /* Check if document is existing */
1740: SELECT PSIG_STATUS into l_status
1741: from EDR_PSIG_DOCUMENTS
1742: where DOCUMENT_ID in
1743: (select Document_id from EDR_PSIG_DETAILS
1744: where signature_id=P_SIGNATURE_ID);
1745: IF l_status in ('PENDING','ERROR') THEN
1746: /* Document Exist */
1747: /* Process Table and inser rows in Table */

Line 1869: FROM EDR_PSIG_DETAILS

1865: LAST_UPDATED_BY,
1866: --Bug 3101047 : Start
1867: DECODE(SIGNATURE_TIMESTAMP,NULL,EDR_UTILITIES.GETUSERDISPLAYNAME(USER_NAME), USER_DISPLAY_NAME)USER_DISPLAY_NAME
1868: --Bug 3101047 : End
1869: FROM EDR_PSIG_DETAILS
1870: where DOCUMENT_ID=P_DOCUMENT_ID;
1871: BEGIN
1872: --Bug 4073809 : start
1873: i := 1;

Line 2005: FROM EDR_PSIG_DETAILS

2001: LAST_UPDATED_BY,
2002: --Bug 3101047 : Start
2003: DECODE(SIGNATURE_TIMESTAMP,NULL,EDR_UTILITIES.GETUSERDISPLAYNAME(USER_NAME), USER_DISPLAY_NAME)USER_DISPLAY_NAME
2004: --Bug 3101047 : End
2005: FROM EDR_PSIG_DETAILS
2006: where SIGNATURE_ID=P_SIGNATURE_ID;
2007: BEGIN
2008:
2009: --Bug 4073809 : start

Line 2100: SELECT SIGNATURE_ID from EDR_PSIG_DETAILS

2096: X_ERROR out NOCOPY number,
2097: X_ERROR_MSG out NOCOPY varchar2)
2098: is
2099: CURSOR c1 is
2100: SELECT SIGNATURE_ID from EDR_PSIG_DETAILS
2101: WHERE DOCUMENT_ID = P_DOCUMENT_ID
2102: AND ORIGINAL_RECIPIENT = P_ORIGINAL_RECIPIENT
2103: AND USER_NAME = P_USER_NAME
2104: AND SIGNATURE_STATUS = P_SIGNATURE_STATUS;

Line 2132: SELECT ADHOC_STATUS from EDR_PSIG_DETAILS

2128: X_ERROR OUT NOCOPY NUMBER,
2129: X_ERROR_MSG OUT NOCOPY VARCHAR2)
2130: IS
2131: CURSOR C1 is
2132: SELECT ADHOC_STATUS from EDR_PSIG_DETAILS
2133: WHERE SIGNATURE_ID = P_SIGNATURE_ID;
2134:
2135: BEGIN
2136: OPEN C1;

Line 2167: from EDR_PSIG_DETAILS

2163: l_sig_status varchar2(100);
2164: l_adhoc_status varchar2(32);
2165: CURSOR C1
2166: is SELECT DOCUMENT_ID,SIGNATURE_STATUS, ADHOC_STATUS
2167: from EDR_PSIG_DETAILS
2168: where SIGNATURE_ID = P_SIGNATURE_ID;
2169: BEGIN
2170: /* set the secure context */
2171: edr_ctx_pkg.set_secure_attr;

Line 2215: DELETE FROM EDR_PSIG_DETAILS

2211: END IF;
2212:
2213:
2214: /* Document Exist */
2215: DELETE FROM EDR_PSIG_DETAILS
2216: where SIGNATURE_ID=P_SIGNATURE_ID;
2217:
2218: X_ERROR := 0;
2219: EXCEPTION

Line 2247: from EDR_PSIG_DETAILS

2243: l_status varchar2(240);
2244: l_sig_status varchar2(100);
2245: CURSOR C1
2246: is SELECT DOCUMENT_ID,SIGNATURE_STATUS
2247: from EDR_PSIG_DETAILS
2248: where SIGNATURE_ID = P_SIGNATURE_ID;
2249:
2250: BEGIN
2251: /*Start: Set the secure context to access edr_psig_documents table */

Line 2294: UPDATE EDR_PSIG_DETAILS

2290: RAISE EDR_GENERIC_ERROR;
2291: END IF;
2292:
2293: /* Document Exist */
2294: UPDATE EDR_PSIG_DETAILS
2295: set SIGNATURE_SEQUENCE=P_SIGNATURE_SEQUENCE,
2296: LAST_UPDATE_DATE=SYSDATE,
2297: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
2298: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID

Line 2327: from EDR_PSIG_DETAILS

2323: l_status varchar2(240);
2324: l_sig_status varchar2(100);
2325: CURSOR C1
2326: is SELECT DOCUMENT_ID,SIGNATURE_STATUS
2327: from EDR_PSIG_DETAILS
2328: where SIGNATURE_ID = P_SIGNATURE_ID;
2329:
2330: BEGIN
2331: /*Start: Set the secure context to access edr_psig_documents table */

Line 2374: UPDATE EDR_PSIG_DETAILS

2370: X_ERROR_MSG:= fnd_message.get();
2371: RAISE EDR_GENERIC_ERROR;
2372: END IF;
2373: /* Document Exist */
2374: UPDATE EDR_PSIG_DETAILS
2375: set ADHOC_STATUS=P_ADHOC_STATUS,
2376: LAST_UPDATE_DATE=SYSDATE,
2377: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
2378: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID

Line 2448: select USER_NAME from EDR_PSIG_DETAILS where DOCUMENT_ID=p_document_id

2444: l_orig_system VARCHAR2(240);
2445: l_orig_system_id NUMBER;
2446:
2447: CURSOR GET_PSIG_USER_NAME IS
2448: select USER_NAME from EDR_PSIG_DETAILS where DOCUMENT_ID=p_document_id
2449: and SIGNATURE_STATUS = 'PENDING'
2450: and USER_DISPLAY_NAME is null
2451: and ORIG_SYSTEM is null
2452: and ORIG_SYSTEM_ID is null;

Line 2471: update EDR_PSIG_DETAILS

2467: X_ORIG_SYSTEM => l_orig_system,
2468: X_ORIG_SYSTEM_ID => l_orig_system_id);
2469:
2470:
2471: update EDR_PSIG_DETAILS
2472: set
2473: USER_DISPLAY_NAME=l_user_display_name,
2474: ORIG_SYSTEM=l_orig_system,
2475: ORIG_SYSTEM_ID=l_orig_system_id

Line 2636: from edr_psig_details psig

2632: )
2633:
2634: into l_result
2635:
2636: from edr_psig_details psig
2637:
2638: where
2639:
2640: psig.document_id = p_document_id;

Line 3274: update edr_psig_details

3270: procedure clear_pending_signatures
3271: (p_document_id in number)
3272: is
3273: begin
3274: update edr_psig_details
3275: set signature_status = null,
3276: LAST_UPDATE_DATE=SYSDATE,
3277: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
3278: LAST_UPDATE_LOGIN=FND_GLOBAL.LOGIN_ID