DBA Data[Home] [Help]

APPS.IGS_PS_GEN_001 dependencies on IGS_PS_PAT_STUDY_PRD_PKG

Line 915: --sarakshi 15-May-2006 Bug#3460640,modified the call to IGS_PS_PAT_STUDY_PRD_PKG.INSERT_ROW with correct values

911: -- IGS_PS_PAT_STUDY_PRD and IGS_PS_PAT_STUDY_UNT
912: PROCEDURE crspl_ins_pos_rec
913: IS
914: --WHo When WHAT
915: --sarakshi 15-May-2006 Bug#3460640,modified the call to IGS_PS_PAT_STUDY_PRD_PKG.INSERT_ROW with correct values
916: BEGIN
917: DECLARE
918: v_pos_seq_num IGS_PS_PAT_OF_STUDY.sequence_number%TYPE;
919: v_posp_seq_num IGS_PS_PAT_STUDY_PRD.sequence_number%TYPE;

Line 1010: IGS_PS_PAT_STUDY_PRD_PKG.INSERT_ROW(

1006: OPEN c_posp_seq_num;
1007: FETCH c_posp_seq_num INTO v_posp_seq_num;
1008: CLOSE c_posp_seq_num;
1009: x_rowid := NULL;
1010: IGS_PS_PAT_STUDY_PRD_PKG.INSERT_ROW(
1011: X_ROWID => x_rowid,
1012: X_COURSE_CD => p_new_course_cd,
1013: X_VERSION_NUMBER => p_new_version_number,
1014: X_POS_SEQUENCE_NUMBER => v_pos_seq_num,--this is the FK