DBA Data[Home] [Help]

APPS.BIS_RESPONSIBILITY_PUB dependencies on FND_RESPONSIBILITY

Line 14: REM | insert records in the FND Responsibility table |

10: REM | PACKAGE |
11: REM | BIS_RESPONSIBILITY_PUB |
12: REM | DESCRIPTION |
13: REM | Module: Private package that calls the FND packages to |
14: REM | insert records in the FND Responsibility table |
15: REM | |
16: REM | NOTES |
17: REM | 07-MAR-2005 KRISHNA Created. |
18: REM +=======================================================================+

Line 45: FROM fnd_responsibility_vl

41: version ,
42: responsibility_key ,
43: responsibility_name,
44: description
45: FROM fnd_responsibility_vl
46: WHERE application_id = p_application_id
47: AND responsibility_id = p_responsibility_id;
48:
49: BEGIN

Line 71: FND_RESPONSIBILITY_PKG.UPDATE_ROW(

67: l_responsibility_rec.responsibility_name,
68: l_responsibility_rec.description;
69: CLOSE cResponsibility;
70: --dbms_output.put_line( 'just before calling update row is');
71: FND_RESPONSIBILITY_PKG.UPDATE_ROW(
72: X_RESPONSIBILITY_ID => p_responsibility_id
73: , X_APPLICATION_ID => p_application_id
74: , X_WEB_HOST_NAME => l_responsibility_rec.web_host_name
75: , X_WEB_AGENT_NAME => l_responsibility_rec.web_agent_name

Line 143: FROM fnd_responsibility

139: l_last_update_date DATE;
140:
141: CURSOR cResponsibility IS
142: SELECT last_update_date
143: FROM fnd_responsibility
144: WHERE responsibility_id = p_responsibility_id
145: AND application_id = p_application_id
146: FOR UPDATE OF menu_id NOWAIT;
147: