APPS.ZPB_BUSAREA_VAL dependencies on ZPB_VALIDATION_TEMP_DATA

Line 31: the ZPB_VALIDATION_TEMP_DATA table for later retrieval in java layer.

27: OWNERSHIP
28: setting these columns to 2 (locked) as needed.
29:
30: Also inserts the invalid querys name and path details into
31: the ZPB_VALIDATION_TEMP_DATA table for later retrieval in java layer.
32:
33: -- p_baId -- Business Area Id
34: -- p_user_id -- User id pulled from query
35: -- p_queryName -- The Invalid Query Object Name

Line 90: INSERT into ZPB_VALIDATION_TEMP_DATA

86: WHERE USER_ID = p_userId AND
87: BUSINESS_AREA_ID = p_baId;
88: END IF;
89:
90: INSERT into ZPB_VALIDATION_TEMP_DATA
91: (BUSINESS_AREA_ID,
92: VALUE_TYPE,
93: VALUE,
94: STATUS_SQL_ID)

Line 167: the ZPB_VALIDATION_TEMP_DATA table for later retrieval in java layer.

163: /*
164:
165: This procedure updates the invalid Published BP definition's status_code as
166: 'INVALID_BP' and Inserts the invalid query's name and path details into
167: the ZPB_VALIDATION_TEMP_DATA table for later retrieval in java layer.
168: -- p_queryName -- The Invalid Query Object Name
169: -- p_queryPath -- The Invalid Query object path
170: -- p_queryErrorType -- Tells whether the query is to be fixed +
171: -- marked as Invalid ("F") OR Just Refrshed ("R")

Line 189: INSERT into ZPB_VALIDATION_TEMP_DATA

185:
186: BEGIN
187: IF(p_init_fix = 'Y') THEN
188: l_num := 0;
189: INSERT into ZPB_VALIDATION_TEMP_DATA
190: (BUSINESS_AREA_ID,
191: VALUE_TYPE,
192: VALUE,
193: ANALYSIS_CYCLE_ID)