APPS.IGS_SS_TST_RSLT_DTLS_PKG dependencies on IGS_SS_TST_RSLT_DTLS

Line 1: PACKAGE BODY IGS_SS_TST_RSLT_DTLS_PKG AS

1: PACKAGE BODY IGS_SS_TST_RSLT_DTLS_PKG AS
2: /* $Header: IGSSS07B.pls 115.6 2003/10/30 13:32:33 rghosh noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ss_tst_rslt_dtls%RowType;
5: new_references igs_ss_tst_rslt_dtls%RowType;

Line 4: old_references igs_ss_tst_rslt_dtls%RowType;

1: PACKAGE BODY IGS_SS_TST_RSLT_DTLS_PKG AS
2: /* $Header: IGSSS07B.pls 115.6 2003/10/30 13:32:33 rghosh noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ss_tst_rslt_dtls%RowType;
5: new_references igs_ss_tst_rslt_dtls%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ss_tst_rslt_dtls%RowType;

1: PACKAGE BODY IGS_SS_TST_RSLT_DTLS_PKG AS
2: /* $Header: IGSSS07B.pls 115.6 2003/10/30 13:32:33 rghosh noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ss_tst_rslt_dtls%RowType;
5: new_references igs_ss_tst_rslt_dtls%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_SS_TST_RSLT_DTLS

32: ***************************************************************/
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_SS_TST_RSLT_DTLS
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 191: FROM igs_ss_tst_rslt_dtls

187: ***************************************************************/
188:
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM igs_ss_tst_rslt_dtls
192: WHERE ss_tst_rslt_dtls_id = x_tst_rslt_dtls_id
193: FOR UPDATE NOWAIT;
194:
195: lv_rowid cur_rowid%RowType;

Line 228: FROM igs_ss_tst_rslt_dtls

224: ***************************************************************/
225:
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_ss_tst_rslt_dtls
229: WHERE ss_test_results_id = x_test_results_id
230: AND test_segment_id = x_test_segment_id and ((l_rowid is null) or (rowid <> l_rowid))
231:
232: ;

Line 265: FROM igs_ss_tst_rslt_dtls

261: ***************************************************************/
262:
263: CURSOR cur_rowid IS
264: SELECT rowid
265: FROM igs_ss_tst_rslt_dtls
266: WHERE ss_test_results_id = x_test_results_id ;
267:
268: lv_rowid cur_rowid%RowType;
269:

Line 302: FROM igs_ss_tst_rslt_dtls

298: ***************************************************************/
299:
300: CURSOR cur_rowid IS
301: SELECT rowid
302: FROM igs_ss_tst_rslt_dtls
303: WHERE test_segment_id = x_test_segment_id ;
304:
305: lv_rowid cur_rowid%RowType;
306:

Line 453: cursor C is select ROWID from IGS_SS_TST_RSLT_DTLS

449:
450: (reverse chronological order - newest change first)
451: ***************************************************************/
452:
453: cursor C is select ROWID from IGS_SS_TST_RSLT_DTLS
454: where SS_TST_RSLT_DTLS_ID= X_TST_RSLT_DTLS_ID
455: ;
456: X_LAST_UPDATE_DATE DATE ;
457: X_LAST_UPDATED_BY NUMBER ;

Line 469: SELECT IGS_SS_TST_RSLT_DTLS_S.NEXTVAL INTO X_TST_RSLT_DTLS_ID FROM DUAL;

465: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
466: FND_MSG_PUB.ADD;
467: RAISE FND_API.G_EXC_ERROR;
468: end if;
469: SELECT IGS_SS_TST_RSLT_DTLS_S.NEXTVAL INTO X_TST_RSLT_DTLS_ID FROM DUAL;
470: Before_DML(
471: p_action=>'INSERT',
472: x_rowid=>X_ROWID,
473: x_tst_rslt_dtls_id=>X_TST_RSLT_DTLS_ID,

Line 482: insert into IGS_SS_TST_RSLT_DTLS (

478: x_created_by=>X_LAST_UPDATED_BY,
479: x_last_update_date=>X_LAST_UPDATE_DATE,
480: x_last_updated_by=>X_LAST_UPDATED_BY,
481: x_last_update_login=>X_LAST_UPDATE_LOGIN);
482: insert into IGS_SS_TST_RSLT_DTLS (
483: SS_TST_RSLT_DTLS_ID
484: ,SS_TEST_RESULTS_ID
485: ,TEST_SEGMENT_ID
486: ,TEST_SCORE

Line 536: from IGS_SS_TST_RSLT_DTLS

532: cursor c1 is select
533: SS_TEST_RESULTS_ID
534: , TEST_SEGMENT_ID
535: , TEST_SCORE
536: from IGS_SS_TST_RSLT_DTLS
537: where ROWID = X_ROWID
538: for update nowait;
539: tlinfo c1%rowtype;
540: begin

Line 612: update IGS_SS_TST_RSLT_DTLS set

608: x_last_updated_by=>X_LAST_UPDATED_BY,
609: x_last_update_login=>X_LAST_UPDATE_LOGIN);
610:
611:
612: update IGS_SS_TST_RSLT_DTLS set
613: SS_TEST_RESULTS_ID = NEW_REFERENCES.SS_TEST_RESULTS_ID,
614: TEST_SEGMENT_ID = NEW_REFERENCES.TEST_SEGMENT_ID,
615: TEST_SCORE = NEW_REFERENCES.TEST_SCORE,
616: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 656: from IGS_SS_TST_RSLT_DTLS

652: l_api_version CONSTANT NUMBER := 1.0;
653: l_count NUMBER;
654:
655: cursor c1 is select ROWID
656: from IGS_SS_TST_RSLT_DTLS
657: where SS_TST_RSLT_DTLS_ID= X_TST_RSLT_DTLS_ID;
658: begin
659:
660: --Standard start of API savepoint

Line 728: END IGS_SS_TST_RSLT_DTLS_PKG;

724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727: end ADD_ROW;
728: END IGS_SS_TST_RSLT_DTLS_PKG;