eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_RESPONSIBILITY_PVT dependencies on BIS_RESPONSIBILITY_PVT

Line 1: PACKAGE BODY BIS_RESPONSIBILITY_PVT AS

1: PACKAGE BODY BIS_RESPONSIBILITY_PVT AS
2: /* $Header: BISVRSPB.pls 120.1 2006/04/10 07:57:30 psomesul noship $ */
3: --
4: /*
5: REM +=======================================================================+

Line 27: G_PKG_NAME CONSTANT varchar2(30) := 'BIS_RESPONSIBILITY_PVT';

23: */
24: --
25: -- PROCEDUREs
26: --
27: G_PKG_NAME CONSTANT varchar2(30) := 'BIS_RESPONSIBILITY_PVT';
28:
29:
30: Procedure Retrieve_User_Responsibilities
31: ( p_api_version IN NUMBER

Line 33: , x_Responsibility_Tbl OUT NOCOPY BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type

29:
30: Procedure Retrieve_User_Responsibilities
31: ( p_api_version IN NUMBER
32: , p_user_id IN NUMBER Default BIS_COMMON_UTILS.G_DEF_NUM
33: , x_Responsibility_Tbl OUT NOCOPY BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type
34: , x_return_status OUT NOCOPY VARCHAR2
35: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_tbl_Type
36: )
37: IS

Line 53: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;

49: and (a.end_date is null or a.end_date >= sysdate)
50: and a.version = 'W'
51: order by responsibility_name;
52:
53: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;
54:
55: BEGIN
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:

Line 90: , x_Responsibility_Tbl OUT NOCOPY BIS_Responsibility_PVT.Responsibility_Tbl_Type

86: Procedure Retrieve_User_Responsibilities
87: ( p_api_version IN NUMBER
88: , p_user_id IN NUMBER Default BIS_COMMON_UTILS.G_DEF_NUM
89: , p_Responsibility_version IN VARCHAR
90: , x_Responsibility_Tbl OUT NOCOPY BIS_Responsibility_PVT.Responsibility_Tbl_Type
91: , x_return_status OUT NOCOPY VARCHAR2
92: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_tbl_Type
93: )
94: IS

Line 110: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;

106: and (a.end_date is null or a.end_date >= sysdate)
107: and a.version like p_version
108: order by responsibility_name;
109:
110: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;
111: l_version VARCHAR2(1);
112:
113: BEGIN
114: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 151: , x_Responsibility_Tbl OUT NOCOPY BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type

147: END Retrieve_User_Responsibilities;
148: --
149: Procedure Retrieve_All_Responsibilities
150: ( p_api_version IN NUMBER
151: , x_Responsibility_Tbl OUT NOCOPY BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type
152: , x_return_status OUT NOCOPY VARCHAR2
153: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_tbl_Type
154: )
155: IS

Line 165: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;

161: where VERSION='W'
162: and start_date <= sysdate
163: and nvl(end_date, sysdate) >= sysdate
164: order by RESPONSIBILITY_NAME;
165: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;
166: BEGIN
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: for cr in resp_cur LOOP

Line 198: , p_Responsibility_Rec IN BIS_Responsibility_PVT.Responsibility_rec_Type

194: END Retrieve_All_Responsibilities;
195: --
196: Procedure Retrieve_Responsibility
197: ( p_api_version IN NUMBER
198: , p_Responsibility_Rec IN BIS_Responsibility_PVT.Responsibility_rec_Type
199: , x_Responsibility_Rec OUT NOCOPY BIS_Responsibility_PVT.Responsibility_rec_Type
200: , x_return_status OUT NOCOPY VARCHAR2
201: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_tbl_Type
202: )

Line 199: , x_Responsibility_Rec OUT NOCOPY BIS_Responsibility_PVT.Responsibility_rec_Type

195: --
196: Procedure Retrieve_Responsibility
197: ( p_api_version IN NUMBER
198: , p_Responsibility_Rec IN BIS_Responsibility_PVT.Responsibility_rec_Type
199: , x_Responsibility_Rec OUT NOCOPY BIS_Responsibility_PVT.Responsibility_rec_Type
200: , x_return_status OUT NOCOPY VARCHAR2
201: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_tbl_Type
202: )
203: IS

Line 426: ( p_security in BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type

422: --
423: -- removes the responsibilities from p_all_security
424: -- which are in p_security
425: PROCEDURE RemoveDuplicates
426: ( p_security in BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
427: , p_all_security in BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
428: , x_all_security out NOCOPY BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
429: )
430: is

Line 427: , p_all_security in BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type

423: -- removes the responsibilities from p_all_security
424: -- which are in p_security
425: PROCEDURE RemoveDuplicates
426: ( p_security in BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
427: , p_all_security in BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
428: , x_all_security out NOCOPY BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
429: )
430: is
431: l_unique BOOLEAN;

Line 428: , x_all_security out NOCOPY BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type

424: -- which are in p_security
425: PROCEDURE RemoveDuplicates
426: ( p_security in BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
427: , p_all_security in BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
428: , x_all_security out NOCOPY BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
429: )
430: is
431: l_unique BOOLEAN;
432: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;

Line 432: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;

428: , x_all_security out NOCOPY BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_type
429: )
430: is
431: l_unique BOOLEAN;
432: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;
433: begin
434: --
435: for i in 1 .. p_all_security.count loop
436: l_rec := p_all_security(i);

Line 456: IN BIS_Responsibility_PVT.Notify_Responsibility_Rec_type

452: end RemoveDuplicates;
453: --
454: Procedure Get_Notify_Resp_AK_Info
455: ( p_notify_responsibility_rec
456: IN BIS_Responsibility_PVT.Notify_Responsibility_Rec_type
457: , x_attribute_app_id OUT NOCOPY NUMBER
458: , x_attribute_code OUT NOCOPY VARCHAR2
459: , x_attribute_name OUT NOCOPY VARCHAR2
460: , x_region_app_id OUT NOCOPY NUMBER

Line 466: BIS_Responsibility_PVT.Notify_Responsibility_Rec_type;

462: )
463: IS
464:
465: l_notify_responsibility_rec
466: BIS_Responsibility_PVT.Notify_Responsibility_Rec_type;
467: l_attribute_app_id NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID;
468: l_attribute_code VARCHAR2(32000);
469: l_attribute_name VARCHAR2(32000);
470: l_region_app_id NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID;

Line 518: END BIS_RESPONSIBILITY_PVT;

514:
515: END Get_Notify_Resp_AK_Info;
516:
517: --
518: END BIS_RESPONSIBILITY_PVT;