DBA Data[Home] [Help]

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_APP_STATS_PKG

Line 2306: igs_uc_app_stats_pkg.update_row(

2302: IF new_ivstark_rec.apr <> old_stark_rec.domicile_apr THEN
2303:
2304: FOR Cur_app_stats_rec IN Cur_app_stats (new_ivstark_rec.appno)
2305: LOOP
2306: igs_uc_app_stats_pkg.update_row(
2307: x_rowid => Cur_app_stats_rec.rowid
2308: ,x_app_stat_id => Cur_app_stats_rec.app_stat_id
2309: ,x_app_id => Cur_app_stats_rec.app_id
2310: ,x_app_no => Cur_app_stats_rec.app_no

Line 5220: igs_uc_app_stats_pkg.insert_row -- IGSXI07B.pls

5216:
5217: BEGIN
5218:
5219: -- call the TBH to update the record
5220: igs_uc_app_stats_pkg.insert_row -- IGSXI07B.pls
5221: (
5222: x_rowid => old_starx_rec.rowid -- would be NULL since no existing rec found
5223: ,x_app_stat_id => old_starx_rec.app_stat_id -- since this will be NULL since no existing rec found.
5224: ,x_app_id => appl_det_rec.app_id

Line 5261: igs_uc_app_stats_pkg.update_row -- IGSXI07B.pls

5257: ELSE -- update
5258:
5259: BEGIN
5260: -- call the TBH to update the record
5261: igs_uc_app_stats_pkg.update_row -- IGSXI07B.pls
5262: (
5263: x_rowid => old_starx_rec.rowid
5264: ,x_app_stat_id => old_starx_rec.app_stat_id
5265: ,x_app_id => old_starx_rec.app_id

Line 5533: igs_uc_app_stats_pkg.insert_row -- IGSXI07B.pls

5529:
5530: BEGIN
5531:
5532: -- call the TBH to update the record
5533: igs_uc_app_stats_pkg.insert_row -- IGSXI07B.pls
5534: (
5535: x_rowid => old_starh_rec.rowid
5536: ,x_app_stat_id => old_starh_rec.app_stat_id -- can be used as this value will be NULL during insert as no rec exists.
5537: ,x_app_id => appl_det_rec.app_id

Line 5574: igs_uc_app_stats_pkg.update_row -- IGSXI07B.pls

5570: ELSE -- update
5571:
5572: BEGIN
5573: -- call the TBH to update the record
5574: igs_uc_app_stats_pkg.update_row -- IGSXI07B.pls
5575: (
5576: x_rowid => old_starh_rec.rowid
5577: ,x_app_stat_id => old_starh_rec.app_stat_id
5578: ,x_app_id => old_starh_rec.app_id