APPS.PO_CLM_CAR_SEC dependencies on DBMS_SESSION

Line 15: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','Y');

11: INTO x_site_id
12: FROM PO_CLM_AGENCIES
13: WHERE AGENCY_ID = p_agency_id;
14:
15: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','Y');
16: x_pwd := fnd_vault.get('PO', x_site_id);
17: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','N');
18:
19: EXCEPTION

Line 17: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','N');

13: WHERE AGENCY_ID = p_agency_id;
14:
15: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','Y');
16: x_pwd := fnd_vault.get('PO', x_site_id);
17: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','N');
18:
19: EXCEPTION
20: WHEN OTHERS THEN
21: x_site_id := null;

Line 32: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','Y');

28: p_pwd IN VARCHAR2
29: ) IS
30: BEGIN
31:
32: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','Y');
33: fnd_vault.puts('PO', p_site_id, p_pwd, 'PO_CLM_CAR_SEC_CTX.PO_CLM_CAR_SEC_ATTR');
34: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','N');
35:
36: END;

Line 34: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','N');

30: BEGIN
31:
32: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','Y');
33: fnd_vault.puts('PO', p_site_id, p_pwd, 'PO_CLM_CAR_SEC_CTX.PO_CLM_CAR_SEC_ATTR');
34: DBMS_SESSION.SET_CONTEXT('PO_CLM_CAR_SEC_CTX', 'PO_CLM_CAR_SEC_ATTR','N');
35:
36: END;
37:
38: END;