APPS.POS_BULKLOAD_ENTITIES dependencies on EGO_RESULTS_FMT_USAGES

Line 205: FROM ego_results_fmt_usages

201: p_result_format_usage_id IN NUMBER
202: ) Is
203: CURSOR c_ebi_col_mapping_addr(c_fmt_usage_id in number) is
204: SELECT INTF_COLUMN_NAME
205: FROM ego_results_fmt_usages
206: WHERE attribute_code = 'PS_PARTY_SITE_NAME'
207: AND resultfmt_usage_id = c_fmt_usage_id
208: AND CUSTOMIZATION_APPLICATION_ID = G_APPLICATION_ID
209: AND rownum < 2;

Line 213: FROM ego_results_fmt_usages

209: AND rownum < 2;
210:
211: CURSOR c_ebi_col_mapping_site(c_fmt_usage_id in number) is
212: SELECT INTF_COLUMN_NAME
213: FROM ego_results_fmt_usages
214: WHERE attribute_code = 'SS_VENDOR_SITE_CODE'
215: AND resultfmt_usage_id = c_fmt_usage_id
216: AND CUSTOMIZATION_APPLICATION_ID = G_APPLICATION_ID
217: AND rownum < 2;

Line 420: FROM ego_results_fmt_usages

416: ) Is
417: --Bug 16384042 modified cursor to include data_level_id column
418: CURSOR c_user_attr_group_codes (c_resultfmt_usage_id IN NUMBER,c_attr_group_type IN VARCHAR2) IS
419: SELECT DISTINCT To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) attr_group_id,classification_code, data_level_id
420: FROM ego_results_fmt_usages
421: WHERE resultfmt_usage_id = c_resultfmt_usage_id
422: AND attribute_code LIKE '%$$%'
423: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN
424: (

Line 554: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';

550: )
551: LOOP
552: l_dyn_sql := '';
553: l_dyn_sql := ' SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2)) attr_id, intf_column_name, To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, ''$$'') - 1)) attr_group_id ';
554: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
555: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
556: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
557: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
558: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);