DBA Data[Home] [Help]

APPS.AHL_STATUS_ORDER_RULES_PKG dependencies on AHL_STATUS_ORDER_RULES_PKG

Line 1: package body AHL_STATUS_ORDER_RULES_PKG as

1: package body AHL_STATUS_ORDER_RULES_PKG as
2: /* $Header: AHLLSTSB.pls 115.1 2002/12/04 01:31:42 ssurapan noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_STATUS_ORDER_RULE_ID in NUMBER,

Line 142: AHL_STATUS_ORDER_RULES_PKG.INSERT_ROW (

138: end if ;
139:
140: l_obj_verno := 1;
141:
142: AHL_STATUS_ORDER_RULES_PKG.INSERT_ROW (
143: X_ROWID => l_row_id ,
144: X_STATUS_ORDER_RULE_ID => l_sts_id,
145: X_OBJECT_VERSION_NUMBER => l_obj_verno,
146: X_SYSTEM_STATUS_TYPE => X_SYSTEM_STATUS_TYPE,

Line 162: AHL_STATUS_ORDER_RULES_PKG.UPDATE_ROW(

158: open c_obj_verno;
159: fetch c_obj_verno into l_obj_verno;
160: close c_obj_verno;
161:
162: AHL_STATUS_ORDER_RULES_PKG.UPDATE_ROW(
163: X_STATUS_ORDER_RULE_ID => X_STATUS_ORDER_RULE_ID,
164: X_OBJECT_VERSION_NUMBER => l_obj_verno + 1,
165: X_SYSTEM_STATUS_TYPE => X_SYSTEM_STATUS_TYPE,
166: X_CURRENT_STATUS_CODE => X_CURRENT_STATUS_CODE,

Line 176: end AHL_STATUS_ORDER_RULES_PKG;

172: end if;
173:
174: END LOAD_ROW ;
175:
176: end AHL_STATUS_ORDER_RULES_PKG;