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_AUDIT_PROCEDURES_PVT dependencies on AMW_AUDIT_PROCEDURES_B

Line 51: FROM amw_audit_procedures_b

47: l_audit_procedure_id amw_audit_procedures_vl.audit_procedure_id%TYPE;
48:
49: CURSOR c_revision_exists (l_audit_procedure_id IN NUMBER) IS
50: SELECT count(*)
51: FROM amw_audit_procedures_b
52: GROUP BY audit_procedure_id
53: HAVING audit_procedure_id=l_audit_procedure_id;
54:
55: CURSOR c_approval_status (l_audit_procedure_id IN NUMBER) IS

Line 58: FROM amw_audit_procedures_b

54:
55: CURSOR c_approval_status (l_audit_procedure_id IN NUMBER) IS
56: SELECT audit_procedure_rev_id,
57: approval_status
58: FROM amw_audit_procedures_b
59: WHERE audit_procedure_id=l_audit_procedure_id AND
60: latest_revision_flag='Y';
61: l_approval_status c_approval_status%ROWTYPE;
62:

Line 129: -- no corresponding audit_procedure_id in AMW_AUDIT_PROCEDURES_B is wrong

125: FETCH c_revision_exists INTO l_dummy;
126: CLOSE c_revision_exists;
127:
128: IF l_dummy IS NULL OR l_dummy < 1 THEN
129: -- no corresponding audit_procedure_id in AMW_AUDIT_PROCEDURES_B is wrong
130: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
131: p_token_name => 'OBJ_TYPE',
132: p_token_value => G_OBJ_TYPE);
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 135: -- has only one record for audit_procedure_id in AMW_AUDIT_PROCEDURES_B with pass-in name

131: p_token_name => 'OBJ_TYPE',
132: p_token_value => G_OBJ_TYPE);
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: ELSIF l_dummy = 1 THEN
135: -- has only one record for audit_procedure_id in AMW_AUDIT_PROCEDURES_B with pass-in name
136: OPEN c_approval_status(l_audit_procedure_id);
137: FETCH c_approval_status INTO l_approval_status;
138: CLOSE c_approval_status;
139:

Line 295: FROM amw_audit_procedures_b

291: l_dummy_audit_procedure_rec audit_procedure_rec_type;
292:
293: CURSOR c_draft_revision (l_audit_procedure_id IN NUMBER) IS
294: SELECT audit_procedure_rev_id
295: FROM amw_audit_procedures_b
296: WHERE audit_procedure_id = l_audit_procedure_id AND approval_status='D' AND latest_revision_flag='Y';
297:
298: BEGIN
299: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 562: FROM amw_audit_procedures_b

558: FROM dual;
559:
560: CURSOR c_rev_id_exists (l_rev_id IN NUMBER) IS
561: SELECT 1
562: FROM amw_audit_procedures_b
563: WHERE audit_procedure_rev_id = l_rev_id;
564:
565: CURSOR c_id IS
566: SELECT amw_procedures_s.nextval

Line 571: FROM amw_audit_procedures_b

567: FROM dual;
568:
569: CURSOR c_id_exists (l_id IN NUMBER) IS
570: SELECT 1
571: FROM amw_audit_procedures_b
572: WHERE audit_procedure_id = l_id;
573:
574: BEGIN
575: -- Standard Start of API savepoint

Line 810: FROM amw_audit_procedures_b

806: l_classification number;
807:
808: CURSOR c_target_revision (l_audit_procedure_id IN NUMBER) IS
809: SELECT audit_procedure_rev_id
810: FROM amw_audit_procedures_b
811: WHERE audit_procedure_id = l_audit_procedure_id AND approval_status='D' AND latest_revision_flag='Y';
812:
813: BEGIN
814: -- Standard Start of API savepoint

Line 897: FROM amw_audit_procedures_b

893: -- check if the AP has a classification already
894: begin
895: SELECT classification
896: INTO l_classification
897: FROM amw_audit_procedures_b
898: ----03.01.2005 npanandi: ERROR in below JOIN
899: ----audit_procedure_id should be equated to l_dummy_audit_procedure_rec.audit_procedure_id;
900: ----WHERE audit_procedure_id = l_dummy_audit_procedure_rec.audit_procedure_rev_id;
901: WHERE audit_procedure_id = l_dummy_audit_procedure_rec.audit_procedure_id;

Line 1175: FROM amw_audit_procedures_b

1171: SELECT audit_procedure_rev_id,
1172: audit_procedure_id,
1173: audit_procedure_rev_num,
1174: object_version_number
1175: FROM amw_audit_procedures_b
1176: WHERE audit_procedure_id = l_audit_procedure_id AND ( approval_status='A' OR approval_status='R') AND latest_revision_flag='Y';
1177: target_revision c_target_revision%ROWTYPE;
1178:
1179: BEGIN

Line 1280: FROM amw_audit_procedures_b

1276: ---webADI upload gives a "Exact Fetch return More than one Row" error
1277: begin
1278: SELECT classification
1279: INTO l_classification
1280: FROM amw_audit_procedures_b
1281: ---WHERE audit_procedure_id = target_revision.audit_procedure_rev_id;
1282: WHERE audit_procedure_id = target_revision.audit_procedure_id;
1283: exception
1284: when no_data_found then

Line 1393: 'amw_audit_procedures_b',

1389: -- audit_procedure_rev_id and audit_procedure_id have been checked when creating
1390: /*
1391: IF p_operate_mode = G_OP_CREATE THEN
1392: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(
1393: 'amw_audit_procedures_b',
1394: 'audit_procedure_rev_id = ''' || p_audit_procedure_rec.audit_procedure_rev_id ||''''
1395: );
1396: ELSE
1397: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(

Line 1398: 'amw_audit_procedures_b',

1394: 'audit_procedure_rev_id = ''' || p_audit_procedure_rec.audit_procedure_rev_id ||''''
1395: );
1396: ELSE
1397: l_valid_flag := AMW_UTILITY_PVT.check_uniqueness(
1398: 'amw_audit_procedures_b',
1399: 'audit_procedure_rev_id = ''' || p_audit_procedure_rec.audit_procedure_rev_id ||
1400: ''' AND audit_procedure_rev_id <> ' || p_audit_procedure_rec.audit_procedure_rev_id
1401: );
1402: END IF;

Line 1631: FROM amw_audit_procedures_b

1627: l_return_status VARCHAR2(1);
1628:
1629: CURSOR c_complete IS
1630: SELECT *
1631: FROM amw_audit_procedures_b
1632: WHERE audit_procedure_rev_id = p_audit_procedure_rec.audit_procedure_rev_id;
1633: l_audit_procedure_rec c_complete%ROWTYPE;
1634:
1635:

Line 2193: FROM amw_audit_procedures_b

2189:
2190: -- c_target_audit_procedure is holding the info of target audit procedure which is going to be updated
2191: CURSOR c_target_audit_procedure (l_audit_procedure_rev_id IN NUMBER) IS
2192: SELECT approval_status
2193: FROM amw_audit_procedures_b
2194: WHERE audit_procedure_rev_id = l_audit_procedure_rev_id;
2195: target_audit_procedure c_target_audit_procedure%ROWTYPE;
2196:
2197: CURSOR c_name_exists (l_audit_procedure_name IN VARCHAR2,l_audit_procedure_id IN NUMBER) IS

Line 2292: -- c_target_audit_procedure is holding the info of target audit procedure from amw_audit_procedures_b which is going to be revised

2288: IS
2289: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Revise_AP_Rec';
2290: l_dummy NUMBER;
2291:
2292: -- c_target_audit_procedure is holding the info of target audit procedure from amw_audit_procedures_b which is going to be revised
2293: CURSOR c_target_audit_procedure (l_audit_procedure_rev_id IN NUMBER) IS
2294: SELECT approval_status
2295: FROM amw_audit_procedures_b
2296: WHERE audit_procedure_rev_id = l_audit_procedure_rev_id;

Line 2295: FROM amw_audit_procedures_b

2291:
2292: -- c_target_audit_procedure is holding the info of target audit procedure from amw_audit_procedures_b which is going to be revised
2293: CURSOR c_target_audit_procedure (l_audit_procedure_rev_id IN NUMBER) IS
2294: SELECT approval_status
2295: FROM amw_audit_procedures_b
2296: WHERE audit_procedure_rev_id = l_audit_procedure_rev_id;
2297: target_audit_procedure c_target_audit_procedure%ROWTYPE;
2298:
2299: CURSOR c_get_name (l_audit_procedure_rev_id IN NUMBER) IS

Line 2387: FROM amw_audit_procedures_b

2383: l_dummy NUMBER;
2384:
2385: CURSOR c_audit_procedure_exists (l_audit_procedure_rev_id IN NUMBER) IS
2386: SELECT 1
2387: FROM amw_audit_procedures_b
2388: WHERE audit_procedure_rev_id = l_audit_procedure_rev_id;
2389:
2390: BEGIN
2391: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 2510: FROM AMW_AP_STEPS_VL step, AMW_AUDIT_PROCEDURES_B ap

2506: step.REQUESTOR_ID,
2507: step.NAME,
2508: step.DESCRIPTION,
2509: step.CSEQNUM
2510: FROM AMW_AP_STEPS_VL step, AMW_AUDIT_PROCEDURES_B ap
2511:
2512: WHERE ap.audit_procedure_rev_id = x_from_ap_rev_id and
2513: ap.audit_procedure_id = step.audit_procedure_id and
2514: ap.audit_procedure_rev_num >= step.from_rev_num and

Line 3008: From amw_audit_procedures_b

3004: AND b.to_rev_num is null and b.from_rev_num <> c_from_ap_rev_num;
3005:
3006: CURSOR c_get_rev_num(c_audit_procedure_rev_id in number) is
3007: Select audit_procedure_rev_num
3008: From amw_audit_procedures_b
3009: Where audit_procedure_rev_id = c_audit_procedure_rev_id;
3010:
3011: cursor get_ap_steps_id is
3012: select amw_ap_steps_s.nextval from dual;

Line 3595: FROM amw_audit_procedures_b

3591: l_api_name CONSTANT VARCHAR2(30) := 'revise_ap_if_necessary';
3592: l_api_version_number CONSTANT NUMBER := 1.0;
3593: CURSOR c_revision_exists (l_audit_procedure_id IN NUMBER) IS
3594: SELECT count(*)
3595: FROM amw_audit_procedures_b
3596: GROUP BY audit_procedure_id
3597: HAVING audit_procedure_id=l_audit_procedure_id;
3598:
3599: CURSOR c_approval_status (l_audit_procedure_id IN NUMBER) IS

Line 3602: FROM amw_audit_procedures_b

3598:
3599: CURSOR c_approval_status (l_audit_procedure_id IN NUMBER) IS
3600: SELECT audit_procedure_rev_id,
3601: approval_status
3602: FROM amw_audit_procedures_b
3603: WHERE audit_procedure_id=l_audit_procedure_id AND
3604: latest_revision_flag='Y';
3605: l_approval_status c_approval_status%ROWTYPE;
3606: l_dummy NUMBER;

Line 3637: -- no corresponding audit_procedure_id in AMW_AUDIT_PROCEDURES_B is wrong

3633: CLOSE c_revision_exists;
3634:
3635: IF l_dummy IS NULL OR l_dummy < 1
3636: THEN
3637: -- no corresponding audit_procedure_id in AMW_AUDIT_PROCEDURES_B is wrong
3638: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNEXPECT_ERROR',
3639: p_token_name => 'OBJ_TYPE',
3640: p_token_value => G_OBJ_TYPE);
3641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3644: -- has only one record for audit_procedure_id in AMW_AUDIT_PROCEDURES_B with pass-in name

3640: p_token_value => G_OBJ_TYPE);
3641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3642: ELSIF l_dummy >= 1
3643: THEN
3644: -- has only one record for audit_procedure_id in AMW_AUDIT_PROCEDURES_B with pass-in name
3645: OPEN c_approval_status(p_audit_procedure_id);
3646: FETCH c_approval_status INTO l_approval_status;
3647: CLOSE c_approval_status;
3648:

Line 3662: insert into AMW_AUDIT_PROCEDURES_B (

3658: OPEN c_get_rev_id;
3659: FETCH c_get_rev_id INTO l_audit_procedure_rev_id;
3660: CLOSE c_get_rev_id;
3661:
3662: insert into AMW_AUDIT_PROCEDURES_B (
3663: PROJECT_ID,
3664: ATTRIBUTE10,
3665: ATTRIBUTE11,
3666: ATTRIBUTE12,

Line 3734: FROM AMW_AUDIT_PROCEDURES_B

3730: SYSDATE,
3731: G_USER_ID,
3732: G_LOGIN_ID,
3733: CLASSIFICATION
3734: FROM AMW_AUDIT_PROCEDURES_B
3735: WHERE AUDIT_PROCEDURE_REV_ID = l_approval_status.audit_procedure_rev_id
3736: );
3737:
3738: insert into AMW_AUDIT_PROCEDURES_TL (

Line 3765: UPDATE AMW_AUDIT_PROCEDURES_B

3761: SOURCE_LANG
3762: from AMW_AUDIT_PROCEDURES_TL
3763: where AUDIT_PROCEDURE_REV_ID = l_approval_status.audit_procedure_rev_id);
3764:
3765: UPDATE AMW_AUDIT_PROCEDURES_B
3766: SET LATEST_REVISION_FLAG = 'N',
3767: END_DATE = SYSDATE,
3768: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3769: WHERE AUDIT_PROCEDURE_REV_ID = l_approval_status.audit_procedure_rev_id;