DBA Data[Home] [Help]

APPS.OKC_PRICE_ADJUSTMENT_PVT dependencies on OKC_PRICE_ADJUSTMENT_PUB

Line 100: l_patv_rec okc_price_adjustment_PUB.patv_rec_type; --for price adjustments

96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_patv_rec IN patv_rec_type) IS
99:
100: l_patv_rec okc_price_adjustment_PUB.patv_rec_type; --for price adjustments
101: l_pacv_rec okc_price_adjustment_PUB.pacv_rec_type; --for price adjustment assoc
102: l_pavv_rec okc_price_adjustment_PUB.paav_rec_type; --for price adjustment attributes
103:
104: --cursor to fetch the child lines

Line 101: l_pacv_rec okc_price_adjustment_PUB.pacv_rec_type; --for price adjustment assoc

97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_patv_rec IN patv_rec_type) IS
99:
100: l_patv_rec okc_price_adjustment_PUB.patv_rec_type; --for price adjustments
101: l_pacv_rec okc_price_adjustment_PUB.pacv_rec_type; --for price adjustment assoc
102: l_pavv_rec okc_price_adjustment_PUB.paav_rec_type; --for price adjustment attributes
103:
104: --cursor to fetch the child lines
105: CURSOR l_padj_csr IS

Line 102: l_pavv_rec okc_price_adjustment_PUB.paav_rec_type; --for price adjustment attributes

98: p_patv_rec IN patv_rec_type) IS
99:
100: l_patv_rec okc_price_adjustment_PUB.patv_rec_type; --for price adjustments
101: l_pacv_rec okc_price_adjustment_PUB.pacv_rec_type; --for price adjustment assoc
102: l_pavv_rec okc_price_adjustment_PUB.paav_rec_type; --for price adjustment attributes
103:
104: --cursor to fetch the child lines
105: CURSOR l_padj_csr IS
106: SELECT A.id,A.chr_id,A.cle_id

Line 145: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adjustment(

141: l_patv_rec.chr_id := padj_rec.chr_id;
142: l_patv_rec.cle_id := padj_rec.cle_id;
143:
144: -- Delete all child records from OKC__PRICE_ADJUSTMENTS.
145: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adjustment(
146: p_api_version => p_api_version,
147: p_init_msg_list => p_init_msg_list,
148: x_return_status => x_return_status,
149: x_msg_count => x_msg_count,

Line 164: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_assoc(

160: For assoc_rec In l_assoc_csr Loop
161: l_pacv_rec.id := assoc_rec.id;
162:
163: -- Delete related records from OKC_PRICE_ADJ_ASSOCS_V
164: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_assoc(
165: p_api_version => p_api_version,
166: p_init_msg_list => p_init_msg_list,
167: x_return_status => x_return_status,
168: x_msg_count => x_msg_count,

Line 183: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_attrib(

179: For attrib_rec In l_attrib_csr Loop
180: l_pavv_rec.id := attrib_rec.id;
181:
182: --Delete related records in OKC_PRICE_ADJ_ATTRIBS_V
183: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_attrib(
184: p_api_version => p_api_version,
185: p_init_msg_list => p_init_msg_list,
186: x_return_status => x_return_status,
187: x_msg_count => x_msg_count,