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.

[Home] [Help]

APPS.AMW_CONSTRAINT_PVT dependencies on AMW_VIOLATION_RESP

Line 2996: FROM amw_violation_resp

2992: AND (corrected_flag is NULL OR corrected_flag <> 'Y');
2993:
2994: CURSOR c_resp_violation_num (l_violation_id IN NUMBER) IS
2995: SELECT count(*)
2996: FROM amw_violation_resp
2997: WHERE violation_id = l_violation_id
2998: AND waived_flag = 'N'
2999: AND corrected_flag = 'N';
3000:

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 4853: SELECT AMW_VIOLATION_RESP_S.NEXTVAL

4849: FROM amw_constraint_entries
4850: WHERE constraint_rev_id=l_constraint_rev_id;
4851:
4852: CURSOR c_resp_violation_id IS
4853: SELECT AMW_VIOLATION_RESP_S.NEXTVAL
4854: FROM dual;
4855:
4856: CURSOR c_resp_waived (l_constraint_rev_id IN NUMBER) IS
4857: SELECT PK1,PK2

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 4930: -- We put responibility specific details in AMW_VIOLATION_RESP and

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
4934: LOOP

Line 4959: INSERT INTO AMW_VIOLATION_RESP(

4955: FND_FILE.put_line(fnd_file.log,' RESPONSIBILITY_ID :'||L_RESPVIO_ENTRIES(1).Responsibility_id);
4956: FND_FILE.put_line(fnd_file.log,' APPLICATION_ID :'||L_RESPVIO_ENTRIES(1).application_id);
4957: FND_FILE.put_line(fnd_file.log,' WAIVED_FLAG :'||l_is_resp_waived);
4958: FND_FILE.put_line(fnd_file.log,' CORRECTED_FLAG :'||'N');*/
4959: INSERT INTO AMW_VIOLATION_RESP(
4960: RESP_VIOLATION_ID,
4961: VIOLATION_ID,
4962: RESPONSIBILITY_ID,
4963: APPLICATION_ID,

Line 5067: INSERT INTO AMW_VIOLATION_RESP(

5063: FND_FILE.put_line(fnd_file.log,' APPLICATION_ID :'||L_RESPVIO_ENTRIES(1).application_id);
5064: FND_FILE.put_line(fnd_file.log,' WAIVED_FLAG :'||l_is_resp_waived);
5065: FND_FILE.put_line(fnd_file.log,' CORRECTED_FLAG :'||'N'); */
5066:
5067: INSERT INTO AMW_VIOLATION_RESP(
5068: RESP_VIOLATION_ID,
5069: VIOLATION_ID,
5070: RESPONSIBILITY_ID,
5071: APPLICATION_ID,

Line 5188: INSERT INTO AMW_VIOLATION_RESP(

5184: FND_FILE.put_line(fnd_file.log,' APPLICATION_ID :'||L_RESPVIO_ENTRIES(1).application_id);
5185: FND_FILE.put_line(fnd_file.log,' WAIVED_FLAG :'||l_is_resp_waived);
5186: FND_FILE.put_line(fnd_file.log,' CORRECTED_FLAG :'||'N');*/
5187:
5188: INSERT INTO AMW_VIOLATION_RESP(
5189: RESP_VIOLATION_ID,
5190: VIOLATION_ID,
5191: RESPONSIBILITY_ID,
5192: APPLICATION_ID,

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 5312: SELECT AMW_VIOLATION_RESP_S.NEXTVAL

5308: FROM amw_constraint_entries
5309: WHERE constraint_rev_id=l_constraint_rev_id;
5310:
5311: CURSOR c_resp_violation_id IS
5312: SELECT AMW_VIOLATION_RESP_S.NEXTVAL
5313: FROM dual;
5314:
5315: CURSOR c_resp_waived (l_constraint_rev_id IN NUMBER) IS
5316: SELECT PK1,PK2

Line 5324: FROM AMW_VIOLATION_RESP

5320: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
5321:
5322: CURSOR c_existing_resp_violation (l_violation_id IN NUMBER) IS
5323: SELECT APPLICATION_ID,RESPONSIBILITY_ID,RESP_VIOLATION_ID
5324: FROM AMW_VIOLATION_RESP
5325: WHERE violation_id=l_violation_id;
5326:
5327:
5328: l_constraint_function_id NUMBER;

Line 5377: UPDATE AMW_VIOLATION_RESP

5373: -- If No,
5374: -- Set the CORRECTED_FLAG= 'Y' for the responsibility
5375: IF (G_RESP_VIOLATIONS_LIST.COUNT = 0) THEN
5376:
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

Line 5382: WHERE RESP_VIOLATION_ID IN (SELECT RESP_VIOLATION_ID FROM AMW_VIOLATION_RESP WHERE VIOLATION_ID=p_violation_id);

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
5386:

Line 5428: UPDATE AMW_VIOLATION_RESP

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
5429: SET CORRECTED_FLAG ='Y'
5430: WHERE VIOLATION_ID = p_violation_id
5431: AND RESPONSIBILITY_ID = l_existing_resp_id_list(i)
5432: AND APPLICATION_ID = l_existing_appl_id_list(i);

Line 5589: UPDATE AMW_VIOLATION_RESP

5585: ELSE
5586: -- The responsbility does not have atleast one incompatible
5587: -- functions from both the group
5588: -- So it does not violates the constraint
5589: UPDATE AMW_VIOLATION_RESP
5590: SET CORRECTED_FLAG = 'Y'
5591: WHERE VIOLATION_ID = p_violation_id
5592: AND RESPONSIBILITY_ID = l_existing_resp_id_list(i)
5593: AND APPLICATION_ID = l_existing_appl_id_list(i);

Line 5600: UPDATE AMW_VIOLATION_RESP

5596: -- we check if the responsibility still violates the constraint
5597: -- we check this for object_type = ALL or ME
5598: IF (p_type_code = 'ALL' AND L_FUNC_ID_LIST.COUNT <> l_function_id_list.COUNT) OR
5599: (p_type_code = 'ME' AND L_FUNC_ID_LIST.COUNT <= 1) THEN
5600: UPDATE AMW_VIOLATION_RESP
5601: SET CORRECTED_FLAG ='Y'
5602: WHERE VIOLATION_ID = p_violation_id
5603: AND RESPONSIBILITY_ID = l_existing_resp_id_list(i)
5604: AND APPLICATION_ID = l_existing_appl_id_list(i);

Line 5608: UPDATE AMW_VIOLATION_RESP

5604: AND APPLICATION_ID = l_existing_appl_id_list(i);
5605: END IF;
5606: END IF;
5607: ELSE
5608: UPDATE AMW_VIOLATION_RESP
5609: SET CORRECTED_FLAG = 'Y'
5610: WHERE VIOLATION_ID = p_violation_id
5611: AND RESPONSIBILITY_ID = l_existing_resp_id_list(i)
5612: AND APPLICATION_ID = l_existing_appl_id_list(i);

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 7492: DELETE FROM amw_violation_resp

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;
7494:
7495: DELETE FROM amw_violat_user_entries
7496: WHERE creation_date < l_date;

Line 7509: FROM amw_violation_resp

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 (
7511: SELECT violation_id
7512: FROM amw_violations
7513: WHERE status_code = 'NA'

Line 7517: DELETE FROM amw_violation_resp

7513: WHERE status_code = 'NA'
7514: AND creation_date < l_date));
7515:
7516:
7517: DELETE FROM amw_violation_resp
7518: WHERE violation_id IN (
7519: SELECT violation_id
7520: FROM amw_violations
7521: WHERE status_code = 'NA'