APPS.JTF_GRID_COLS_PKG dependencies on JTF_GRID_COLS_B

Line 38: cursor C is select ROWID from JTF_GRID_COLS_B

34: X_DB_SORT_COLUMN in VARCHAR2,
35: X_FIRE_POST_QUERY_FLAG in VARCHAR2,
36: X_IMAGE_DESCRIPTION_COL in VARCHAR2
37: ) is
38: cursor C is select ROWID from JTF_GRID_COLS_B
39: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
40: and GRID_COL_ALIAS = X_GRID_COL_ALIAS
41: ;
42: begin

Line 45: insert into JTF_GRID_COLS_B (

41: ;
42: begin
43: -- defaulting the query allowed flag since it is eventually going to be a not null column
44:
45: insert into JTF_GRID_COLS_B (
46: GRID_DATASOURCE_NAME,
47: GRID_COL_ALIAS,
48: DB_COL_NAME,
49: DATA_TYPE_CODE,

Line 209: from JTF_GRID_COLS_B

205: QUERY_DISPLAY_SEQ,
206: DB_SORT_COLUMN,
207: FIRE_POST_QUERY_FLAG,
208: IMAGE_DESCRIPTION_COL
209: from JTF_GRID_COLS_B
210: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
211: and GRID_COL_ALIAS = X_GRID_COL_ALIAS
212: for update of GRID_DATASOURCE_NAME nowait;
213: recinfo c%rowtype;

Line 321: update JTF_GRID_COLS_B set

317: X_FIRE_POST_QUERY_FLAG in VARCHAR2,
318: X_IMAGE_DESCRIPTION_COL in VARCHAR2
319: ) is
320: begin
321: update JTF_GRID_COLS_B set
322: DB_COL_NAME = X_DB_COL_NAME,
323: DATA_TYPE_CODE = X_DATA_TYPE_CODE,
324: QUERY_SEQ = X_QUERY_SEQ,
325: SORTABLE_FLAG = X_SORTABLE_FLAG,

Line 403: delete from JTF_GRID_COLS_B

399: delete from JTF_GRID_COLS_TL
400: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
401: and GRID_COL_ALIAS = X_GRID_COL_ALIAS;
402:
403: delete from JTF_GRID_COLS_B
404: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
405: and GRID_COL_ALIAS = X_GRID_COL_ALIAS;
406:
407: if (sql%notfound) then

Line 438: delete from JTF_GRID_COLS_B

434:
435: delete from JTF_GRID_COLS_TL
436: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
437:
438: delete from JTF_GRID_COLS_B
439: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
440:
441: if (sql%notfound) then
442: raise no_data_found;

Line 453: from JTF_GRID_COLS_B B

449: begin
450: delete from JTF_GRID_COLS_TL T
451: where not exists
452: (select NULL
453: from JTF_GRID_COLS_B B
454: where B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME
455: and B.GRID_COL_ALIAS = T.GRID_COL_ALIAS
456: );
457:

Line 571: from JTF_GRID_COLS_B

567:
568:
569: select LAST_UPDATED_BY, LAST_UPDATE_DATE
570: into db_luby, db_ludate
571: from JTF_GRID_COLS_B
572: where GRID_DATASOURCE_NAME = x_grid_datasource_name
573: AND GRID_COL_ALIAS = X_GRID_COL_ALIAS;
574:
575:

Line 579: from JTF_GRID_COLS_B

575:
576: /*
577: select 'X'
578: into dummy
579: from JTF_GRID_COLS_B
580: where GRID_DATASOURCE_NAME = x_grid_datasource_name;
581: */
582:
583: -- Test for customization and version

Line 764: delete from JTF_GRID_COLS_B

760:
761: delete from JTF_GRID_COLS_TL
762: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME ;
763:
764: delete from JTF_GRID_COLS_B
765: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME ;
766:
767: update_header(x_grid_datasource_name, x_last_updated_by, x_last_update_date);
768:

Line 811: delete from JTF_GRID_COLS_B

807: delete from JTF_GRID_COLS_TL
808: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
809: and GRID_COL_ALIAS = X_GRID_COL_ALIAS;
810:
811: delete from JTF_GRID_COLS_B
812: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
813: and GRID_COL_ALIAS = X_GRID_COL_ALIAS;
814:
815: update_header(x_grid_datasource_name, x_last_updated_by, x_last_update_date);