DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_LINE_PVT dependencies on OZF_OFFER_PVT

Line 90: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type

86: /*
87: This method sets the default values for creating offer discount rules
88: */
89: PROCEDURE complete_rec_for_create(
90: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type
91: )
92: IS
93: BEGIN
94: p_modifier_line_rec.list_line_id := FND_API.g_miss_num;

Line 100: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )

96: END complete_rec_for_create;
97:
98:
99: PROCEDURE populate_volume_offer(p_list_line_rec IN offadj_new_line_rec_type,
100: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )
101: IS
102: CURSOR c_tier_data (p_list_header_id NUMBER) IS
103: SELECT discount , discount_type_code , uom_code , volume_type , tier_value_from , active,tier_value_to FROM ozf_volume_offer_tiers
104: WHERE qp_list_header_id = p_list_header_id

Line 127: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )

123: END populate_volume_offer;
124:
125:
126: PROCEDURE populate_new_adj_rec(p_list_line_rec IN offadj_new_line_rec_type,
127: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )
128: IS
129: CURSOR c_offer_type (p_list_header_id IN NUMBER) IS
130: SELECT offer_type
131: FROM ozf_offers

Line 243: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )

239:
240:
241:
242: PROCEDURE populate_pro_good_get_rec(p_list_line_rec IN offadj_new_line_rec_type,
243: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )
244: IS
245: BEGIN
246: P_modifier_line_rec.list_line_type_code := 'DIS';
247: p_modifier_line_rec.list_line_id := FND_API.G_MISS_NUM;

Line 577: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;

573: l_offer_adjustment_line_id NUMBER;
574: l_dummy NUMBER;
575: l_offer_type OZF_OFFERS.OFFER_TYPE%TYPE;
576: l_error_loc NUMBER;
577: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;
578: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
579: l_offadj_line_rec offadj_line_rec_type ;
580:
581: i number := 1;

Line 672: ozf_offer_pvt.process_qp_list_lines(

668: debug_message('uom code is :'||l_modifier_line_tbl(i).product_uom_code);
669: --================================================================
670: -- create discount rule in qp
671: --================================================================
672: ozf_offer_pvt.process_qp_list_lines(
673: x_return_status => x_return_status,
674: x_msg_count => x_msg_count,
675: x_msg_data => x_msg_data,
676: p_offer_type => l_offer_type,

Line 1112: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;

1108: l_dummy NUMBER;
1109: l_offer_type OZF_OFFERS.OFFER_TYPE%TYPE;
1110: l_error_loc NUMBER;
1111:
1112: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;
1113: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1114: l_offadj_line_rec offadj_line_rec_type ;
1115:
1116: i number := 1;

Line 1185: ozf_offer_pvt.process_qp_list_lines(

1181:
1182: --==========================================================================
1183: -- create discount rule in qp
1184: --==========================================================================
1185: ozf_offer_pvt.process_qp_list_lines(
1186: x_return_status => x_return_status,
1187: x_msg_count => x_msg_count,
1188: x_msg_data => x_msg_data,
1189: p_offer_type => l_offer_type,