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.FPA_VALIDATION_PVT dependencies on FPA_VALIDATION_LINES

Line 32: p_validation_lines_rec IN FPA_VALIDATION_LINES_REC,

28: (
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2,
31: p_validation_set IN VARCHAR2,
32: p_validation_lines_rec IN FPA_VALIDATION_LINES_REC,
33: x_validation_id OUT NOCOPY NUMBER,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2

Line 46: l_validation_lines_rec FPA_VALIDATION_LINES_REC := p_validation_lines_rec;

42: l_api_version CONSTANT NUMBER := 1.0;
43: l_msg_log VARCHAR2(2000) := null;
44: ----------------------------------------------------------------------------
45: l_flag VARCHAR2(1);
46: l_validation_lines_rec FPA_VALIDATION_LINES_REC := p_validation_lines_rec;
47:
48: CURSOR OBJ_VAL_TYPE_CSR (VALIDATION_SET IN VARCHAR2,
49: OBJ_VALIDATION_TYPE IN VARCHAR2) IS
50: SELECT 'T'

Line 122: select fpa_validation_lines_s.nextval into

118: l_validation_lines_rec.severity := 'I';
119: end if;
120:
121:
122: select fpa_validation_lines_s.nextval into
123: l_validation_lines_rec.validation_id from dual;
124: x_validation_id := l_validation_lines_rec.validation_id;
125: l_validation_lines_rec.created_by := FND_GLOBAL.USER_ID;
126: l_validation_lines_rec.creation_date := SYSDATE;

Line 131: INSERT INTO FPA_VALIDATION_LINES(

127: l_validation_lines_rec.last_updated_by := FND_GLOBAL.USER_ID;
128: l_validation_lines_rec.last_update_date := SYSDATE;
129: l_validation_lines_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
130:
131: INSERT INTO FPA_VALIDATION_LINES(
132: validation_id,
133: header_id,
134: object_id,
135: object_type,

Line 265: l_validation_lines_rec FPA_VALIDATION_LINES_REC;

261: l_msg_data VARCHAR2(2000);
262: ----------------------------------------------------------------------------
263:
264: i INTEGER;
265: l_validation_lines_rec FPA_VALIDATION_LINES_REC;
266: l_validation_id NUMBER;
267: l_exists VARCHAR2(1) := FND_API.G_FALSE;
268:
269: CURSOR CHECK_VALIDATION_LINES(

Line 275: FROM FPA_VALIDATION_LINES FPA

271: P_OBJECT_HEADER_ID IN NUMBER,
272: P_OBJECT_ID IN NUMBER,
273: P_OBJECT_TYPE IN VARCHAR2) IS
274: SELECT 'T'
275: FROM FPA_VALIDATION_LINES FPA
276: WHERE
277: FPA.VALIDATION_TYPE = P_VALIDATIONS_TYPE
278: AND FPA.HEADER_ID = P_OBJECT_HEADER_ID
279: AND FPA.OBJECT_ID = P_OBJECT_ID

Line 402: FROM FPA_VALIDATION_LINES HDR, FPA_VALIDATION_LINES OBJ

398: P_OBJECT_ID IN NUMBER,
399: P_OBJECT_TYPE IN VARCHAR2,
400: P_SEVERITY IN VARCHAR2) IS
401: SELECT 'T'
402: FROM FPA_VALIDATION_LINES HDR, FPA_VALIDATION_LINES OBJ
403: WHERE
404: HDR.VALIDATION_TYPE = G_VALIDATION_SET
405: AND HDR.OBJECT_ID = G_HEADER_ID
406: AND OBJ.HEADER_ID = HDR.OBJECT_ID

Line 480: p_validations_type IN FPA_VALIDATION_LINES.VALIDATION_TYPE%TYPE,

476: p_api_version IN NUMBER,
477: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
478: p_header_object_id IN NUMBER,
479: p_header_object_type IN VARCHAR2,
480: p_validations_type IN FPA_VALIDATION_LINES.VALIDATION_TYPE%TYPE,
481: x_resource_status OUT NOCOPY INTEGER,
482: x_resource_id OUT NOCOPY FPA_VALIDATION_LINES.VALIDATION_ID%TYPE,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY NUMBER,

Line 482: x_resource_id OUT NOCOPY FPA_VALIDATION_LINES.VALIDATION_ID%TYPE,

478: p_header_object_id IN NUMBER,
479: p_header_object_type IN VARCHAR2,
480: p_validations_type IN FPA_VALIDATION_LINES.VALIDATION_TYPE%TYPE,
481: x_resource_status OUT NOCOPY INTEGER,
482: x_resource_id OUT NOCOPY FPA_VALIDATION_LINES.VALIDATION_ID%TYPE,
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY NUMBER,
485: x_msg_data OUT NOCOPY VARCHAR2)
486: IS

Line 501: FROM FPA_VALIDATION_LINES

497: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
498:
499: CURSOR lock_csr IS
500: SELECT VALIDATION_ID
501: FROM FPA_VALIDATION_LINES
502: WHERE OBJECT_ID = P_HEADER_OBJECT_ID
503: AND OBJECT_TYPE = P_HEADER_OBJECT_TYPE
504: AND VALIDATION_TYPE = P_VALIDATIONS_TYPE
505: FOR UPDATE OF LAST_UPDATE_DATE NOWAIT;

Line 611: l_validation_lines_rec FPA_VALIDATION_LINES_REC;

607: l_msg_log VARCHAR2(2000) := null;
608: ----------------------------------------------------------------------------
609:
610: l_res_status INTEGER := -1;
611: l_validation_lines_rec FPA_VALIDATION_LINES_REC;
612: l_validation_id NUMBER;
613: l_header_id NUMBER;
614:
615: BEGIN

Line 723: DELETE FROM FPA_VALIDATION_LINES FL

719: raise Fpa_Utilities_Pvt.G_EXCEPTION_ERROR;
720:
721: end if;
722:
723: DELETE FROM FPA_VALIDATION_LINES FL
724: WHERE FL.HEADER_ID IN (
725: SELECT OBJECT_ID FROM FPA_VALIDATION_LINES FH
726: WHERE FH.VALIDATION_TYPE = P_VALIDATION_SET
727: AND FH.OBJECT_TYPE = P_HEADER_OBJECT_TYPE

Line 725: SELECT OBJECT_ID FROM FPA_VALIDATION_LINES FH

721: end if;
722:
723: DELETE FROM FPA_VALIDATION_LINES FL
724: WHERE FL.HEADER_ID IN (
725: SELECT OBJECT_ID FROM FPA_VALIDATION_LINES FH
726: WHERE FH.VALIDATION_TYPE = P_VALIDATION_SET
727: AND FH.OBJECT_TYPE = P_HEADER_OBJECT_TYPE
728: AND FH.OBJECT_ID = P_HEADER_OBJECT_ID);
729:

Line 746: UPDATE FPA_VALIDATION_LINES

742:
743: Close_Validations;
744: UnInitialize;
745:
746: UPDATE FPA_VALIDATION_LINES
747: SET LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
748: LAST_UPDATE_DATE = SYSDATE,
749: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
750: WHERE VALIDATION_ID = L_HEADER_ID;