70: l_salesgroup_id NUMBER;
71: l_resource_id NUMBER;
72:
73: BEGIN
74: -- Standard Start of API savepoint
75: SAVEPOINT GET_SCORE_PVT;
76:
77: -- Standard call to check for call compatibility.
78: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
73: BEGIN
74: -- Standard Start of API savepoint
75: SAVEPOINT GET_SCORE_PVT;
76:
77: -- Standard call to check for call compatibility.
78: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
79: p_api_version,
80: l_api_name,
81: G_PKG_NAME)
137: --
138: -- End of API body
139: --
140:
141: -- Standard check for p_commit
142: IF FND_API.to_Boolean( p_commit )
143: THEN
144: COMMIT WORK;
145: END IF;
408: -- swkhanna 2260459
409: l_marketing_score NUMBER := p_marketing_score;
410:
411: BEGIN
412: -- Standard Start of API savepoint
413: SAVEPOINT GET_SCORE_PVT;
414:
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
411: BEGIN
412: -- Standard Start of API savepoint
413: SAVEPOINT GET_SCORE_PVT;
414:
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
417: p_api_version,
418: l_api_name,
419: G_PKG_NAME)
550: -- if-then-else below added to return a warning if no valid scorecard
551: -- is found
552: if l_return_status <> 'W' then -- kmahajan 5/5/1
553:
554: -- USER HOOK standard : customer pre-processing section - mandatory
555: l_call_user_hook := JTF_USR_HKS.Ok_to_execute('AS_SCORECARD_PVT',
556: 'GET_SCORE','B','C');
557:
558: IF l_call_user_hook
986: --
987: -- End of API body
988: --
989:
990: -- Standard check for p_commit
991: IF FND_API.to_Boolean( p_commit )
992: THEN
993: COMMIT WORK;
994: END IF;