DBA Data[Home] [Help]

PACKAGE: APPS.FRM_REPOSITORY_MAINTENANCE

Source


1 PACKAGE FRM_REPOSITORY_MAINTENANCE AUTHID CURRENT_USER AS
2 /* $Header: frmrepmaintenances.pls 120.2 2010/12/08 09:37:13 rgurusam noship $ */
3 
4 --------------------------------------------------------------------------------
5 --  PROCEDURE:        DELETE_MENU_ENTRIES                     		      --
6 --                                                                            --
7 --  DESCRIPTION:      Procedure to delete menu entries	 		      --
8 --                                                                            --
9 --  MODIFICATION HISTORY                                                      --
10 --  Date         Username  Description                                        --
11 --  19-APR-2010  DHVENKAT  CREATED                                            --
12 --  29-Nov-2010  RGURUSAM  Bug 8333050 - Support to overwrite existing reports--
13 --                         Introduced PL/SQL Procedure DELETE_DOCUMENT_TIMEFRAME
14 --                         to delete a report of a time frame from document   --
15 --------------------------------------------------------------------------------
16 PROCEDURE DELETE_MENU_ENTRIES(P_MENU_ID   IN NUMBER,
17         		    P_ENTRY_SEQ   IN NUMBER);
18 
19 
20 --------------------------------------------------------------------------------
21 --  PROCEDURE:        DELETE_FORM_ENTRIES                     		      --
22 --                                                                            --
23 --  DESCRIPTION:      Procedure to delete menu entries	 		      --
24 --                                                                            --
25 --  MODIFICATION HISTORY                                                      --
26 --  Date         Username  Description                                        --
27 --  19-APR-2010  DHVENKAT  CREATED                                            --
28 --------------------------------------------------------------------------------
29 PROCEDURE DELETE_FORM_ENTRIES(P_FUNC_ID   IN NUMBER);
30 
31 
32 --------------------------------------------------------------------------------
33 --  PROCEDURE:        DELETE_MENUFORM_ENTRIES         	                      --
34 --                                                                            --
35 --  DESCRIPTION:      Procedure to delete form entries 			      --
36 --                                                                            --
37 --  MODIFICATION HISTORY                                                      --
38 --  Date         Username  Description                                        --
39 --  19-APR-2010  DHVENKAT  CREATED                                            --
40 --------------------------------------------------------------------------------
41 PROCEDURE DELETE_MENUFORM_ENTRIES(P_DOCUMENT_ID IN NUMBER);
42 
43 
44 --------------------------------------------------------------------------------
45 --  PROCEDURE:           DELETE_MARKED_ENTRIES                                --
46 --                                                                            --
47 --  DESCRIPTION:         Delete all rows marked for delete		      --
48 --                                                                            --
49 --  MODIFICATION HISTORY                                                      --
50 --  Date         Username  Description                                        --
51 --  19-APR-2010  DHVENKAT  CREATED                                            --
52 --------------------------------------------------------------------------------
53 PROCEDURE DELETE_MARKED_ENTRIES(P_USER_ID IN NUMBER);
54 
55 --------------------------------------------------------------------------------
56 --  PROCEDURE:           DELETE_DOCUMENT_TIMEFRAME                            --
57 --                                                                            --
58 --  DESCRIPTION:         Delete the report for timeframe in the document      --
59 --                       This procedure is used to replace a report for       --
60 --                       timeframe in the document when publishing            --
61 --                       with a report with replace option.                   --
62 --                       It retains the form functions created, menu entries  --
63 --                       as they will be used to access the newly created     --
64 --                       document.                                            --
65 --                                                                            --
66 --  MODIFICATION HISTORY                                                      --
67 --  Date         Username  Description                                        --
68 --  26-NOV-2010  RGURUSAM  CREATED                                            --
69 --------------------------------------------------------------------------------
70 PROCEDURE DELETE_DOCUMENT_TIMEFRAME(P_DOCUMENT_ID IN NUMBER, P_TIMEFRAME IN VARCHAR2);
71 
72 END FRM_REPOSITORY_MAINTENANCE;