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.AMW_CONSTRAINT_PVT dependencies on AMW_VIOLAT_RESP_ENTRIES

Line 4829: -- AMW_Violation_RESP,AMW_VIOLAT_RESP_ENTRIES

4825: -- Wtite_Resp_Violat_to_table
4826: --
4827: -- Purpose
4828: -- Write the violating responsibility to the Table
4829: -- AMW_Violation_RESP,AMW_VIOLAT_RESP_ENTRIES
4830: --
4831: -- Params
4832: -- p_violation_id := specified violation id
4833: -- p_constraint_rev_id := specified constraint_rev_id

Line 4929: -- During this process we populate 2 tables AMW_VIOLATION_RESP,AMW_VIOLAT_RESP_ENTRIES

4925: -- If the Object type = ME, we check if the responsibility have access to atleast
4926: -- 2 incompatible function
4927: -- If the Object type = Set, we check if the responsibility have access to atleast
4928: -- 1 incompatible function from each group
4929: -- During this process we populate 2 tables AMW_VIOLATION_RESP,AMW_VIOLAT_RESP_ENTRIES
4930: -- We put responibility specific details in AMW_VIOLATION_RESP and
4931: -- the functions accessible to a responsibility in AMW_VIOLAT_RESP_ENTRIES
4932: listkey :=G_RESP_VIOLATIONS_LIST.FIRST;
4933: WHILE listkey IS NOT NULL

Line 4931: -- the functions accessible to a responsibility in AMW_VIOLAT_RESP_ENTRIES

4927: -- If the Object type = Set, we check if the responsibility have access to atleast
4928: -- 1 incompatible function from each group
4929: -- During this process we populate 2 tables AMW_VIOLATION_RESP,AMW_VIOLAT_RESP_ENTRIES
4930: -- We put responibility specific details in AMW_VIOLATION_RESP and
4931: -- the functions accessible to a responsibility in AMW_VIOLAT_RESP_ENTRIES
4932: listkey :=G_RESP_VIOLATIONS_LIST.FIRST;
4933: WHILE listkey IS NOT NULL
4934: LOOP
4935: L_RESPVIO_ENTRIES.DELETE();

Line 5008: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(

5004: FND_FILE.put_line(fnd_file.log,' OBJECT_TYPE :'||L_RESPVIO_ENTRIES(k).Object_type);
5005: FND_FILE.put_line(fnd_file.log,' APPLICATION_ID :'||L_RESPVIO_ENTRIES(k).prog_appl_id);
5006: FND_FILE.put_line(fnd_file.log,' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~'); */
5007:
5008: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(
5009: VIOLAT_RESP_ENTRY_ID,
5010: RESP_VIOLATION_ID,
5011: MENU_ID,
5012: FUNCTION_ID,

Line 5025: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,

5021: SECURITY_GROUP_ID,
5022: APPLICATION_ID
5023: )
5024: VALUES(
5025: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,
5026: l_resp_violation_id,
5027: L_RESPVIO_ENTRIES(k).Menu_Id,
5028: L_RESPVIO_ENTRIES(k).Function_id,
5029: L_RESPVIO_ENTRIES(k).Access_Given_Date,

Line 5115: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(

5111: FND_FILE.put_line(fnd_file.log,' OBJECT_TYPE :'||L_RESPVIO_ENTRIES(k).Object_type);
5112: FND_FILE.put_line(fnd_file.log,' APPLICATION_ID :'||L_RESPVIO_ENTRIES(k).prog_appl_id);
5113: FND_FILE.put_line(fnd_file.log,' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~'); */
5114:
5115: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(
5116: VIOLAT_RESP_ENTRY_ID,
5117: resp_violation_id,
5118: MENU_ID,
5119: FUNCTION_ID,

Line 5132: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,

5128: SECURITY_GROUP_ID,
5129: APPLICATION_ID
5130: )
5131: VALUES(
5132: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,
5133: l_resp_violation_id,
5134: L_RESPVIO_ENTRIES(k).Menu_Id,
5135: L_RESPVIO_ENTRIES(k).Function_id,
5136: L_RESPVIO_ENTRIES(k).Access_Given_Date,

Line 5237: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(

5233: FND_FILE.put_line(fnd_file.log,' OBJECT_TYPE :'||L_RESPVIO_ENTRIES(k).Object_type);
5234: FND_FILE.put_line(fnd_file.log,' APPLICATION_ID :'||L_RESPVIO_ENTRIES(k).prog_appl_id);
5235: FND_FILE.put_line(fnd_file.log,' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');*/
5236:
5237: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(
5238: VIOLAT_RESP_ENTRY_ID,
5239: RESP_VIOLATION_ID,
5240: MENU_ID,
5241: FUNCTION_ID,

Line 5254: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,

5250: SECURITY_GROUP_ID,
5251: APPLICATION_ID
5252: )
5253: VALUES(
5254: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,
5255: l_resp_violation_id,
5256: L_RESPVIO_ENTRIES(k).Menu_Id,
5257: L_RESPVIO_ENTRIES(k).Function_id,
5258: L_RESPVIO_ENTRIES(k).Access_Given_Date,

Line 5287: -- AMW_Violation_RESP,AMW_VIOLAT_RESP_ENTRIES

5283: -- Wtite_Resp_Violat_to_table_rvl
5284: --
5285: -- Purpose
5286: -- revalidates the violating responsibility to the Table
5287: -- AMW_Violation_RESP,AMW_VIOLAT_RESP_ENTRIES
5288: --
5289: -- Params
5290: -- p_violation_id := specified violation id
5291: -- p_constraint_rev_id := specified constraint_rev_id

Line 5372: -- responsibilities in AMW_VIOLAT_RESP_ENTRIES

5368: -- If No,
5369: -- Set the CORRECTED_FLAG= 'Y' for the responsibility
5370: -- If Yes,
5371: -- Populate the incompatible functions accessible to
5372: -- responsibilities in AMW_VIOLAT_RESP_ENTRIES
5373: -- If No,
5374: -- Set the CORRECTED_FLAG= 'Y' for the responsibility
5375: IF (G_RESP_VIOLATIONS_LIST.COUNT = 0) THEN
5376:

Line 5381: DELETE FROM AMW_VIOLAT_RESP_ENTRIES

5377: UPDATE AMW_VIOLATION_RESP
5378: SET CORRECTED_FLAG ='Y'
5379: WHERE VIOLATION_ID=p_violation_id;
5380:
5381: DELETE FROM AMW_VIOLAT_RESP_ENTRIES
5382: WHERE RESP_VIOLATION_ID IN (SELECT RESP_VIOLATION_ID FROM AMW_VIOLATION_RESP WHERE VIOLATION_ID=p_violation_id);
5383:
5384: RETURN;
5385: ELSE

Line 5424: DELETE FROM AMW_VIOLAT_RESP_ENTRIES

5420: LOOP
5421: listkey:=L_EXISTING_APPL_ID_LIST(i)||'@'||L_EXISTING_RESP_ID_LIST(i);
5422: IF G_RESP_VIOLATIONS_LIST.EXISTS(listkey) THEN
5423:
5424: DELETE FROM AMW_VIOLAT_RESP_ENTRIES
5425: WHERE RESP_VIOLATION_ID =L_EXISTING_RESP_VIO_ID_LIST(i);
5426:
5427: IF (l_waived_resp_appl_list.exists(listkey)) THEN
5428: UPDATE AMW_VIOLATION_RESP

Line 5446: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(

5442: IF L_FUNC_ID_LIST.EXISTS(j) THEN
5443: L_RESPVIO_ENTRIES:=L_FUNC_ID_LIST(j);
5444: FOR k IN L_RESPVIO_ENTRIES.FIRST .. L_RESPVIO_ENTRIES.LAST
5445: LOOP
5446: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(
5447: VIOLAT_RESP_ENTRY_ID,
5448: RESP_VIOLATION_ID,
5449: MENU_ID,
5450: FUNCTION_ID,

Line 5463: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,

5459: SECURITY_GROUP_ID,
5460: APPLICATION_ID
5461: )
5462: VALUES(
5463: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,
5464: L_EXISTING_RESP_VIO_ID_LIST(i),
5465: L_RESPVIO_ENTRIES(k).Menu_Id,
5466: L_RESPVIO_ENTRIES(k).Function_id,
5467: L_RESPVIO_ENTRIES(k).Access_Given_Date,

Line 5489: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(

5485: L_RESPVIO_ENTRIES:=L_FUNC_ID_LIST(j);
5486: FOR k IN L_RESPVIO_ENTRIES.FIRST .. L_RESPVIO_ENTRIES.LAST
5487: LOOP
5488:
5489: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(
5490: VIOLAT_RESP_ENTRY_ID,
5491: resp_violation_id,
5492: MENU_ID,
5493: FUNCTION_ID,

Line 5506: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,

5502: SECURITY_GROUP_ID,
5503: APPLICATION_ID
5504: )
5505: VALUES(
5506: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,
5507: L_EXISTING_RESP_VIO_ID_LIST(i),
5508: L_RESPVIO_ENTRIES(k).Menu_Id,
5509: L_RESPVIO_ENTRIES(k).Function_id,
5510: L_RESPVIO_ENTRIES(k).Access_Given_Date,

Line 5550: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(

5546: IF L_FUNC_ID_LIST.EXISTS(j) then
5547: L_RESPVIO_ENTRIES:=L_FUNC_ID_LIST(j);
5548: FOR k IN L_RESPVIO_ENTRIES.FIRST .. L_RESPVIO_ENTRIES.LAST
5549: LOOP
5550: INSERT INTO AMW_VIOLAT_RESP_ENTRIES(
5551: VIOLAT_RESP_ENTRY_ID,
5552: RESP_VIOLATION_ID,
5553: MENU_ID,
5554: FUNCTION_ID,

Line 5567: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,

5563: SECURITY_GROUP_ID,
5564: APPLICATION_ID
5565: )
5566: VALUES(
5567: AMW_VIOLAT_RESP_ENTRIES_S.NEXTVAL,
5568: L_EXISTING_RESP_VIO_ID_LIST(i),
5569: L_RESPVIO_ENTRIES(k).Menu_Id,
5570: L_RESPVIO_ENTRIES(k).Function_id,
5571: L_RESPVIO_ENTRIES(k).Access_Given_Date,

Line 7464: -- 12.14.2006 psomanat Added delete statements for amw_violation_resp and amw_violat_resp_entries

7460: -- constraint violations created before the specified date. deleted.
7461: --
7462: -- History
7463: -- 12.01.2005 tsho create (related to customer requirement: bug 4673154)
7464: -- 12.14.2006 psomanat Added delete statements for amw_violation_resp and amw_violat_resp_entries
7465: -- 03.14.2007 psomanat Added parameter p_delopt
7466: -- ===============================================================
7467: PROCEDURE Purge_Violation_Before_Date (
7468: errbuf OUT NOCOPY VARCHAR2,

Line 7489: DELETE FROM amw_violat_resp_entries

7485: FND_FILE.put_line(fnd_file.log,'will delete violation history prior(<) to : '||l_date);
7486:
7487: FND_FILE.put_line(fnd_file.log,'Delete Constraint Violation Start');
7488: IF p_delopt = 'ALLCSTVIO' THEN
7489: DELETE FROM amw_violat_resp_entries
7490: WHERE creation_date < l_date;
7491:
7492: DELETE FROM amw_violation_resp
7493: WHERE creation_date < l_date;

Line 7506: DELETE FROM amw_violat_resp_entries

7502: WHERE creation_date < l_date;
7503:
7504: ELSE
7505:
7506: DELETE FROM amw_violat_resp_entries
7507: WHERE resp_violation_id IN (
7508: SELECT resp_violation_id
7509: FROM amw_violation_resp
7510: WHERE violation_id IN (