APPS.AHL_APPROVAL_RULES_PKG dependencies on AHL_APPROVAL_RULES_B

Line 47: cursor C is Select ROWID from AHL_APPROVAL_RULES_B where

43: )
44:
45: is
46:
47: cursor C is Select ROWID from AHL_APPROVAL_RULES_B where
48:
49: APPROVAL_RULE_ID = X_APPROVAL_RULE_ID ;
50:
51: begin

Line 53: insert into AHL_APPROVAL_RULES_B

49: APPROVAL_RULE_ID = X_APPROVAL_RULE_ID ;
50:
51: begin
52:
53: insert into AHL_APPROVAL_RULES_B
54:
55: (
56: APPROVAL_RULE_ID,
57: OBJECT_VERSION_NUMBER,

Line 303: from AHL_APPROVAL_RULES_B

299: ATTRIBUTE14,
300:
301: ATTRIBUTE15
302:
303: from AHL_APPROVAL_RULES_B
304:
305: where APPROVAL_RULE_ID = X_APPROVAL_RULE_ID
306:
307: for update of APPROVAL_RULE_ID nowait;

Line 555: update AHL_APPROVAL_RULES_B set

551: begin
552:
553:
554:
555: update AHL_APPROVAL_RULES_B set
556:
557: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
558:
559: APPROVAL_OBJECT_CODE = X_APPROVAL_OBJECT_CODE,

Line 685: delete from AHL_APPROVAL_RULES_B

681: end if;
682:
683:
684:
685: delete from AHL_APPROVAL_RULES_B
686:
687: where APPROVAL_RULE_ID = X_APPROVAL_RULE_ID;
688:
689:

Line 713: from AHL_APPROVAL_RULES_B B

709: where not exists
710:
711: (select NULL
712:
713: from AHL_APPROVAL_RULES_B B
714:
715: where B.APPROVAL_RULE_ID = T.APPROVAL_RULE_ID
716:
717: );

Line 900: from AHL_APPROVAL_RULES_B

896:
897:
898: cursor c_obj_verno is
899: select object_version_number
900: from AHL_APPROVAL_RULES_B
901: where approval_rule_id = X_APPROVAL_RULE_ID;
902:
903: cursor c_chk_rule_exists is
904: select 'x'

Line 905: from AHL_APPROVAL_RULES_B

901: where approval_rule_id = X_APPROVAL_RULE_ID;
902:
903: cursor c_chk_rule_exists is
904: select 'x'
905: from AHL_APPROVAL_RULES_B
906: where approval_rule_id = X_APPROVAL_RULE_ID;
907:
908: cursor c_get_rule_id is
909: select ahl_approval_rules_b_s.nextval

Line 909: select ahl_approval_rules_b_s.nextval

905: from AHL_APPROVAL_RULES_B
906: where approval_rule_id = X_APPROVAL_RULE_ID;
907:
908: cursor c_get_rule_id is
909: select ahl_approval_rules_b_s.nextval
910: from dual;
911:
912:
913: BEGIN