DBA Data[Home] [Help]

APPS.PV_PG_MEMBERSHIPS_PVT dependencies on FND_PROFILE

Line 1499: l_default_program_id:= isnumber(FND_PROFILE.VALUE('PV_PARTNER_DEFAULT_PROGRAM'));

1495: FROM pv_partner_profiles
1496: WHERE partner_id=p_ptr_id;
1497:
1498: BEGIN
1499: l_default_program_id:= isnumber(FND_PROFILE.VALUE('PV_PARTNER_DEFAULT_PROGRAM'));
1500: IF (l_default_program_id is NOT NULL) AND (l_default_program_id =p_program_id) THEN
1501: OPEN pstatus_cur(p_partner_id);
1502: FETCH pstatus_cur into l_relationship;
1503: CLOSE pstatus_cur;

Line 2076: l_default_program_id := isnumber(FND_PROFILE.VALUE('PV_PARTNER_DEFAULT_PROGRAM'));

2072: RAISE FND_API.G_EXC_ERROR;
2073: END IF;
2074:
2075: --validate status reason code
2076: l_default_program_id := isnumber(FND_PROFILE.VALUE('PV_PARTNER_DEFAULT_PROGRAM'));
2077: -- get all the membership to be terminated into a table of memberships
2078:
2079: FOR membs in memb_csr( p_partner_id ) LOOP
2080: IF p_status_reason_code= 'MEMBER_TYPE_CHANGE' THEN