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 1582: l_inv_profile := FND_PROFILE.Value('AMS_INV_API_CALLOUT');--'Y';

1578: -- get values of profile options to call inv/qp profile options.
1579: -- By default we will call the inv/qp api. We will not call the api
1580: -- only if user explicitly set this profile option to 'N'
1581:
1582: l_inv_profile := FND_PROFILE.Value('AMS_INV_API_CALLOUT');--'Y';
1583: l_qp_profile := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');--'Y';
1584:
1585: -- changed the profile option defaults to 'N'
1586: IF l_inv_profile IS NULL THEN

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

1579: -- By default we will call the inv/qp api. We will not call the api
1580: -- only if user explicitly set this profile option to 'N'
1581:
1582: l_inv_profile := FND_PROFILE.Value('AMS_INV_API_CALLOUT');--'Y';
1583: l_qp_profile := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');--'Y';
1584:
1585: -- changed the profile option defaults to 'N'
1586: IF l_inv_profile IS NULL THEN
1587: l_inv_profile := 'N';

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

2874: from ams_deliv_kit_items
2875: where deliverable_kit_part_id = l_deliverable_id;
2876:
2877: l_kits_check NUMBER;
2878: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');
2879:
2880: BEGIN
2881:
2882: IF l_qp_profile IS NULL THEN

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

4014:
4015: p_price_list_rec.name := 'Deliverable Inventory HDR';
4016: p_price_list_rec.created_by := p_deliv_rec.owner_user_id;
4017: p_price_list_rec.creation_date := sysdate;
4018: p_price_list_rec.currency_code := FND_PROFILE.Value('AMS_DEFAULT_CURR_CODE');
4019: p_price_list_rec.list_type_code := 'PRL';
4020: p_price_list_rec.description := 'Deliverable Inventory HDR';
4021: p_price_list_rec.start_date_active := p_deliv_rec.actual_avail_from_date;
4022: --p_price_list_rec.end_date_active := p_deliv_rec.actual_avail_to_date;

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

4387: FROM ams_deliverables_all_b
4388: WHERE deliverable_id = deliv_id;
4389:
4390: l_get_period_cur c_get_period_Dets%ROWTYPE;
4391: l_deliverable_calendar VARCHAR2(15) := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
4392:
4393:
4394: BEGIN
4395:

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

4403: OR ( NVL(l_get_period_cur.end_period_name,'$$') <> NVL(p_deliv_rec.end_period_name,'$$') ))
4404: THEN
4405:
4406: IF ( NVL(l_get_period_cur.deliverable_calendar,'**') <> NVL(l_deliverable_calendar, '**') ) THEN
4407: x_deliverable_calendar := FND_PROFILE.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
4408: ELSE
4409: x_deliverable_calendar := l_get_period_cur.deliverable_calendar;
4410: END IF;
4411: ELSE

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

4597: x_item_rec AMS_ITEM_OWNER_PVT.ITEM_REC_TYPE; --INV_Item_GRP.Item_rec_type;
4598: x_error_tbl AMS_ITEM_OWNER_PVT.Error_tbl_type; --INV_Item_GRP.Error_tbl_type;
4599: l_item_owner_rec AMS_ITEM_OWNER_PVT.ITEM_OWNER_Rec_Type;
4600:
4601: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');
4602: l_org_Id NUMBER := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
4603:
4604: x_item_return_status Varchar2(1) ;
4605: x_item_owner_id NUMBER;

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

4598: x_error_tbl AMS_ITEM_OWNER_PVT.Error_tbl_type; --INV_Item_GRP.Error_tbl_type;
4599: l_item_owner_rec AMS_ITEM_OWNER_PVT.ITEM_OWNER_Rec_Type;
4600:
4601: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');
4602: l_org_Id NUMBER := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
4603:
4604: x_item_return_status Varchar2(1) ;
4605: x_item_owner_id NUMBER;
4606:

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

4649: l_item_owner_rec.owner_id := p_deliv_rec.owner_user_id;
4650:
4651: l_item_rec.item_number := p_deliv_rec.item_number;
4652: --l_item_rec.segment1 := 'DELIV'||p_deliv_rec.deliverable_id;
4653: l_item_rec.organization_id := FND_PROFILE.Value ('AMS_ITEM_ORGANIZATION_ID'); -- new org_id
4654:
4655: l_item_rec.description := 'DELIV-'||p_deliv_rec.deliverable_name;
4656: l_item_rec.long_description := 'DELIV-'||p_deliv_rec.description;
4657: l_item_rec.collateral_flag := 'Y';