DBA Data[Home] [Help]

APPS.AHL_STATUS_ORDER_RULES_PKG dependencies on AHL_STATUS_ORDER_RULES_S

Line 64: update AHL_STATUS_ORDER_RULES set

60: X_LAST_UPDATED_BY in NUMBER,
61: X_LAST_UPDATE_LOGIN in NUMBER
62: ) is
63: begin
64: update AHL_STATUS_ORDER_RULES set
65: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
66: SYSTEM_STATUS_TYPE = X_SYSTEM_STATUS_TYPE,
67: CURRENT_STATUS_CODE = X_CURRENT_STATUS_CODE,
68: NEXT_STATUS_CODE = X_NEXT_STATUS_CODE,

Line 117: select ahl_status_order_rules_s.nextval

113: from AHL_STATUS_ORDER_RULES
114: where status_order_rule_id = X_STATUS_ORDER_RULE_ID;
115:
116: cursor c_get_stsid is
117: select ahl_status_order_rules_s.nextval
118: from dual;
119:
120: BEGIN
121: