APPS.AMS_STATUS_ORDER_RULES_PKG dependencies on AMS_STATUS_ORDER_RULES_S

Line 80: update AMS_STATUS_ORDER_RULES set

76: X_LAST_UPDATE_LOGIN in NUMBER,
77: X_APPLICATION_ID in NUMBER DEFAULT '530'
78: ) is
79: begin
80: update AMS_STATUS_ORDER_RULES set
81: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
82: SYSTEM_STATUS_TYPE = X_SYSTEM_STATUS_TYPE,
83: CURRENT_STATUS_CODE = X_CURRENT_STATUS_CODE,
84: NEXT_STATUS_CODE = X_NEXT_STATUS_CODE,

Line 141: select ams_status_order_rules_s.nextval

137: from AMS_STATUS_ORDER_RULES
138: where status_order_rule_id = X_STATUS_ORDER_RULE_ID;
139:
140: cursor c_get_stsid is
141: select ams_status_order_rules_s.nextval
142: from dual;
143:
144: BEGIN
145: