eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_PUB dependencies on OZF_OFFER_PVT

Line 50: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

46: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
47: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
48: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
49: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
50: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
51: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
52: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
53: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
54: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 51: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

47: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
48: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
49: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
50: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
51: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
52: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
53: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
54: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
55:

Line 52: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;

48: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
49: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
50: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
51: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
52: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
53: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
54: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
55:
56: CURSOR c_offer_info(l_qp_list_header_id NUMBER) IS

Line 53: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;

49: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
50: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
51: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
52: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
53: l_exclusion_tbl ozf_offer_pvt.pricing_attr_tbl_type;
54: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
55:
56: CURSOR c_offer_info(l_qp_list_header_id NUMBER) IS
57: SELECT offer_id, offer_type, custom_setup_id, offer_code, tier_level, object_version_number

Line 179: Ozf_Offer_Pvt.process_modifiers(

175: ELSE
176: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
177: END IF;
178:
179: Ozf_Offer_Pvt.process_modifiers(
180: p_init_msg_list => p_init_msg_list
181: ,p_api_version => p_api_version
182: ,p_commit => p_commit
183: ,x_return_status => x_return_status

Line 316: ozf_offer_pvt.process_exclusions(

312: END LOOP;
313: END IF;
314:
315: IF l_exclusion_tbl.COUNT > 0 THEN
316: ozf_offer_pvt.process_exclusions(
317: p_init_msg_list => p_init_msg_list
318: ,p_api_version => p_api_version
319: ,p_commit => p_commit
320: ,x_return_status => x_return_status

Line 903: Ozf_Offer_Pvt.process_modifiers(

899: END LOOP;
900: END IF;
901: END IF; -- end offer_type
902:
903: Ozf_Offer_Pvt.process_modifiers(
904: p_init_msg_list => p_init_msg_list
905: ,p_api_version => p_api_version
906: ,p_commit => p_commit
907: ,x_return_status => x_return_status

Line 1045: Ozf_Offer_Pvt.process_market_qualifiers(

1041: l_qualifiers_tbl(i).attribute14 := p_qualifier_tbl(i).attribute14;
1042: l_qualifiers_tbl(i).attribute15 := p_qualifier_tbl(i).attribute15;
1043: END LOOP;
1044:
1045: Ozf_Offer_Pvt.process_market_qualifiers(
1046: p_init_msg_list => p_init_msg_list
1047: ,p_api_version => p_api_version
1048: ,p_commit => p_commit
1049: ,x_return_status => x_return_status

Line 1134: Ozf_Offer_Pvt.process_modifiers(

1130: END IF;
1131: END LOOP;
1132: END IF;
1133: /*
1134: Ozf_Offer_Pvt.process_modifiers(
1135: p_init_msg_list => p_init_msg_list
1136: ,p_api_version => p_api_version
1137: ,p_commit => p_commit
1138: ,x_return_status => x_return_status

Line 1217: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

1213:
1214: l_api_version CONSTANT NUMBER := 1.0;
1215: l_api_name CONSTANT VARCHAR2(30) := 'process_vo';
1216:
1217: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1218: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1219: l_qualifier_rec ozf_offer_pvt.qualifiers_rec_type;
1220: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1221: l_vo_pbh_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

Line 1218: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

1214: l_api_version CONSTANT NUMBER := 1.0;
1215: l_api_name CONSTANT VARCHAR2(30) := 'process_vo';
1216:
1217: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1218: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1219: l_qualifier_rec ozf_offer_pvt.qualifiers_rec_type;
1220: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1221: l_vo_pbh_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;
1222: l_vo_dis_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

Line 1219: l_qualifier_rec ozf_offer_pvt.qualifiers_rec_type;

1215: l_api_name CONSTANT VARCHAR2(30) := 'process_vo';
1216:
1217: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1218: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1219: l_qualifier_rec ozf_offer_pvt.qualifiers_rec_type;
1220: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1221: l_vo_pbh_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;
1222: l_vo_dis_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;
1223: l_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;

Line 1336: Ozf_Offer_Pvt.process_modifiers(

1332: ELSE
1333: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
1334: END IF;
1335:
1336: Ozf_Offer_Pvt.process_modifiers(
1337: p_init_msg_list => p_init_msg_list
1338: ,p_api_version => p_api_version
1339: ,p_commit => p_commit
1340: ,x_return_status => x_return_status

Line 1455: /* Ozf_Offer_Pvt.process_market_qualifiers(

1451: END IF;
1452: END IF;
1453: END LOOP;
1454:
1455: /* Ozf_Offer_Pvt.process_market_qualifiers(
1456: p_init_msg_list => p_init_msg_list
1457: ,p_api_version => p_api_version
1458: ,p_commit => p_commit
1459: ,x_return_status => x_return_status

Line 1828: Ozf_Offer_Pvt.process_modifiers(

1824: END IF;
1825: END LOOP;
1826: END IF; -- end market options
1827:
1828: Ozf_Offer_Pvt.process_modifiers(
1829: p_init_msg_list => p_init_msg_list
1830: ,p_api_version => p_api_version
1831: ,p_commit => p_commit
1832: ,x_return_status => x_return_status

Line 1912: l_modifier_list_rec OZF_OFFER_PVT.modifier_list_rec_type;

1908: ,x_line_tbl OUT NOCOPY list_line_tbl_type
1909: ) IS
1910: l_api_version CONSTANT NUMBER := 1.0;
1911: l_api_name VARCHAR2(90) := 'process_offer_from_adapter';
1912: l_modifier_list_rec OZF_OFFER_PVT.modifier_list_rec_type;
1913: l_modifier_line_tbl OZF_OFFER_PVT.modifier_line_tbl_type;
1914: l_act_product_rec AMS_ACTPRODUCT_PVT.act_product_rec_type;
1915: l_act_product_id NUMBER;
1916: l_lumpsum_distr_value NUMBER;

Line 1913: l_modifier_line_tbl OZF_OFFER_PVT.modifier_line_tbl_type;

1909: ) IS
1910: l_api_version CONSTANT NUMBER := 1.0;
1911: l_api_name VARCHAR2(90) := 'process_offer_from_adapter';
1912: l_modifier_list_rec OZF_OFFER_PVT.modifier_list_rec_type;
1913: l_modifier_line_tbl OZF_OFFER_PVT.modifier_line_tbl_type;
1914: l_act_product_rec AMS_ACTPRODUCT_PVT.act_product_rec_type;
1915: l_act_product_id NUMBER;
1916: l_lumpsum_distr_value NUMBER;
1917: l_user_id NUMBER := fnd_api.g_miss_num;

Line 2324: OZF_OFFER_PVT.process_modifiers

2320: l_modifier_list_rec.status_code := 'DRAFT';
2321: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS', 'DRAFT');
2322:
2323: --//Create Offer Call
2324: OZF_OFFER_PVT.process_modifiers
2325: ( p_init_msg_list => p_init_msg_list
2326: , p_api_version => p_api_version
2327: , p_commit => p_commit
2328: , x_return_status => x_return_status

Line 2509: Ozf_Offer_Pvt.process_modifiers

2505: CLOSE c_uom;
2506:
2507: l_modifier_line_tbl(l_line_index).product_uom_code := l_uom;
2508: END LOOP;
2509: Ozf_Offer_Pvt.process_modifiers
2510: ( p_init_msg_list => p_init_msg_list
2511: , p_api_version => p_api_version
2512: , p_commit => p_commit
2513: , x_return_status => x_return_status

Line 2567: Ozf_Offer_Pvt.process_modifiers

2563: l_modifier_list_rec.end_date_active := p_modifier_rec.end_date_active;
2564:
2565: l_modifier_line_tbl.DELETE;
2566:
2567: Ozf_Offer_Pvt.process_modifiers
2568: ( p_init_msg_list => p_init_msg_list
2569: , p_api_version => p_api_version
2570: , p_commit => p_commit
2571: , x_return_status => x_return_status