APPS.FA_RX_ATTRSETS_PKG dependencies on FA_RX_ATTRSETS_B

Line 30: cursor C is select ROWID from FA_RX_ATTRSETS_B

26: X_LAST_UPDATE_DATE in DATE,
27: X_LAST_UPDATED_BY in NUMBER,
28: X_LAST_UPDATE_LOGIN in NUMBER
29: ) is
30: cursor C is select ROWID from FA_RX_ATTRSETS_B
31: where REPORT_ID = X_REPORT_ID
32: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
33: ;
34: begin

Line 35: insert into FA_RX_ATTRSETS_B (

31: where REPORT_ID = X_REPORT_ID
32: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
33: ;
34: begin
35: insert into FA_RX_ATTRSETS_B (
36: PAGE_WIDTH,
37: PAGE_HEIGHT,
38: PRINT_SOB_FLAG,
39: PRINT_FUNC_CURR_FLAG,

Line 163: from FA_RX_ATTRSETS_B

159: PUBLIC_FLAG,
160: SYSTEM_FLAG,
161: DEFAULT_DATE_FORMAT,
162: DEFAULT_DATE_TIME_FORMAT
163: from FA_RX_ATTRSETS_B
164: where REPORT_ID = X_REPORT_ID
165: and ATTRIBUTE_SET = X_ATTRIBUTE_SET
166: for update of REPORT_ID nowait;
167: recinfo c%rowtype;

Line 268: update FA_RX_ATTRSETS_B set

264: X_LAST_UPDATED_BY in NUMBER,
265: X_LAST_UPDATE_LOGIN in NUMBER
266: ) is
267: begin
268: update FA_RX_ATTRSETS_B set
269: PAGE_WIDTH = X_PAGE_WIDTH,
270: PAGE_HEIGHT = X_PAGE_HEIGHT,
271: PRINT_SOB_FLAG = X_PRINT_SOB_FLAG,
272: PRINT_FUNC_CURR_FLAG = X_PRINT_FUNC_CURR_FLAG,

Line 323: delete from FA_RX_ATTRSETS_B

319: if (sql%notfound) then
320: raise no_data_found;
321: end if;
322:
323: delete from FA_RX_ATTRSETS_B
324: where REPORT_ID = X_REPORT_ID
325: and ATTRIBUTE_SET = X_ATTRIBUTE_SET;
326:
327: if (sql%notfound) then

Line 338: from FA_RX_ATTRSETS_B B

334: begin
335: delete from FA_RX_ATTRSETS_TL T
336: where not exists
337: (select NULL
338: from FA_RX_ATTRSETS_B B
339: where B.REPORT_ID = T.REPORT_ID
340: and B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
341: );
342:

Line 510: from fa_rx_attrsets_b

506: f_ludate := nvl(to_date(X_Last_Update_Date, 'YYYY/MM/DD HH24:MI:SS'), sysdate);
507:
508: select LAST_UPDATED_BY, LAST_UPDATE_DATE
509: into db_luby, db_ludate
510: from fa_rx_attrsets_b
511: where report_id = X_Report_Id
512: and ATTRIBUTE_SET = X_ATTRIBUTE_SET;
513:
514: Begin