DBA Data[Home] [Help]

APPS.WSH_FLEX_UPGR_COGS dependencies on WF_ENGINE

Line 96: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');

92: DBMS_OUTPUT.ENABLE(1000000);
93: PRINTLN('Calling OE_INVENTORY_INTERFACE.BUILD');
94: END IF;
95: IF (FUNCMODE = 'RUN') THEN
96: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');
97: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
98: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
99: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');

Line 97: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');

93: PRINTLN('Calling OE_INVENTORY_INTERFACE.BUILD');
94: END IF;
95: IF (FUNCMODE = 'RUN') THEN
96: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');
97: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
98: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
99: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');

Line 98: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');

94: END IF;
95: IF (FUNCMODE = 'RUN') THEN
96: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');
97: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
98: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
99: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');

Line 99: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

95: IF (FUNCMODE = 'RUN') THEN
96: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');
97: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
98: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
99: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');
103: L_ORDER_CATEGORY:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');

Line 100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');

96: L_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_DETAIL_ID');
97: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
98: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
99: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');
103: L_ORDER_CATEGORY:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
104: L_ORDER_TYPE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

Line 101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');

97: L_ORDER_LINE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_ID');
98: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
99: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');
103: L_ORDER_CATEGORY:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
104: L_ORDER_TYPE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
105: L_OPTION_FLAG:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');

Line 102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');

98: L_PICK_LINE_DETAIL_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'PICKING_LINE_DETAIL_ID');
99: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');
103: L_ORDER_CATEGORY:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
104: L_ORDER_TYPE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
105: L_OPTION_FLAG:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
106: L_FLEX_NUM:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');

Line 103: L_ORDER_CATEGORY:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');

99: L_ORGANIZATION_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');
103: L_ORDER_CATEGORY:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
104: L_ORDER_TYPE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
105: L_OPTION_FLAG:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
106: L_FLEX_NUM:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
107:

Line 104: L_ORDER_TYPE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

100: L_COMMITMENT_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');
103: L_ORDER_CATEGORY:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
104: L_ORDER_TYPE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
105: L_OPTION_FLAG:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
106: L_FLEX_NUM:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
107:
108: IF (DEBUG_COGS) THEN

Line 105: L_OPTION_FLAG:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');

101: L_CUSTOMER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');
103: L_ORDER_CATEGORY:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
104: L_ORDER_TYPE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
105: L_OPTION_FLAG:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
106: L_FLEX_NUM:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
107:
108: IF (DEBUG_COGS) THEN
109: PRINTLN('Input Paramerers : ');

Line 106: L_FLEX_NUM:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');

102: L_HEADER_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_LINE_HEADER_ID');
103: L_ORDER_CATEGORY:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
104: L_ORDER_TYPE_ID:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
105: L_OPTION_FLAG:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
106: L_FLEX_NUM:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
107:
108: IF (DEBUG_COGS) THEN
109: PRINTLN('Input Paramerers : ');
110: PRINTLN('Line detail id :'||to_char(l_line_detail_id));

Line 144: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',L_FB_ERROR_MSG);

140: result := 'COMPLETE:FAILURE';
141: END IF;
142:
143: IF L_FB_ERROR_MSG IS NOT NULL THEN
144: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',L_FB_ERROR_MSG);
145: PRINTLN ('Error : L_FB_ERROR_MSG = '||L_FB_ERROR_MSG);
146: END IF;
147:
148: FND_FLEX_WORKFLOW.LOAD_CONCATENATED_SEGMENTS(itemtype,

Line 154: result := wf_engine.eng_completed;

150: l_fb_flex_segs);
151: RETURN;
152:
153: ELSIF (funcmode = 'CANCEL') THEN
154: result := wf_engine.eng_completed;
155: RETURN;
156: ELSE
157: result := '';
158: RETURN;