APPS.IGS_AZ_GEN_001 dependencies on IGS_AZ_ADVISING_RELS_PKG

Line 1048: igs_az_advising_rels_pkg.insert_row (

1044: lnProcessed := lnProcessed +1;
1045: --
1046: -- Add Student to the Relationship table with the current Advisor
1047: --
1048: igs_az_advising_rels_pkg.insert_row (
1049: x_rowid => lv_rowid,
1050: x_group_advising_rel_id => l_group_advising_rel_id,
1051: x_group_name => p_group_name,
1052: x_group_advisor_id => rec_advisors_to_load.group_advisor_id,

Line 2038: igs_az_advising_rels_pkg.update_row (

2034: --
2035: -- End date the relationship..
2036: --
2037: FOR reln_rec IN cur_reln LOOP
2038: igs_az_advising_rels_pkg.update_row (
2039: x_rowid => reln_rec.row_id,
2040: x_group_advising_rel_id => reln_rec.group_advising_rel_id,
2041: x_group_name => reln_rec.group_name,
2042: x_group_advisor_id => reln_rec.group_advisor_id,

Line 2053: igs_az_advising_rels_pkg.delete_row (

2049: ); -- To do see if msg count etc. is require , if yes add and Error Handling
2050: END LOOP;
2051: --
2052: FOR del_reln IN cur_reln_del LOOP
2053: igs_az_advising_rels_pkg.delete_row (
2054: x_rowid => del_reln.row_id,
2055: x_return_status => lvReturnStatus,
2056: x_msg_data => lvMsgData,
2057: x_msg_count => lnMsgCount

Line 2217: igs_az_advising_rels_pkg.update_row (

2213: --
2214: -- End date the relationship..
2215: --
2216: FOR reln_rec IN cur_reln LOOP
2217: igs_az_advising_rels_pkg.update_row (
2218: x_rowid => reln_rec.row_id,
2219: x_group_advising_rel_id => reln_rec.group_advising_rel_id,
2220: x_group_name => reln_rec.group_name,
2221: x_group_advisor_id => reln_rec.group_advisor_id,

Line 2232: igs_az_advising_rels_pkg.delete_row (

2228: ); -- To do see if msg count etc. is require , if yes add and Error Handling also to do See how we can verify that the end date is earliest of either the student or the advisor end date if any.
2229: END LOOP; --reln_rec
2230: --
2231: FOR del_reln IN cur_reln_del LOOP
2232: igs_az_advising_rels_pkg.delete_row (
2233: x_rowid => del_reln.row_id,
2234: x_return_status => lvReturnStatus,
2235: x_msg_data => lvMsgData,
2236: x_msg_count => lnMsgCount