DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_LINE_PVT dependencies on OZF_OFFER_PVT

Line 89: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type

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

Line 99: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )

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

Line 126: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )

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

Line 242: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )

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

Line 576: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;

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

Line 671: ozf_offer_pvt.process_qp_list_lines(

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

Line 1111: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;

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

Line 1184: ozf_offer_pvt.process_qp_list_lines(

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