DBA Data[Home] [Help]

APPS.AMS_STATUS_ORDER_RULES_PKG dependencies on AMS_STATUS_ORDER_RULES_PKG

Line 1: package body AMS_STATUS_ORDER_RULES_PKG as

1: package body AMS_STATUS_ORDER_RULES_PKG as
2: /* $Header: amslstsb.pls 115.4 2002/11/16 01:44:37 dbiswas ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_STATUS_ORDER_RULE_ID in NUMBER,

Line 166: AMS_STATUS_ORDER_RULES_PKG.INSERT_ROW (

162: end if ;
163:
164: l_obj_verno := 1;
165:
166: AMS_STATUS_ORDER_RULES_PKG.INSERT_ROW (
167: X_ROWID => l_row_id ,
168: X_STATUS_ORDER_RULE_ID => l_sts_id,
169: X_OBJECT_VERSION_NUMBER => l_obj_verno,
170: X_SYSTEM_STATUS_TYPE => X_SYSTEM_STATUS_TYPE,

Line 190: AMS_STATUS_ORDER_RULES_PKG.UPDATE_ROW(

186: open c_obj_verno;
187: fetch c_obj_verno into l_obj_verno;
188: close c_obj_verno;
189:
190: AMS_STATUS_ORDER_RULES_PKG.UPDATE_ROW(
191: X_STATUS_ORDER_RULE_ID => X_STATUS_ORDER_RULE_ID,
192: X_OBJECT_VERSION_NUMBER => l_obj_verno + 1,
193: X_SYSTEM_STATUS_TYPE => X_SYSTEM_STATUS_TYPE,
194: X_CURRENT_STATUS_CODE => X_CURRENT_STATUS_CODE,

Line 208: end AMS_STATUS_ORDER_RULES_PKG;

204: end if;
205:
206: END LOAD_ROW ;
207:
208: end AMS_STATUS_ORDER_RULES_PKG;