94: and lkp1.lookup_type = 'OZF_OFFER_TYPE';
95:
96:
97: BEGIN
98: ozf_utility_pvt.debug_message (
99: l_api_name
100: || 'Entering'
101: || 'document id '
102: || document_id
266: and lkp1.lookup_type = 'OZF_OFFER_TYPE';
267:
268:
269: BEGIN
270: ozf_utility_pvt.debug_message (
271: l_api_name
272: || 'Entering'
273: || 'document id '
274: || document_id
439: and lkp1.lookup_type = 'OZF_OFFER_TYPE';
440:
441:
442: BEGIN
443: ozf_utility_pvt.debug_message (
444: l_api_name
445: || 'Entering'
446: || 'document id '
447: || document_id
615: and lkp1.lookup_type = 'OZF_OFFER_TYPE';
616:
617:
618: BEGIN
619: ozf_utility_pvt.debug_message (
620: l_api_name
621: || 'Entering'
622: || 'document id '
623: || document_id
789: and lkp1.lookup_type = 'OZF_OFFER_TYPE';
790:
791:
792: BEGIN
793: ozf_utility_pvt.debug_message (
794: l_api_name
795: || 'Entering'
796: || 'document id '
797: || document_id
1138: );
1139:
1140: -- BUG 2352621
1141:
1142: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','OFFRADJ');
1143:
1144: wf_engine.setitemattrtext (
1145: itemtype=> itemtype,
1146: itemkey=> itemkey,
1313:
1314: IF l_approval_status = 'APPROVED' THEN
1315:
1316: l_next_status_code := 'ACTIVE';
1317: ozf_utility_pvt.debug_message ( l_full_name || l_approval_status);
1318:
1319: ELSIF l_approval_status = 'REJECTED' THEN
1320:
1321: l_next_status_code := 'REJECTED';
1343: OPEN c_effective_date(l_offer_adjustment_id);
1344: FETCH c_effective_date INTO l_effective_date;
1345: CLOSE c_effective_date;
1346:
1347: ozf_utility_pvt.debug_message ( l_full_name || l_next_status_code || l_approval_status);
1348:
1349: IF ( l_next_status_code = 'ACTIVE' )
1350: THEN
1351: -- IF (l_effective_date < SYSDATE) THEN
1420: p_encoded=> fnd_api.g_false,
1421: p_count=> l_msg_count,
1422: p_data=> l_msg_data
1423: );
1424: ozf_utility_pvt.debug_message (
1425: l_full_name
1426: || ': l_return_status'
1427: || l_return_status
1428: );