DBA Data[Home] [Help]

APPS.WF_ITEM_IMPORT dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 37: delete from wf_item_attribute_values

33: where Item_type = X_Item_type
34: and Item_key = X_Item_key;
35:
36: -- wf_item_attributes
37: delete from wf_item_attribute_values
38: where Item_type = X_Item_type
39: and Item_key = X_Item_key;
40:
41: -- wf_items

Line 74: -- repopulates WF_ITEM_ATTRIBUTE_VALUES

70: X_BEGIN_DATE, X_END_DATE, X_USER_KEY, X_HA_MIGRATION_FLAG
71: from dual;
72: end;
73:
74: -- repopulates WF_ITEM_ATTRIBUTE_VALUES
75: procedure import_item_attr_row(
76: X_ITEM_TYPE VARCHAR2,
77: X_ITEM_KEY VARCHAR2,
78: X_NAME VARCHAR2,

Line 85: insert into WF_ITEM_ATTRIBUTE_VALUES

81: X_DATE_VALUE DATE,
82: X_EVENT_VALUE WF_EVENT_T) is
83:
84: begin
85: insert into WF_ITEM_ATTRIBUTE_VALUES
86: (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE,
87: EVENT_VALUE)
88: select X_ITEM_TYPE, X_ITEM_KEY, X_NAME, X_TEXT_VALUE, X_NUMBER_VALUE,
89: X_DATE_VALUE, X_EVENT_VALUE

Line 106: insert into WF_ITEM_ATTRIBUTE_VALUES

102:
103: is
104:
105: begin
106: insert into WF_ITEM_ATTRIBUTE_VALUES
107: (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE)
108: select X_ITEM_TYPE, X_ITEM_KEY, X_NAME, X_TEXT_VALUE, X_NUMBER_VALUE,
109: X_DATE_VALUE
110: from dual;