1 PACKAGE BODY OE_7PC2_LINE_ATOCOMP AS
2 PROCEDURE Is_Valid
3 (
4 p_application_id in number,
5 p_entity_short_name in varchar2,
6 p_validation_entity_short_name in varchar2,
7 p_validation_tmplt_short_name in varchar2,
8 p_record_set_short_name in varchar2,
9 p_scope in varchar2,
10 x_result out nocopy number
11 )
12 IS
13 l_valid_count NUMBER := 0;
14 l_set_count NUMBER := 0;
15
16 CURSOR C_VC IS
17 SELECT count(*)
18 FROM OE_AK_ORDER_LINES_V a
19 WHERE a.LINE_ID = OE_LINE_SCREDIT_SECURITY.g_record.LINE_ID
20 AND a.ATO_LINE_ID IS NOT NULL
21 AND a.ITEM_TYPE_CODE <> 'STANDARD'
22 ;
23
24
25 BEGIN
26 x_result := 0;
27 OPEN C_VC;
28 FETCH C_VC into l_valid_count;
29 CLOSE C_VC;
30 If (l_valid_count > 0) then
31 x_result := 1;
32 End If;
33 Return;
34 END Is_Valid;
35 END OE_7PC2_LINE_ATOCOMP;