APPS.FA_RX_REP_COLUMNS_PKG dependencies on FA_RX_REP_COLUMNS_B

Line 27: cursor C is select ROWID from FA_RX_REP_COLUMNS_B

23: X_LAST_UPDATE_DATE in DATE,
24: X_LAST_UPDATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER
26: ) is
27: cursor C is select ROWID from FA_RX_REP_COLUMNS_B
28: where REPORT_ID = X_REPORT_ID
29: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
30: and COLUMN_NAME = X_COLUMN_NAME
31: ;

Line 33: insert into FA_RX_REP_COLUMNS_B (

29: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
30: and COLUMN_NAME = X_COLUMN_NAME
31: ;
32: begin
33: insert into FA_RX_REP_COLUMNS_B (
34: CURRENCY_COLUMN,
35: PRECISION,
36: BREAK_GROUP_LEVEL,
37: MINIMUM_ACCOUNTABLE_UNIT,

Line 152: from FA_RX_REP_COLUMNS_B

148: DISPLAY_FORMAT,
149: DISPLAY_STATUS,
150: BREAK,
151: ATTRIBUTE_COUNTER
152: from FA_RX_REP_COLUMNS_B
153: where REPORT_ID = X_REPORT_ID
154: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
155: and COLUMN_NAME = X_COLUMN_NAME
156: for update of REPORT_ID nowait;

Line 243: update FA_RX_REP_COLUMNS_B set

239: X_LAST_UPDATED_BY in NUMBER,
240: X_LAST_UPDATE_LOGIN in NUMBER
241: ) is
242: begin
243: update FA_RX_REP_COLUMNS_B set
244: CURRENCY_COLUMN = X_CURRENCY_COLUMN,
245: PRECISION = X_PRECISION,
246: BREAK_GROUP_LEVEL = X_BREAK_GROUP_LEVEL,
247: MINIMUM_ACCOUNTABLE_UNIT = X_MINIMUM_ACCOUNTABLE_UNIT,

Line 298: delete from FA_RX_REP_COLUMNS_B

294: if (sql%notfound) then
295: raise no_data_found;
296: end if;
297:
298: delete from FA_RX_REP_COLUMNS_B
299: where REPORT_ID = X_REPORT_ID
300: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
301: and COLUMN_NAME = X_COLUMN_NAME;
302:

Line 314: from FA_RX_REP_COLUMNS_B B

310: begin
311: delete from FA_RX_REP_COLUMNS_TL T
312: where not exists
313: (select NULL
314: from FA_RX_REP_COLUMNS_B B
315: where B.REPORT_ID = T.REPORT_ID
316: and B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
317: and B.COLUMN_NAME = T.COLUMN_NAME
318: );

Line 475: from fa_rx_rep_columns_b

471: f_ludate := nvl(to_date(X_Last_Update_Date, 'YYYY/MM/DD HH24:MI:SS'), sysdate);
472:
473: select LAST_UPDATED_BY, LAST_UPDATE_DATE
474: into db_luby, db_ludate
475: from fa_rx_rep_columns_b
476: where report_id = X_Report_Id
477: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
478: and column_name = X_Column_Name;
479:

Line 630: FROM fa_rx_rep_columns_b

626: attribute_counter,
627: last_update_date,
628: last_updated_by,
629: last_update_login
630: FROM fa_rx_rep_columns_b
631: WHERE
632: report_id = X_REPORT_ID AND
633: attribute_set = X_ATTRIBUTE_SET AND
634: display_status = 'YES'

Line 649: UPDATE fa_rx_rep_columns_b SET

645: prev_break_level <> crow.break_group_level) THEN
646: curr_break_level := curr_break_level + 1;
647: END IF;
648:
649: UPDATE fa_rx_rep_columns_b SET
650: break = crow.break,
651: break_group_level = curr_break_level,
652: attribute_counter = curr_attribute_counter,
653: last_update_date = X_LAST_UPDATE_DATE,