DBA Data[Home] [Help]

APPS.JTF_GRID_COLS_PKG dependencies on JTF_CUSTOM_GRID_COLS

Line 380: grid_id JTF_CUSTOM_GRID_COLS.custom_grid_id%TYPE;

376: procedure DELETE_ROW (
377: X_GRID_DATASOURCE_NAME in VARCHAR2,
378: X_GRID_COL_ALIAS in VARCHAR2
379: ) is
380: grid_id JTF_CUSTOM_GRID_COLS.custom_grid_id%TYPE;
381: WasError Boolean :=False;
382: begin
383: --null;
384: Begin

Line 386: JTF_CUSTOM_GRID_COLS where grid_datasource_name=X_GRID_DATASOURCE_NAME;

382: begin
383: --null;
384: Begin
385: select custom_grid_id into grid_id from
386: JTF_CUSTOM_GRID_COLS where grid_datasource_name=X_GRID_DATASOURCE_NAME;
387: Exception
388: When Others then
389: WasError:=True;
390: End;

Line 393: delete from JTF_CUSTOM_GRID_COLS

389: WasError:=True;
390: End;
391:
392: If Not WasError Then
393: delete from JTF_CUSTOM_GRID_COLS
394: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
395: and GRID_COL_ALIAS = X_GRID_COL_ALIAS
396: and custom_grid_id=grid_id;
397: End If;

Line 416: grid_id JTF_CUSTOM_GRID_COLS.custom_grid_id%TYPE;

412: procedure DELETE_ALL_ROWS (
413: X_GRID_DATASOURCE_NAME in VARCHAR2
414: ) is
415:
416: grid_id JTF_CUSTOM_GRID_COLS.custom_grid_id%TYPE;
417: wasError Boolean :=False;
418: begin
419: -- null;
420:

Line 423: JTF_CUSTOM_GRID_COLS where grid_datasource_name=X_GRID_DATASOURCE_NAME;

419: -- null;
420:
421: Begin
422: SELECT CUSTOM_GRID_ID INTO GRID_ID FROM
423: JTF_CUSTOM_GRID_COLS where grid_datasource_name=X_GRID_DATASOURCE_NAME;
424: Exception
425: When Others Then
426: WasError:=True;
427: End;

Line 430: delete from JTF_CUSTOM_GRID_COLS

426: WasError:=True;
427: End;
428:
429: If Not WasError then
430: delete from JTF_CUSTOM_GRID_COLS
431: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
432: and CUSTOM_GRID_ID=GRID_ID;
433: End If;
434:

Line 743: grid_id JTF_CUSTOM_GRID_COLS.custom_grid_id%TYPE;

739: X_GRID_DATASOURCE_NAME in VARCHAR2,
740: X_LAST_UPDATED_BY in number,
741: X_LAST_UPDATE_DATE in date
742: ) is
743: grid_id JTF_CUSTOM_GRID_COLS.custom_grid_id%TYPE;
744: WasError boolean :=False;
745: begin
746:
747: begin

Line 749: JTF_CUSTOM_GRID_COLS where grid_datasource_name=X_GRID_DATASOURCE_NAME;

745: begin
746:
747: begin
748: select custom_grid_id into grid_id from
749: JTF_CUSTOM_GRID_COLS where grid_datasource_name=X_GRID_DATASOURCE_NAME;
750: exception
751: when others then
752: wasError:=True;
753: end;

Line 756: delete from JTF_CUSTOM_GRID_COLS

752: wasError:=True;
753: end;
754:
755: if Not WasError then
756: delete from JTF_CUSTOM_GRID_COLS
757: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
758: and custom_grid_id=grid_id;
759: end If;
760:

Line 803: delete from JTF_CUSTOM_GRID_COLS

799: X_LAST_UPDATE_DATE in date
800: --X_CUSTOM_MODE in VARCHAR2 := 'FORCE'
801: ) is
802: begin
803: delete from JTF_CUSTOM_GRID_COLS
804: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
805: and GRID_COL_ALIAS = X_GRID_COL_ALIAS;
806:
807: delete from JTF_GRID_COLS_TL