DBA Data[Home] [Help]

APPS.AMS_DELIVERABLE_PVT dependencies on FND_PROFILE

Line 325: l_deliv_rec.deliverable_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

321: OR (l_deliv_rec.end_period_name IS NOT NULL)) THEN
322:
323: -- default deliverable_calendar
324: IF l_deliv_rec.deliverable_calendar IS NULL THEN
325: l_deliv_rec.deliverable_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
326: END IF;
327:
328: END IF;
329:

Line 1569: l_inv_profile := FND_PROFILE.Value('AMS_INV_API_CALLOUT');--'Y';

1565: -- get values of profile options to call inv/qp profile options.
1566: -- By default we will call the inv/qp api. We will not call the api
1567: -- only if user explicitly set this profile option to 'N'
1568:
1569: l_inv_profile := FND_PROFILE.Value('AMS_INV_API_CALLOUT');--'Y';
1570: l_qp_profile := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');--'Y';
1571:
1572: -- changed the profile option defaults to 'N'
1573: IF l_inv_profile IS NULL THEN

Line 1570: l_qp_profile := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');--'Y';

1566: -- By default we will call the inv/qp api. We will not call the api
1567: -- only if user explicitly set this profile option to 'N'
1568:
1569: l_inv_profile := FND_PROFILE.Value('AMS_INV_API_CALLOUT');--'Y';
1570: l_qp_profile := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');--'Y';
1571:
1572: -- changed the profile option defaults to 'N'
1573: IF l_inv_profile IS NULL THEN
1574: l_inv_profile := 'N';

Line 2865: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');

2861: from ams_deliv_kit_items
2862: where deliverable_kit_part_id = l_deliverable_id;
2863:
2864: l_kits_check NUMBER;
2865: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');
2866:
2867: BEGIN
2868:
2869: IF l_qp_profile IS NULL THEN

Line 4005: p_price_list_rec.currency_code := FND_PROFILE.Value('AMS_DEFAULT_CURR_CODE');

4001:
4002: p_price_list_rec.name := 'Deliverable Inventory HDR';
4003: p_price_list_rec.created_by := p_deliv_rec.owner_user_id;
4004: p_price_list_rec.creation_date := sysdate;
4005: p_price_list_rec.currency_code := FND_PROFILE.Value('AMS_DEFAULT_CURR_CODE');
4006: p_price_list_rec.list_type_code := 'PRL';
4007: p_price_list_rec.description := 'Deliverable Inventory HDR';
4008: p_price_list_rec.start_date_active := p_deliv_rec.actual_avail_from_date;
4009: --p_price_list_rec.end_date_active := p_deliv_rec.actual_avail_to_date;

Line 4378: l_deliverable_calendar VARCHAR2(15) := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

4374: FROM ams_deliverables_all_b
4375: WHERE deliverable_id = deliv_id;
4376:
4377: l_get_period_cur c_get_period_Dets%ROWTYPE;
4378: l_deliverable_calendar VARCHAR2(15) := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
4379:
4380:
4381: BEGIN
4382:

Line 4394: x_deliverable_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

4390: OR ( NVL(l_get_period_cur.end_period_name,'$$') <> NVL(p_deliv_rec.end_period_name,'$$') ))
4391: THEN
4392:
4393: IF ( NVL(l_get_period_cur.deliverable_calendar,'**') <> NVL(l_deliverable_calendar, '**') ) THEN
4394: x_deliverable_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
4395: ELSE
4396: x_deliverable_calendar := l_get_period_cur.deliverable_calendar;
4397: END IF;
4398: ELSE

Line 4588: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');

4584: x_item_rec AMS_ITEM_OWNER_PVT.ITEM_REC_TYPE; --INV_Item_GRP.Item_rec_type;
4585: x_error_tbl AMS_ITEM_OWNER_PVT.Error_tbl_type; --INV_Item_GRP.Error_tbl_type;
4586: l_item_owner_rec AMS_ITEM_OWNER_PVT.ITEM_OWNER_Rec_Type;
4587:
4588: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');
4589: l_org_Id NUMBER := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
4590:
4591: x_item_return_status Varchar2(1) ;
4592: x_item_owner_id NUMBER;

Line 4589: l_org_Id NUMBER := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');

4585: x_error_tbl AMS_ITEM_OWNER_PVT.Error_tbl_type; --INV_Item_GRP.Error_tbl_type;
4586: l_item_owner_rec AMS_ITEM_OWNER_PVT.ITEM_OWNER_Rec_Type;
4587:
4588: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');
4589: l_org_Id NUMBER := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
4590:
4591: x_item_return_status Varchar2(1) ;
4592: x_item_owner_id NUMBER;
4593:

Line 4640: l_item_rec.organization_id := FND_PROFILE.Value ('AMS_ITEM_ORGANIZATION_ID'); -- new org_id

4636: l_item_owner_rec.owner_id := p_deliv_rec.owner_user_id;
4637:
4638: l_item_rec.item_number := p_deliv_rec.item_number;
4639: --l_item_rec.segment1 := 'DELIV'||p_deliv_rec.deliverable_id;
4640: l_item_rec.organization_id := FND_PROFILE.Value ('AMS_ITEM_ORGANIZATION_ID'); -- new org_id
4641:
4642: l_item_rec.description := 'DELIV-'||p_deliv_rec.deliverable_name;
4643: l_item_rec.long_description := 'DELIV-'||p_deliv_rec.description;
4644: l_item_rec.collateral_flag := 'Y';