APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_MAPPING_LINES

Line 159: FROM BNE_MAPPING_LINES

155: ,APPLICATION_ID
156: ,MAPPING_CODE
157: ,CONTENT_APP_ID
158: ,DECODE_FLAG
159: FROM BNE_MAPPING_LINES
160: WHERE application_id = p_application_id
161: AND MAPPING_CODE = c_mapping_code;
162:
163: l_temp_interface_seq_num BNE_MAPPING_LINES.INTERFACE_SEQ_NUM%TYPE;

Line 163: l_temp_interface_seq_num BNE_MAPPING_LINES.INTERFACE_SEQ_NUM%TYPE;

159: FROM BNE_MAPPING_LINES
160: WHERE application_id = p_application_id
161: AND MAPPING_CODE = c_mapping_code;
162:
163: l_temp_interface_seq_num BNE_MAPPING_LINES.INTERFACE_SEQ_NUM%TYPE;
164: l_mapping_cols_row c_mapping_cols_row%ROWTYPE;
165: l_rowid VARCHAR2(100);
166: l_mapping_code VARCHAR2(50);
167:

Line 206: BNE_MAPPING_LINES_PKG.INSERT_ROW

202: --in mapping to download the data
203: or l_temp_interface_seq_num between 223 and 252 --$ To include Soft Coded Kff Segments
204:
205: THEN
206: BNE_MAPPING_LINES_PKG.INSERT_ROW
207: (x_rowid => l_rowid
208: ,x_application_id => p_application_id
209: ,X_MAPPING_CODE => p_new_mapping_code
210: ,X_INTERFACE_APP_ID => l_mapping_cols_row.INTERFACE_APP_ID

Line 227: BNE_MAPPING_LINES_PKG.INSERT_ROW

223: ,X_LAST_UPDATE_LOGIN => l_mapping_cols_row.CREATED_BY);
224: END IF;
225: ELSE
226: IF g_riw_data.EXISTS(l_temp_interface_seq_num) THEN
227: BNE_MAPPING_LINES_PKG.INSERT_ROW
228: (x_rowid => l_rowid
229: ,x_application_id => p_application_id
230: ,X_MAPPING_CODE => p_new_mapping_code
231: ,X_INTERFACE_APP_ID => l_mapping_cols_row.INTERFACE_APP_ID

Line 1674: FROM BNE_MAPPING_LINES

1670: P_APPLICATION_ID => p_application_id);
1671:
1672: --$ COMMENT MANUAL DELETION STEPS
1673: /* DELETE
1674: FROM BNE_MAPPING_LINES
1675: WHERE APPLICATION_ID = P_APPLICATION_ID
1676: AND MAPPING_CODE = p_MAPPING_CODE
1677: AND INTERFACE_CODE =p_INTERFACE_CODE;
1678: