33: WHERE read_only_flag = 'U')
34: AND status = 'VALID';
35:
36: l_req_id NUMBER;
37: l_org_id psa_implementation_all.org_id%TYPE;
38: l_psa_feature psa_implementation_all.psa_feature%TYPE;
39: l_enabled_flag psa_implementation_all.status%TYPE;
40: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
41: l_start_date VARCHAR2(20);
34: AND status = 'VALID';
35:
36: l_req_id NUMBER;
37: l_org_id psa_implementation_all.org_id%TYPE;
38: l_psa_feature psa_implementation_all.psa_feature%TYPE;
39: l_enabled_flag psa_implementation_all.status%TYPE;
40: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
41: l_start_date VARCHAR2(20);
42: l_post_thru_date VARCHAR2(20);
35:
36: l_req_id NUMBER;
37: l_org_id psa_implementation_all.org_id%TYPE;
38: l_psa_feature psa_implementation_all.psa_feature%TYPE;
39: l_enabled_flag psa_implementation_all.status%TYPE;
40: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
41: l_start_date VARCHAR2(20);
42: l_post_thru_date VARCHAR2(20);
43: l_message VARCHAR2(2000);
174: END IF;
175: END IF;
176:
177: -- ## checking whether PSA is installed
178: IF (psa_implementation.get (P_ORG_ID => l_org_id,
179: P_PSA_FEATURE => l_psa_feature,
180: P_ENABLED_FLAG => l_enabled_flag)) THEN
181:
182: /*
180: P_ENABLED_FLAG => l_enabled_flag)) THEN
181:
182: /*
183: ## If the IF LOOP is true that means there is a record for this org id
184: ## in psa_implementation_v but it does not mean the product is enabled.
185: ## The p_enabled_flag will show whether the product is installed or not
186: */
187:
188: IF NVL(l_enabled_flag,'N') = 'N' THEN