APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on OKC_REP_CONTRACTS_ALL

Line 29: -- two possible values: 'okc_rep_contracts_all' (for

25: -- crawled.
26: -- IN p_driving_table IN VARCHAR2
27: -- The table that drives the VO associated with the
28: -- contract document currently being crawled. There are
29: -- two possible values: 'okc_rep_contracts_all' (for
30: -- repository contracts) and 'okc_rep_contract_vers'
31: -- (for archived contracts).
32: -- OUT : x_acl OUT VARCHAR2
33: -- A space-delimited string of ACL keys that define

Line 76: FROM okc_rep_contracts_all

72: -- Get owner IDs for a given repository contract
73: CURSOR owner_rep_csr
74: IS
75: SELECT owner_id
76: FROM okc_rep_contracts_all
77: WHERE contract_id = p_bus_doc_id;
78:
79: -- Get owner IDs for a given archive contract
80: CURSOR owner_archive_csr

Line 119: FROM okc_rep_contracts_all

115: -- 1. Get contract.use_acl_flag for the given p_bus_doc_id.
116: -- nvl: if the value returned is null, set it to 'N'.
117: SELECT nvl(use_acl_flag,'N')
118: INTO l_use_acl_flag
119: FROM okc_rep_contracts_all
120: WHERE contract_id = p_bus_doc_id;
121:
122: -- 2. If (contract.use_acl_flag == false), then add the string
123: -- 'no_acl' to the ACL.

Line 150: -- If the driving table is 'okc_rep_contracts_all' (repository

146: -- 4. Add the string 'admin_acl' to the ACL.
147: x_acl := x_acl || 'admin_acl' || ' ';
148:
149: -- 5. Add the contract owner's user id o to the ACL.
150: -- If the driving table is 'okc_rep_contracts_all' (repository
151: -- contracts), we need to match only the document ID and not the
152: -- document version, so we use the owner_rep_csr cursor.
153: IF (p_driving_table = 'okc_rep_contracts_all')
154: THEN

Line 153: IF (p_driving_table = 'okc_rep_contracts_all')

149: -- 5. Add the contract owner's user id o to the ACL.
150: -- If the driving table is 'okc_rep_contracts_all' (repository
151: -- contracts), we need to match only the document ID and not the
152: -- document version, so we use the owner_rep_csr cursor.
153: IF (p_driving_table = 'okc_rep_contracts_all')
154: THEN
155: FOR owner_rep_rec IN owner_rep_csr
156: LOOP
157: x_acl := x_acl || 'o' || to_char(owner_rep_rec.owner_id) || ' ';

Line 1159: FROM okc_rep_contracts_all

1155: l_results VARCHAR2(1);
1156:
1157: CURSOR rep_status_csr IS
1158: SELECT contract_status_code
1159: FROM okc_rep_contracts_all
1160: WHERE contract_id = p_document_id;
1161:
1162: CURSOR po_status_csr IS
1163: SELECT NVL(authorization_status, 'INCOMPLETE') AS contract_status_code