APPS.FND_PORTLET_DEPENDENCY_PKG dependencies on FND_PORTLET_DEPENDENCY

Line 1: package body FND_PORTLET_DEPENDENCY_PKG as

1: package body FND_PORTLET_DEPENDENCY_PKG as
2: /* $Header: FNDPRTRB.pls 120.2 2005/11/04 13:55:18 sdstratt noship $ */
3:
4: procedure INSERT_CONCURRENT_ROW (
5: X_CONCURRENT_PROGRAM_NAME in VARCHAR2,

Line 14: FND_PORTLET_DEPENDENCY_PKG.INSERT_ROW (

10: l_rowid rowid;
11:
12: begin
13:
14: FND_PORTLET_DEPENDENCY_PKG.INSERT_ROW (
15: l_rowid,
16: X_CONCURRENT_PROGRAM_NAME,
17: X_CONCURRENT_APPLICATION_CODE,
18: X_FUNCTION_NAME,

Line 36: FND_PORTLET_DEPENDENCY_PKG.DELETE_ROW (

32:
33:
34: begin
35:
36: FND_PORTLET_DEPENDENCY_PKG.DELETE_ROW (
37: X_CONCURRENT_PROGRAM_NAME,
38: X_CONCURRENT_APPLICATION_CODE,
39: X_FUNCTION_NAME);
40:

Line 54: cursor C is select ROWID from FND_PORTLET_DEPENDENCY

50: X_LAST_UPDATE_DATE in DATE,
51: X_LAST_UPDATED_BY in NUMBER,
52: X_LAST_UPDATE_LOGIN in NUMBER
53: ) is
54: cursor C is select ROWID from FND_PORTLET_DEPENDENCY
55: where REFRESH_DEPENDENCY = X_REFRESH_DEPENDENCY
56: and REFRESH_DEPENDENCY_CONTEXT = X_REFRESH_DEPENDENCY_CONTEXT
57: and FUNCTION_NAME = X_FUNCTION_NAME
58: ;

Line 61: insert into FND_PORTLET_DEPENDENCY (

57: and FUNCTION_NAME = X_FUNCTION_NAME
58: ;
59: begin
60:
61: insert into FND_PORTLET_DEPENDENCY (
62: REFRESH_DEPENDENCY,
63: REFRESH_DEPENDENCY_CONTEXT,
64: FUNCTION_NAME,
65: CREATION_DATE,

Line 82: from FND_PORTLET_DEPENDENCY D

78: X_LAST_UPDATE_LOGIN
79: FROM DUAL
80: where not exists
81: (select NULL
82: from FND_PORTLET_DEPENDENCY D
83: where D.REFRESH_DEPENDENCY = X_REFRESH_DEPENDENCY
84: and D.REFRESH_DEPENDENCY_CONTEXT = X_REFRESH_DEPENDENCY_CONTEXT
85: and D.FUNCTION_NAME = X_FUNCTION_NAME);
86:

Line 103: delete from FND_PORTLET_DEPENDENCY

99: X_REFRESH_DEPENDENCY_CONTEXT in VARCHAR2,
100: X_FUNCTION_NAME in VARCHAR2
101: ) is
102: begin
103: delete from FND_PORTLET_DEPENDENCY
104: where REFRESH_DEPENDENCY = X_REFRESH_DEPENDENCY
105: and REFRESH_DEPENDENCY_CONTEXT = X_REFRESH_DEPENDENCY_CONTEXT
106: and FUNCTION_NAME = X_FUNCTION_NAME;
107:

Line 125: from FND_PORTLET_DEPENDENCY PORT

121:
122: cursor portlet_dependency (c_REFRESH_DEPENDENCY varchar2,
123: c_REFRESH_DEPENDENCY_CONTEXT varchar2)is
124: select PORT.FUNCTION_NAME FUNCTION_NAME
125: from FND_PORTLET_DEPENDENCY PORT
126: where PORT.REFRESH_DEPENDENCY = c_REFRESH_DEPENDENCY
127: and PORT.REFRESH_DEPENDENCY_CONTEXT = c_REFRESH_DEPENDENCY_CONTEXT;
128:
129: begin

Line 169: end FND_PORTLET_DEPENDENCY_PKG;

165:
166: commit;
167: end;
168:
169: end FND_PORTLET_DEPENDENCY_PKG;