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_USER_VIOLATION_S

Line 3166: -- store the user_violation_id getting from AMW_USER_VIOLATION_S

3162:
3163: i NUMBER;
3164: l_party_id NUMBER;
3165:
3166: -- store the user_violation_id getting from AMW_USER_VIOLATION_S
3167: l_user_violation_id NUMBER;
3168: l_row_id VARCHAR2(32767); -- 11.17.2003 tsho: need to check out
3169:
3170: -- get user_violation_id from AMW_USER_VIOLATION_S

Line 3170: -- get user_violation_id from AMW_USER_VIOLATION_S

3166: -- store the user_violation_id getting from AMW_USER_VIOLATION_S
3167: l_user_violation_id NUMBER;
3168: l_row_id VARCHAR2(32767); -- 11.17.2003 tsho: need to check out
3169:
3170: -- get user_violation_id from AMW_USER_VIOLATION_S
3171: CURSOR c_user_violation_id IS
3172: SELECT AMW_USER_VIOLATION_S.NEXTVAL
3173: FROM dual;
3174:

Line 3172: SELECT AMW_USER_VIOLATION_S.NEXTVAL

3168: l_row_id VARCHAR2(32767); -- 11.17.2003 tsho: need to check out
3169:
3170: -- get user_violation_id from AMW_USER_VIOLATION_S
3171: CURSOR c_user_violation_id IS
3172: SELECT AMW_USER_VIOLATION_S.NEXTVAL
3173: FROM dual;
3174:
3175:
3176:

Line 3224: -- get user_violation_id from AMW_USER_VIOLATION_S

3220: -- don't create a record in AMW_VIOLATION_USERS
3221: RETURN;
3222: END IF;
3223:
3224: -- get user_violation_id from AMW_USER_VIOLATION_S
3225: OPEN c_user_violation_id;
3226: FETCH c_user_violation_id INTO l_user_violation_id;
3227: CLOSE c_user_violation_id;
3228:

Line 4517: -- store the user_violation_id getting from AMW_USER_VIOLATION_S

4513: i NUMBER;
4514: idx NUMBER;
4515: l_party_id NUMBER;
4516:
4517: -- store the user_violation_id getting from AMW_USER_VIOLATION_S
4518: l_user_violation_id NUMBER;
4519: l_row_id ROWID;
4520:
4521: -- ptulasi : 18/02/2008

Line 4528: -- get user_violation_id from AMW_USER_VIOLATION_S

4524: l_waiv_resp_appl_id_list G_NUMBER_TABLE;
4525: l_waived_resp_appl_list G_NUMBER_TABLE_TYPE;
4526: listkey VARCHAR2(250);
4527:
4528: -- get user_violation_id from AMW_USER_VIOLATION_S
4529: CURSOR c_user_violation_id IS
4530: SELECT AMW_USER_VIOLATION_S.NEXTVAL
4531: FROM dual;
4532:

Line 4530: SELECT AMW_USER_VIOLATION_S.NEXTVAL

4526: listkey VARCHAR2(250);
4527:
4528: -- get user_violation_id from AMW_USER_VIOLATION_S
4529: CURSOR c_user_violation_id IS
4530: SELECT AMW_USER_VIOLATION_S.NEXTVAL
4531: FROM dual;
4532:
4533: l_is_user_waived VARCHAR2(1);
4534: L_USERVIO_ENTRIES G_USERVIO_ENTRIES_TABLE;

Line 4598: -- get user_violation_id from AMW_USER_VIOLATION_S

4594: IF (G_User_Waiver_List.exists(p_user_id))THEN
4595: l_is_user_waived := 'Y';
4596: END IF;
4597:
4598: -- get user_violation_id from AMW_USER_VIOLATION_S
4599: OPEN c_user_violation_id;
4600: FETCH c_user_violation_id INTO l_user_violation_id;
4601: CLOSE c_user_violation_id;
4602:

Line 4705: -- store the user_violation_id getting from AMW_USER_VIOLATION_S

4701: i NUMBER;
4702: idx NUMBER;
4703: l_party_id NUMBER;
4704:
4705: -- store the user_violation_id getting from AMW_USER_VIOLATION_S
4706: l_user_violation_id NUMBER;
4707: l_row_id ROWID;
4708:
4709: l_is_user_waived VARCHAR2(1);

Line 4714: -- get user_violation_id from AMW_USER_VIOLATION_S

4710: L_USERVIO_ENTRIES G_USERVIO_ENTRIES_TABLE;
4711: L_RESP_ID_LIST G_RESPS_TABLE;
4712: listkey VARCHAR2(30) := NULL;
4713:
4714: -- get user_violation_id from AMW_USER_VIOLATION_S
4715: CURSOR c_user_violation_id IS
4716: SELECT AMW_USER_VIOLATION_S.NEXTVAL
4717: FROM dual;
4718: BEGIN

Line 4716: SELECT AMW_USER_VIOLATION_S.NEXTVAL

4712: listkey VARCHAR2(30) := NULL;
4713:
4714: -- get user_violation_id from AMW_USER_VIOLATION_S
4715: CURSOR c_user_violation_id IS
4716: SELECT AMW_USER_VIOLATION_S.NEXTVAL
4717: FROM dual;
4718: BEGIN
4719: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);
4720: l_is_user_waived := NULL;

Line 4758: -- get user_violation_id from AMW_USER_VIOLATION_S

4754: IF (G_User_Waiver_List.exists(p_user_id))THEN
4755: l_is_user_waived := 'Y';
4756: END IF;
4757:
4758: -- get user_violation_id from AMW_USER_VIOLATION_S
4759: OPEN c_user_violation_id;
4760: FETCH c_user_violation_id INTO l_user_violation_id;
4761: CLOSE c_user_violation_id;
4762: