APPS.AMW_AUDIT_PROCEDURES_PVT dependencies on AMW_AP_STEPS_PKG

Line 2552: AMW_AP_STEPS_PKG.INSERT_ROW (

2548: END IF;
2549: FOR steprec IN steps_b
2550: LOOP
2551:
2552: AMW_AP_STEPS_PKG.INSERT_ROW (
2553: X_ROWID => l_row_id,
2554: X_AP_STEP_ID => steprec.STEP_ID,
2555: X_ATTRIBUTE4 => steprec.ATTRIBUTE4,
2556: X_ATTRIBUTE5 => steprec.ATTRIBUTE5,

Line 3075: amw_ap_steps_pkg.update_row(

3071:
3072: if(lx_step_rec.ap_step_id is not null)
3073: then
3074: -- update the step
3075: amw_ap_steps_pkg.update_row(
3076: X_AP_STEP_ID => lx_step_rec.ap_step_id,
3077: X_ATTRIBUTE4 => null,
3078: X_ATTRIBUTE5 => null,
3079: X_ATTRIBUTE1 => null,

Line 3111: amw_ap_steps_pkg.update_row(

3107: X_CSEQNUM => p_seqnum);
3108: elsif(lx_prev_step_rec.ap_step_id is not null)
3109: then
3110: -- set to_rev_num and insert a new row
3111: amw_ap_steps_pkg.update_row(
3112: X_AP_STEP_ID => lx_prev_step_rec.ap_step_id,
3113: X_ATTRIBUTE4 => null,
3114: X_ATTRIBUTE5 => null,
3115: X_ATTRIBUTE1 => null,

Line 3145: amw_ap_steps_pkg.insert_row(X_ROWID => lx_rowid,

3141: X_FROM_REV_NUM => lx_prev_step_rec.from_rev_num,
3142: X_TO_REV_NUM => l_ap_rev_num,
3143: X_CSEQNUM => lx_prev_step_rec.cseqnum);
3144:
3145: amw_ap_steps_pkg.insert_row(X_ROWID => lx_rowid,
3146: X_AP_STEP_ID => l_ap_step_id,
3147: X_ATTRIBUTE4 => null,
3148: X_ATTRIBUTE5 => null,
3149: X_ATTRIBUTE1 => null,

Line 3182: amw_ap_steps_pkg.insert_row(X_ROWID => lx_rowid,

3178: X_TO_REV_NUM => null,
3179: X_CSEQNUM => p_seqnum);
3180: else
3181: -- create a new step as it does not exist
3182: amw_ap_steps_pkg.insert_row(X_ROWID => lx_rowid,
3183: X_AP_STEP_ID => l_ap_step_id,
3184: X_ATTRIBUTE4 => null,
3185: X_ATTRIBUTE5 => null,
3186: X_ATTRIBUTE1 => null,

Line 3225: fnd_file.put_line(fnd_file.LOG,'Done with amw_ap_steps_pkg.insert_row');

3221: THEN
3222: COMMIT WORK;
3223: END IF;
3224:
3225: fnd_file.put_line(fnd_file.LOG,'Done with amw_ap_steps_pkg.insert_row');
3226:
3227: exception
3228: WHEN OTHERS THEN
3229: ROLLBACK TO INSERT_AP_STEP_PVT;

Line 3439: fnd_file.put_line(fnd_file.LOG,'Done with amw_ap_steps_pkg.insert_row');

3435: THEN
3436: COMMIT WORK;
3437: END IF;
3438:
3439: fnd_file.put_line(fnd_file.LOG,'Done with amw_ap_steps_pkg.insert_row');
3440:
3441: exception
3442: WHEN OTHERS THEN
3443: ROLLBACK TO INSERT_AP_CONTROL_ASSOC_PVT;