APPS.AZW_FLOW dependencies on AZ_PRODUCT_PHASES

Line 8: -- Given an application id, return TRUE if it exists in az_product_phases

4: --
5: -- application_not_found
6: --
7: -- Private function. Called by populate_product_flows.
8: -- Given an application id, return TRUE if it exists in az_product_phases
9: --
10:
11: FUNCTION application_not_found(p_application_id NUMBER) RETURN BOOLEAN IS
12:

Line 19: FROM az_product_phases azpp

15:
16: BEGIN
17: SELECT COUNT(*)
18: INTO v_cnt
19: FROM az_product_phases azpp
20: WHERE application_id = p_application_id;
21:
22: IF (v_cnt = 0) THEN
23: ret := TRUE;

Line 38: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_product_phases');

34: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
35: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
36: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
37: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.application_not_found');
38: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_product_phases');
39: APP_EXCEPTION.RAISE_EXCEPTION;
40: END application_not_found;
41:
42:

Line 156: -- az_product_phases

152: DELETE
153: FROM az_product_flows;
154: COMMIT;
155: -- populate defaults of phase 1 for all installed products into
156: -- az_product_phases
157:
158: --DBMS_OUTPUT.PUT_LINE('trying to open cursor1');
159:
160: BEGIN

Line 167: INSERT INTO az_product_phases

163:
164: WHILE applications_cursor%FOUND LOOP
165: --DBMS_OUTPUT.PUT_LINE('application id ' || v_installed_prod_id);
166: IF application_not_found(v_installed_prod_id) THEN
167: INSERT INTO az_product_phases
168: (application_id, phase, last_update_date, last_updated_by,
169: creation_date, created_by)
170: VALUES(v_installed_prod_id, 1, sysdate, 1, sysdate, 1);
171: END IF;