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_UTILITY_PVT

Line 171: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;

167: IF p_modifier_list_rec.offer_operation = 'CREATE' THEN
168: l_modifier_list_rec.offer_operation := 'CREATE';
169: l_modifier_list_rec.modifier_operation := 'CREATE';
170: l_modifier_list_rec.status_code := 'DRAFT';
171: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
172:
173: IF p_modifier_list_rec.OWNER_ID IS NULL OR p_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
174: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
175: ELSE

Line 174: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

170: l_modifier_list_rec.status_code := 'DRAFT';
171: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
172:
173: IF p_modifier_list_rec.OWNER_ID IS NULL OR p_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
174: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
175: ELSE
176: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
177: END IF;
178:

Line 203: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(p_modifier_list_rec.user_status_id);

199: IF p_modifier_list_rec.user_status_id IS NOT NULL AND p_modifier_list_rec.user_status_id <> fnd_api.g_miss_num THEN -- might have additional stage eg ACTIVE to go
200: l_modifier_list_rec.offer_operation := 'UPDATE';
201: l_modifier_list_rec.modifier_operation := 'UPDATE';
202: l_modifier_list_rec.user_status_id := p_modifier_list_rec.user_status_id;
203: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(p_modifier_list_rec.user_status_id);
204: ELSE -- creating draft offer hdr only
205: l_modifier_list_rec.offer_operation := fnd_api.g_miss_char;
206: l_modifier_list_rec.modifier_operation := fnd_api.g_miss_char;
207: l_modifier_list_rec.user_status_id := fnd_api.g_miss_num;

Line 1328: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;

1324: IF p_modifier_list_rec.offer_operation = 'CREATE' THEN
1325: l_modifier_list_rec.offer_operation := 'CREATE';
1326: l_modifier_list_rec.modifier_operation := 'CREATE';
1327: l_modifier_list_rec.status_code := 'DRAFT';
1328: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
1329:
1330: IF p_modifier_list_rec.OWNER_ID IS NULL OR p_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
1331: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
1332: ELSE

Line 1331: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

1327: l_modifier_list_rec.status_code := 'DRAFT';
1328: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
1329:
1330: IF p_modifier_list_rec.OWNER_ID IS NULL OR p_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
1331: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
1332: ELSE
1333: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
1334: END IF;
1335:

Line 1907: ,x_msg_tbl OUT NOCOPY OZF_Utility_PVT.ozf_msg_tbl_type

1903: ,p_modifier_rec IN modifier_list_rec_type
1904: ,p_modifier_line_tbl IN modifier_line_tbl_type
1905: ,x_qp_list_header_id OUT NOCOPY NUMBER
1906: ,x_error_location OUT NOCOPY NUMBER
1907: ,x_msg_tbl OUT NOCOPY OZF_Utility_PVT.ozf_msg_tbl_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';

Line 2051: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

2047: l_modifier_list_rec.offer_amount := NVL(p_modifier_rec.offer_amount,l_modifier_list_rec.lumpsum_amount);
2048: END IF;
2049:
2050: IF p_modifier_rec.distribution_type <> FND_API.g_miss_char AND p_modifier_rec.distribution_type IS NOT NULL THEN
2051: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
2052: p_lookup_table_name =>'OZF_LOOKUPS'
2053: ,p_lookup_type =>'OZF_LUMPSUM_DISTRIBUTION_TYPE'
2054: ,p_lookup_code => p_modifier_rec.distribution_type);
2055:

Line 2070: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

2066: l_modifier_list_rec.distribution_type := '%';
2067: END IF;
2068:
2069: IF p_modifier_rec.lumpsum_payment_type <> FND_API.g_miss_char AND p_modifier_rec.lumpsum_payment_type IS NOT NULL THEN
2070: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
2071: p_lookup_table_name =>'OZF_LOOKUPS'
2072: ,p_lookup_type =>'OZF_OFFER_LUMPSUM_PAYMENT'
2073: ,p_lookup_code => p_modifier_rec.lumpsum_payment_type);
2074:

Line 2207: l_modifier_list_rec.lumpsum_amount := OZF_UTILITY_PVT.CurrRound(l_modifier_list_rec.lumpsum_amount,l_modifier_list_rec.currency_code);

2203: l_modifier_list_rec.lumpsum_payment_type := NVL(p_modifier_rec.lumpsum_payment_type,Fnd_Api.g_miss_char);
2204: l_modifier_list_rec.offer_amount := NVL(p_modifier_rec.offer_amount,FND_API.g_miss_num);
2205:
2206: --Fix for Bug 16400081
2207: l_modifier_list_rec.lumpsum_amount := OZF_UTILITY_PVT.CurrRound(l_modifier_list_rec.lumpsum_amount,l_modifier_list_rec.currency_code);
2208: l_modifier_list_rec.offer_amount := OZF_UTILITY_PVT.CurrRound(l_modifier_list_rec.offer_amount,l_modifier_list_rec.currency_code);
2209:
2210: l_modifier_list_rec.budget_amount_tc := NVL(p_modifier_rec.budget_amount_tc, p_modifier_rec.offer_amount);
2211: l_modifier_list_rec.budget_amount_fc := NVL(p_modifier_rec.budget_amount_fc, p_modifier_rec.offer_amount);

Line 2208: l_modifier_list_rec.offer_amount := OZF_UTILITY_PVT.CurrRound(l_modifier_list_rec.offer_amount,l_modifier_list_rec.currency_code);

2204: l_modifier_list_rec.offer_amount := NVL(p_modifier_rec.offer_amount,FND_API.g_miss_num);
2205:
2206: --Fix for Bug 16400081
2207: l_modifier_list_rec.lumpsum_amount := OZF_UTILITY_PVT.CurrRound(l_modifier_list_rec.lumpsum_amount,l_modifier_list_rec.currency_code);
2208: l_modifier_list_rec.offer_amount := OZF_UTILITY_PVT.CurrRound(l_modifier_list_rec.offer_amount,l_modifier_list_rec.currency_code);
2209:
2210: l_modifier_list_rec.budget_amount_tc := NVL(p_modifier_rec.budget_amount_tc, p_modifier_rec.offer_amount);
2211: l_modifier_list_rec.budget_amount_fc := NVL(p_modifier_rec.budget_amount_fc, p_modifier_rec.offer_amount);
2212: l_modifier_list_rec.transaction_currency_code := NVL(p_modifier_rec.transaction_currency_code,p_modifier_rec.currency_code);

Line 2321: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS', 'DRAFT');

2317: -- create draft offer
2318: l_modifier_list_rec.offer_operation := 'CREATE';
2319: l_modifier_list_rec.modifier_operation := 'CREATE';
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

Line 2562: l_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS',p_modifier_rec.status_code);

2558:
2559: l_modifier_list_rec.offer_operation := 'UPDATE';
2560: l_modifier_list_rec.modifier_operation := 'UPDATE';
2561: l_modifier_list_rec.status_code := p_modifier_rec.status_code;
2562: l_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS',p_modifier_rec.status_code);
2563: l_modifier_list_rec.end_date_active := p_modifier_rec.end_date_active;
2564:
2565: l_modifier_line_tbl.DELETE;
2566: