APPS.AMS_ITEM_OWNERS_PKG dependencies on FND_API

Line 43: px_OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN

39: CLOSE C2;
40: END IF;
41:
42: IF (px_OBJECT_VERSION_NUMBER IS NULL OR
43: px_OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN
44: px_OBJECT_VERSION_NUMBER := 1;
45: END IF;
46:
47: INSERT INTO AMS_ITEM_ATTRIBUTES(

Line 65: decode( px_ITEM_OWNER_ID, FND_API.G_MISS_NUM, NULL, px_ITEM_OWNER_ID),

61: created_by,
62: last_update_login,
63: custom_setup_id
64: ) VALUES (
65: decode( px_ITEM_OWNER_ID, FND_API.G_MISS_NUM, NULL, px_ITEM_OWNER_ID),
66: decode( px_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, px_OBJECT_VERSION_NUMBER),
67: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
68: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
69: decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, NULL, p_ITEM_NUMBER),

Line 66: decode( px_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, px_OBJECT_VERSION_NUMBER),

62: last_update_login,
63: custom_setup_id
64: ) VALUES (
65: decode( px_ITEM_OWNER_ID, FND_API.G_MISS_NUM, NULL, px_ITEM_OWNER_ID),
66: decode( px_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, px_OBJECT_VERSION_NUMBER),
67: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
68: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
69: decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, NULL, p_ITEM_NUMBER),
70: decode( p_OWNER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_ID),

Line 67: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),

63: custom_setup_id
64: ) VALUES (
65: decode( px_ITEM_OWNER_ID, FND_API.G_MISS_NUM, NULL, px_ITEM_OWNER_ID),
66: decode( px_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, px_OBJECT_VERSION_NUMBER),
67: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
68: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
69: decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, NULL, p_ITEM_NUMBER),
70: decode( p_OWNER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_ID),
71: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),

Line 68: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),

64: ) VALUES (
65: decode( px_ITEM_OWNER_ID, FND_API.G_MISS_NUM, NULL, px_ITEM_OWNER_ID),
66: decode( px_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, px_OBJECT_VERSION_NUMBER),
67: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
68: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
69: decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, NULL, p_ITEM_NUMBER),
70: decode( p_OWNER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_ID),
71: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
72: decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, p_EFFECTIVE_DATE),

Line 69: decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, NULL, p_ITEM_NUMBER),

65: decode( px_ITEM_OWNER_ID, FND_API.G_MISS_NUM, NULL, px_ITEM_OWNER_ID),
66: decode( px_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, px_OBJECT_VERSION_NUMBER),
67: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
68: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
69: decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, NULL, p_ITEM_NUMBER),
70: decode( p_OWNER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_ID),
71: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
72: decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, p_EFFECTIVE_DATE),
73: p_IS_MASTER_ITEM,

Line 70: decode( p_OWNER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_ID),

66: decode( px_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, px_OBJECT_VERSION_NUMBER),
67: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
68: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
69: decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, NULL, p_ITEM_NUMBER),
70: decode( p_OWNER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_ID),
71: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
72: decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, p_EFFECTIVE_DATE),
73: p_IS_MASTER_ITEM,
74: p_ITEM_SETUP_TYPE,

Line 71: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),

67: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
68: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
69: decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, NULL, p_ITEM_NUMBER),
70: decode( p_OWNER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_ID),
71: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
72: decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, p_EFFECTIVE_DATE),
73: p_IS_MASTER_ITEM,
74: p_ITEM_SETUP_TYPE,
75: SYSDATE,

Line 72: decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, p_EFFECTIVE_DATE),

68: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
69: decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, NULL, p_ITEM_NUMBER),
70: decode( p_OWNER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_ID),
71: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
72: decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, p_EFFECTIVE_DATE),
73: p_IS_MASTER_ITEM,
74: p_ITEM_SETUP_TYPE,
75: SYSDATE,
76: FND_GLOBAL.user_id,

Line 80: decode(p_custom_setup_id,FND_API.G_MISS_NUM,1200,NULL,1200,p_custom_setup_id));

76: FND_GLOBAL.user_id,
77: SYSDATE,
78: FND_GLOBAL.user_id,
79: FND_GLOBAL.conc_login_id,
80: decode(p_custom_setup_id,FND_API.G_MISS_NUM,1200,NULL,1200,p_custom_setup_id));
81: OPEN C;
82: FETCH C INTO x_rowid;
83: If (C%NOTFOUND) then
84: CLOSE C;

Line 105: ITEM_OWNER_ID = decode( p_ITEM_OWNER_ID, FND_API.G_MISS_NUM, ITEM_OWNER_ID, p_ITEM_OWNER_ID),

101: IS
102: BEGIN
103: Update AMS_ITEM_ATTRIBUTES
104: SET
105: ITEM_OWNER_ID = decode( p_ITEM_OWNER_ID, FND_API.G_MISS_NUM, ITEM_OWNER_ID, p_ITEM_OWNER_ID),
106: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
107: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
108: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
109: ITEM_NUMBER = decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, ITEM_NUMBER, p_ITEM_NUMBER),

Line 106: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),

102: BEGIN
103: Update AMS_ITEM_ATTRIBUTES
104: SET
105: ITEM_OWNER_ID = decode( p_ITEM_OWNER_ID, FND_API.G_MISS_NUM, ITEM_OWNER_ID, p_ITEM_OWNER_ID),
106: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
107: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
108: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
109: ITEM_NUMBER = decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, ITEM_NUMBER, p_ITEM_NUMBER),
110: OWNER_ID = decode( p_OWNER_ID, FND_API.G_MISS_NUM, OWNER_ID, p_OWNER_ID),

Line 107: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),

103: Update AMS_ITEM_ATTRIBUTES
104: SET
105: ITEM_OWNER_ID = decode( p_ITEM_OWNER_ID, FND_API.G_MISS_NUM, ITEM_OWNER_ID, p_ITEM_OWNER_ID),
106: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
107: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
108: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
109: ITEM_NUMBER = decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, ITEM_NUMBER, p_ITEM_NUMBER),
110: OWNER_ID = decode( p_OWNER_ID, FND_API.G_MISS_NUM, OWNER_ID, p_OWNER_ID),
111: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),

Line 108: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),

104: SET
105: ITEM_OWNER_ID = decode( p_ITEM_OWNER_ID, FND_API.G_MISS_NUM, ITEM_OWNER_ID, p_ITEM_OWNER_ID),
106: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
107: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
108: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
109: ITEM_NUMBER = decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, ITEM_NUMBER, p_ITEM_NUMBER),
110: OWNER_ID = decode( p_OWNER_ID, FND_API.G_MISS_NUM, OWNER_ID, p_OWNER_ID),
111: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
112: EFFECTIVE_DATE = decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, EFFECTIVE_DATE, p_EFFECTIVE_DATE),

Line 109: ITEM_NUMBER = decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, ITEM_NUMBER, p_ITEM_NUMBER),

105: ITEM_OWNER_ID = decode( p_ITEM_OWNER_ID, FND_API.G_MISS_NUM, ITEM_OWNER_ID, p_ITEM_OWNER_ID),
106: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
107: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
108: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
109: ITEM_NUMBER = decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, ITEM_NUMBER, p_ITEM_NUMBER),
110: OWNER_ID = decode( p_OWNER_ID, FND_API.G_MISS_NUM, OWNER_ID, p_OWNER_ID),
111: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
112: EFFECTIVE_DATE = decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, EFFECTIVE_DATE, p_EFFECTIVE_DATE),
113: IS_MASTER_ITEM = p_IS_MASTER_ITEM,

Line 110: OWNER_ID = decode( p_OWNER_ID, FND_API.G_MISS_NUM, OWNER_ID, p_OWNER_ID),

106: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
107: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
108: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
109: ITEM_NUMBER = decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, ITEM_NUMBER, p_ITEM_NUMBER),
110: OWNER_ID = decode( p_OWNER_ID, FND_API.G_MISS_NUM, OWNER_ID, p_OWNER_ID),
111: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
112: EFFECTIVE_DATE = decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, EFFECTIVE_DATE, p_EFFECTIVE_DATE),
113: IS_MASTER_ITEM = p_IS_MASTER_ITEM,
114: ITEM_SETUP_TYPE = p_ITEM_SETUP_TYPE,

Line 111: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),

107: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
108: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
109: ITEM_NUMBER = decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, ITEM_NUMBER, p_ITEM_NUMBER),
110: OWNER_ID = decode( p_OWNER_ID, FND_API.G_MISS_NUM, OWNER_ID, p_OWNER_ID),
111: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
112: EFFECTIVE_DATE = decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, EFFECTIVE_DATE, p_EFFECTIVE_DATE),
113: IS_MASTER_ITEM = p_IS_MASTER_ITEM,
114: ITEM_SETUP_TYPE = p_ITEM_SETUP_TYPE,
115: last_update_date = SYSDATE,

Line 112: EFFECTIVE_DATE = decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, EFFECTIVE_DATE, p_EFFECTIVE_DATE),

108: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
109: ITEM_NUMBER = decode( p_ITEM_NUMBER, FND_API.G_MISS_CHAR, ITEM_NUMBER, p_ITEM_NUMBER),
110: OWNER_ID = decode( p_OWNER_ID, FND_API.G_MISS_NUM, OWNER_ID, p_OWNER_ID),
111: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
112: EFFECTIVE_DATE = decode( p_EFFECTIVE_DATE, FND_API.G_MISS_DATE, EFFECTIVE_DATE, p_EFFECTIVE_DATE),
113: IS_MASTER_ITEM = p_IS_MASTER_ITEM,
114: ITEM_SETUP_TYPE = p_ITEM_SETUP_TYPE,
115: last_update_date = SYSDATE,
116: last_updated_by = FND_GLOBAL.user_id,