APPS.EDR_PSIG dependencies on EDR_CTX_PKG

Line 735: edr_ctx_pkg.set_secure_attr;

731: SIGNATURE_STATUS='PENDING';
732: l_count number;
733: BEGIN
734: /*12-26-2002 Start: Set the secure context to access edr_psig_documents table */
735: edr_ctx_pkg.set_secure_attr;
736: /*12-26-2002 End*/
737: /* CHECK if document Status is Valid */
738: IF UPPER(P_STATUS) NOT IN ('CANCEL','COMPLETE','ERROR','PENDING','REJECTED','TIMEDOUT') then
739: RAISE EDR_INVALID_DOC_STATUS;

Line 855: edr_ctx_pkg.set_secure_attr;

851:
852:
853:
854: /*12-26-2002 Start: Set the secure context to access edr_psig_documents table */
855: edr_ctx_pkg.set_secure_attr;
856: /*12-26-2002 End*/
857:
858: /* Check if document is existing */
859:

Line 982: edr_ctx_pkg.set_secure_attr;

978: SIGNATURE_STATUS='PENDING';
979: l_count number;
980: BEGIN
981: /*12-26-2002 Start: Set the secure context to access edr_psig_documents table */
982: edr_ctx_pkg.set_secure_attr;
983: /*12-26-2002 End*/
984:
985: /* Check if document is existing */
986:

Line 1053: edr_ctx_pkg.set_secure_attr;

1049: l_status varchar2(240);
1050:
1051: BEGIN
1052: /*12-26-2002 Start: Set the secure context to access edr_psig_documents table */
1053: edr_ctx_pkg.set_secure_attr;
1054: /*12-26-2002 End*/
1055:
1056: /* Check if document is existing */
1057:

Line 1152: edr_ctx_pkg.set_secure_attr;

1148: --Bug 3330240: end
1149:
1150: BEGIN
1151: /*12-26-2002 Start: Set the secure context to access edr_psig_documents table */
1152: edr_ctx_pkg.set_secure_attr;
1153: /*12-26-2002 End*/
1154:
1155: /* Check if Server time Zone is set to NULL and if error out */
1156: VERIFY_TIMEZONE(X_TIMEZONE =>l_server_timezone,

Line 1370: edr_ctx_pkg.set_secure_attr;

1366: --Bug 3330240 : end
1367:
1368: BEGIN
1369: /*12-26-2002 Start: Set the secure context to access edr_psig_documents table */
1370: edr_ctx_pkg.set_secure_attr;
1371: /*12-26-2002 End*/
1372:
1373: /* Check if Server time Zone is set to NULL and if error out */
1374: VERIFY_TIMEZONE(X_TIMEZONE =>l_server_timezone,

Line 1532: edr_ctx_pkg.set_secure_attr;

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;
1533: /*12-26-2002 End*/
1534: /* Check if Signature Row Exist */
1535: OPEN C1;
1536: FETCH C1 into l_document_id,l_sig_status;

Line 1611: edr_ctx_pkg.set_secure_attr;

1607: L_ROWID ROWID;
1608:
1609: BEGIN
1610: /*12-26-2002 Start: Set the secure context to access edr_psig_documents table */
1611: edr_ctx_pkg.set_secure_attr;
1612: /*12-26-2002 End*/
1613:
1614: /* Check if document is existing */
1615: SELECT PSIG_STATUS into l_status

Line 1736: edr_ctx_pkg.set_secure_attr;

1732: NAME=L_PARAM_NAME;
1733:
1734: BEGIN
1735: /*12-26-2002 Start: Set the secure context to access edr_psig_documents table */
1736: edr_ctx_pkg.set_secure_attr;
1737: /*12-26-2002 End*/
1738:
1739: /* Check if document is existing */
1740: SELECT PSIG_STATUS into l_status

Line 2171: edr_ctx_pkg.set_secure_attr;

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;
2172: /* Check if Signature Row Exist */
2173: OPEN C1;
2174: FETCH C1 into l_document_id,l_sig_status, l_adhoc_status;
2175: IF c1%NOTFOUND THEN

Line 2252: edr_ctx_pkg.set_secure_attr;

2248: where SIGNATURE_ID = P_SIGNATURE_ID;
2249:
2250: BEGIN
2251: /*Start: Set the secure context to access edr_psig_documents table */
2252: edr_ctx_pkg.set_secure_attr;
2253: /* Check if Signature Row Exist */
2254: OPEN C1;
2255: FETCH C1 into l_document_id,l_sig_status;
2256: IF c1%NOTFOUND THEN

Line 2332: edr_ctx_pkg.set_secure_attr;

2328: where SIGNATURE_ID = P_SIGNATURE_ID;
2329:
2330: BEGIN
2331: /*Start: Set the secure context to access edr_psig_documents table */
2332: edr_ctx_pkg.set_secure_attr;
2333: /* Check if Signature Row Exist */
2334: OPEN C1;
2335: FETCH C1 into l_document_id,l_sig_status;
2336: IF c1%NOTFOUND THEN

Line 2421: edr_ctx_pkg.set_secure_attr;

2417: X_ERROR_MSG OUT NOCOPY VARCHAR2 )
2418: IS
2419: BEGIN
2420: /* Set the security context to get access to PSIG_DOCUMENTS */
2421: edr_ctx_pkg.set_secure_attr;
2422:
2423: select psig_xml into x_psig_xml
2424: from edr_psig_documents
2425: where document_id = p_document_id;

Line 3127: edr_ctx_pkg.set_secure_attr;

3123:
3124: begin
3125:
3126: --Set the secure context.
3127: edr_ctx_pkg.set_secure_attr;
3128:
3129: l_count := 0;
3130: l_temp_counter := 0;
3131:

Line 3199: edr_ctx_pkg.unset_secure_attr;

3195: X_FINAL_XML => X_FINAL_XML);
3196:
3197:
3198: --Unset the secure context.
3199: edr_ctx_pkg.unset_secure_attr;
3200:
3201:
3202: EXCEPTION
3203: WHEN NO_DATA_FOUND THEN