DBA Data[Home] [Help]

APPS.AMS_EVHRULES_PVT dependencies on FND_PROFILE

Line 1745: , FND_PROFILE.Value('AS_DEFAULT_LEAD_STATUS') --STATUS_CODE -- VARCHAR2(30)

1741: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
1742: , 'LEAD_LOAD' --LOAD_TYPE -- VARCHAR2(20)
1743: , SYSDATE --LOAD_DATE --NOT NULL DATE
1744: , p_source_code --PROMOTION_CODE -- VARCHAR2(50)
1745: , FND_PROFILE.Value('AS_DEFAULT_LEAD_STATUS') --STATUS_CODE -- VARCHAR2(30)
1746: , 'Event Registrant is created as a lead.' --LEAD_NOTE -- VARCHAR2(2000)
1747: , 'MARKETING' --SOURCE_SYSTEM -- VARCHAR2(30)
1748: , l_party_type --PARTY_TYPE -- VARCHAR2(30)
1749: , p_lit_batch_id --BATCH_ID -- NUMBER(15)

Line 1779: l_curr_code := FND_PROFILE.Value(L_FUNC_CURR_PROF);

1775: L_FUNC_CURR_PROF CONSTANT VARCHAR2(30) := 'AMS_DEFAULT_CURR_CODE';
1776: l_curr_code VARCHAR2(240) ;
1777: l_return_status VARCHAR2(30);
1778: BEGIN
1779: l_curr_code := FND_PROFILE.Value(L_FUNC_CURR_PROF);
1780: IF l_curr_code IS NULL THEN
1781: l_curr_code := 'USD' ;
1782: END IF ;
1783:

Line 2545: l_org_id := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');

2541: inv_item_creation_error EXCEPTION;
2542:
2543: BEGIN
2544: x_return_status := FND_API.G_RET_STS_SUCCESS;
2545: l_org_id := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
2546: p_item_owner_rec.ORGANIZATION_ID := l_org_id;
2547: p_item_owner_rec.ITEM_NUMBER := p_item_number;
2548: p_item_owner_rec.OWNER_ID := p_user_id;
2549: p_item_owner_rec.is_master_item := 'Y';