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.IGS_EN_NSC_PKG dependencies on IGS_EN_DOC_INSTANCES

Line 12: l_doc_inst_params igs_en_doc_instances.doc_inst_params%TYPE;

8: g_school_id VARCHAR2(30);
9: g_include_gen VARCHAR2(1);
10: g_matr_profile VARCHAR2(20);
11: g_org_id NUMBER(15);
12: l_doc_inst_params igs_en_doc_instances.doc_inst_params%TYPE;
13: l_ant_grad_date DATE;
14: l_grad_type VARCHAR2(25);
15: l_load_term_cd VARCHAR2(20);
16: l_load_cal_type igs_ca_inst.cal_type%TYPE;

Line 85: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

81: Also this function returns the status change date for the W, D, A and G statuses.
82: */
83:
84: FUNCTION Get_Enrollment_Status (
85: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
86: p_student_id IN igs_pe_person.person_id%TYPE ,
87: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
88: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
89: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 91: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

87: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
88: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
89: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
90: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
91: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
92: x_credit_points OUT NOCOPY NUMBER,
93: x_status_date OUT NOCOPY DATE,
94: x_grad_level OUT NOCOPY VARCHAR2,
95: x_ant_grad_date OUT NOCOPY DATE,

Line 130: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

126: p_branch_code IN VARCHAR2,
127: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
128: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
129: p_report_flag IN VARCHAR2,
130: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
131: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE
132: ) ;
133:
134:

Line 131: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE

127: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
128: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
129: p_report_flag IN VARCHAR2,
130: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
131: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE
132: ) ;
133:
134:
135:

Line 142: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE

138: based on the information from the snapshot.
139: Then it stores the trailer record in the EDS.
140: */
141: PROCEDURE Create_Trailer_Record (
142: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE
143: );
144:
145:
146: /*

Line 152: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

148: instantiated before and stores it in the EDS calling the APIs.
149: */
150:
151: PROCEDURE Save_Student_Record (
152: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
153: p_student_data IN student_data_type
154: );
155:
156:

Line 170: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

166: PL/SQL record type is used to store the student information.
167: */
168:
169: PROCEDURE Get_Student_Data (
170: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
171: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
172: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
173: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
174: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,

Line 175: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

171: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
172: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
173: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
174: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
175: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
176: p_student_data IN OUT NOCOPY student_data_type,
177: p_nslc_condition IN varchar2
178: );
179:

Line 191: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)

187: p_branch_id IN VARCHAR2, -- Branch code
188: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
189: p_std_rep_flag IN VARCHAR2, -- Standard report flag
190: p_non_std_rpt_type IN VARCHAR2, --Non standard report type like GRADUATE
191: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
192: p_dirpath IN VARCHAR2, -- Output directory name
193: p_file_name IN VARCHAR2, -- Output file name
194: p_debug_mode IN VARCHAR2
195: ) RETURN BOOLEAN ;

Line 224: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)

220: p_branch_id IN VARCHAR2, -- Branch code
221: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
222: p_std_rep_flag IN VARCHAR2, -- Standard report flag
223: p_non_std_rpt_type IN VARCHAR2, --Non standard report type like GRADUATE
224: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
225: p_dirpath IN VARCHAR2, -- Output directory name
226: p_file_name IN VARCHAR2, -- Output file name
227: p_debug_mode IN VARCHAR2
228: ) RETURN BOOLEAN

Line 247: l_snapshot_id igs_en_doc_instances.doc_inst_id%TYPE :=NULL;

243: cst_valid CONSTANT VARCHAR2(30) := 'VALID';
244: l_student_data student_data_type;
245: l_load_cal_type igs_ca_inst.cal_type%TYPE;
246: l_acad_cal_seq igs_ca_inst.sequence_number%TYPE;
247: l_snapshot_id igs_en_doc_instances.doc_inst_id%TYPE :=NULL;
248: l_branch_code VARCHAR2(20);
249: l_load_term_s_date DATE;
250: l_load_term_e_date DATE;
251: l_req NUMBER;

Line 369: CURSOR c_person_already_in_report(cp_person_id igs_pe_person.person_id%TYPE,cp_snapshot_id igs_en_doc_instances.doc_inst_id%TYPE) IS

365:
366:
367: --Check if the person has already been added by checking if an SSN entry has been made .
368: --The SSN Attribute is mandatory (attrib_id=20)
369: CURSOR c_person_already_in_report(cp_person_id igs_pe_person.person_id%TYPE,cp_snapshot_id igs_en_doc_instances.doc_inst_id%TYPE) IS
370: SELECT cst_valid FROM igs_en_attrib_values
371: WHERE obj_type_id = 1
372: AND obj_id = cp_snapshot_id
373: AND attrib_id = 20

Line 469: CURSOR c_rowid(p_inst_id IGS_EN_DOC_INSTANCES.doc_inst_id%TYPE) IS

465: l_per_done BOOLEAN:=FALSE;
466: l_course_cd igs_ps_ver.course_cd%TYPE;
467: l_version_number igs_ps_ver.version_number%TYPE;
468:
469: CURSOR c_rowid(p_inst_id IGS_EN_DOC_INSTANCES.doc_inst_id%TYPE) IS
470: SELECT rowid
471: FROM igs_en_doc_instances
472: WHERE doc_inst_id = p_inst_id;
473: l_rowid rowid;

Line 471: FROM igs_en_doc_instances

467: l_version_number igs_ps_ver.version_number%TYPE;
468:
469: CURSOR c_rowid(p_inst_id IGS_EN_DOC_INSTANCES.doc_inst_id%TYPE) IS
470: SELECT rowid
471: FROM igs_en_doc_instances
472: WHERE doc_inst_id = p_inst_id;
473: l_rowid rowid;
474: BEGIN
475:

Line 813: IGS_EN_DOC_INSTANCES_PKG.Delete_Row(

809:
810: -- Deleting the instance record and all attribute values
811: if l_rowid is not null then
812: Put_Debug_Msg('calling delete row for ' ||l_rowid);
813: IGS_EN_DOC_INSTANCES_PKG.Delete_Row(
814: x_rowid => l_rowid
815: );
816:
817: end if;

Line 905: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Snapshot Id to create a file

901: ***************************************************************/
902: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
903: retcode OUT NOCOPY NUMBER , -- Request standard return status
904: p_comment IN VARCHAR2, -- Runtime comments
905: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Snapshot Id to create a file
906: p_dirpath IN VARCHAR2 , -- Output directory name
907: p_file_name IN VARCHAR2 , -- Output file name
908: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
909: )

Line 980: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)

976: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
977: p_std_rep_flag IN VARCHAR2, -- Standard report flag
978: p_dummy IN VARCHAR2, /* Dummy Parameter used for validation of non_std_rpt_type Value Set, it is nowhere used in the procedure. */
979: p_non_std_rpt_typ IN VARCHAR2, -- Non Standard report type like 'GRADUATE'
980: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
981: p_dirpath IN VARCHAR2, -- Output directory name
982: p_file_name IN VARCHAR2, -- Output file name
983: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
984: )IS

Line 1050: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE , -- Snapshot Id to delete

1046: ***************************************************************/
1047: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
1048: retcode OUT NOCOPY NUMBER , -- Request standard return status
1049: p_comment IN VARCHAR2, -- Runtime comments
1050: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE , -- Snapshot Id to delete
1051: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
1052: )IS
1053: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Snapshot_Request';
1054: l_return_status CONSTANT VARCHAR2(1) := 'S';

Line 1061: FROM igs_en_doc_instances

1057: l_rowid VARCHAR2(255);
1058:
1059: CURSOR c_rowid IS
1060: SELECT rowid
1061: FROM igs_en_doc_instances
1062: WHERE doc_inst_id = p_inst_id;
1063:
1064: BEGIN
1065:

Line 1073: IGS_EN_DOC_INSTANCES_PKG.Delete_Row(

1069: CLOSE c_rowid;
1070:
1071: -- Deleting the instance record and all attribute values
1072:
1073: IGS_EN_DOC_INSTANCES_PKG.Delete_Row(
1074: x_rowid => l_rowid
1075: );
1076:
1077: -- Checking the status

Line 1150: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

1146: p_branch_code IN VARCHAR2,
1147: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1148: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1149: p_report_flag IN VARCHAR2,
1150: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1151: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE
1152: ) IS
1153:
1154: l_msg_count NUMBER;

Line 1151: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE

1147: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1148: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1149: p_report_flag IN VARCHAR2,
1150: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1151: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE
1152: ) IS
1153:
1154: l_msg_count NUMBER;
1155: l_msg_data VARCHAR2(2000);

Line 1158: l_inst_id igs_en_doc_instances.doc_inst_id%TYPE;

1154: l_msg_count NUMBER;
1155: l_msg_data VARCHAR2(2000);
1156: l_Return_Status VARCHAR2(1);
1157: l_rowid VARCHAR2(255);
1158: l_inst_id igs_en_doc_instances.doc_inst_id%TYPE;
1159: l_code VARCHAR2(3);
1160: BEGIN
1161:
1162: -- Creating instance

Line 1164: IGS_EN_DOC_INSTANCES_PKG.Insert_row (

1160: BEGIN
1161:
1162: -- Creating instance
1163:
1164: IGS_EN_DOC_INSTANCES_PKG.Insert_row (
1165: x_rowid => l_rowid,
1166: x_doc_inst_id => l_inst_id,
1167: x_doc_inst_name => 'NSCL Interface instance' ,
1168: x_doc_inst_params => l_doc_inst_params

Line 1205: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE

1201:
1202: /******************************************************************************/
1203:
1204: PROCEDURE Create_Trailer_Record (
1205: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE
1206: )IS
1207: --Statuses mapping
1208: --10,'F',11,'H',12,'L',13,'W',14,'G',15,'A',16,'X',17,'D','?')
1209:

Line 1233: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

1229:
1230:
1231:
1232: PROCEDURE Save_Student_Record (
1233: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1234: p_student_data IN student_data_type
1235: )IS
1236: l_code VARCHAR2(3);
1237:

Line 1385: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

1381:
1382:
1383:
1384: PROCEDURE Get_Student_Data (
1385: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1386: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1387: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1388: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1389: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,

Line 1390: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

1386: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1387: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1388: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1389: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1390: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1391: p_student_data IN OUT NOCOPY student_data_type,
1392: p_nslc_condition IN VARCHAR2
1393: )IS
1394:

Line 1715: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

1711:
1712: /******************************************************************************/
1713:
1714: FUNCTION Get_Enrollment_Status (
1715: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1716: p_student_id IN igs_pe_person.person_id%TYPE ,
1717: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1718: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1719: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 1721: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

1717: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1718: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1719: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1720: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1721: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1722: x_credit_points OUT NOCOPY NUMBER,
1723: x_status_date OUT NOCOPY DATE,
1724: x_grad_level OUT NOCOPY VARCHAR2,
1725: x_ant_grad_date OUT NOCOPY DATE,