APPS.PQH_CORPS_UTILITY dependencies on PER_SPINAL_POINT_STEPS_PKG

Line 26: PER_SPINAL_POINT_STEPS_PKG.pop_flds(l_seq,p_effective_date,l_spinal_point_id,l_grade_spine_id);

22: BEGIN
23: OPEN csr_step_dtls(p_step_id,p_effective_date);
24: FETCH csr_step_dtls INTO l_spinal_point, l_spinal_point_id, l_grade_spine_id;
25: CLOSE csr_step_dtls;
26: PER_SPINAL_POINT_STEPS_PKG.pop_flds(l_seq,p_effective_date,l_spinal_point_id,l_grade_spine_id);
27: IF l_seq IS NULL AND l_spinal_point IS NULL THEN
28: l_step_name := NULL;
29: ELSE
30: l_step_name := l_seq||'('||l_spinal_point||')';

Line 281: PER_SPINAL_POINT_STEPS_PKG.pop_flds(l_seq,p_effective_date,l_stp_name_rec.spinal_point_id,l_stp_name_rec.grade_spine_id);

277: l_stp_name_rec.grade_spine_id,
278: l_stp_name_rec.ib,
279: l_stp_name_rec.inm;
280: CLOSE csr_stp_name;
281: PER_SPINAL_POINT_STEPS_PKG.pop_flds(l_seq,p_effective_date,l_stp_name_rec.spinal_point_id,l_stp_name_rec.grade_spine_id);
282: l_name := l_seq||'('||l_stp_name_rec.spinal_point;
283: IF l_stp_name_rec.ib IS NOT NULL AND l_stp_name_rec.INM IS NOT NULL THEN
284: l_name := l_name||'| IB: '||l_stp_name_rec.ib||'| INM: '||l_stp_name_rec.inm;
285: END IF;