eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_SYNC_ITEM_PKG dependencies on DUAL

Line 68: -- The output parameters individually carry the category name and category set name

64: -- Purpose
65: -- This procedure takes an input of concatenated string of category name and
66: -- category set name delimited by '|'.
67: -- The input would be of the form 'CATNAME=xxxxxx|CATSETNAME=xxxxxxxxx'
68: -- The output parameters individually carry the category name and category set name
69: -- This procedure is called from the inbound XGM
70: -- Arguments
71: --
72: -- Notes

Line 115: FROM dual;

111:
112:
113: SELECT SUBSTR(p_concatgset, INSTR(p_concatgset,'=', 1, 1)+1,INSTR(p_concatgset,'|',1,1)-INSTR(p_concatgset,'=',1,1)-1)
114: INTO x_catgry
115: FROM dual;
116:
117: -- Category Name
118: IF (l_Debug_Level <= 1) THEN
119: cln_debug_pub.Add('Category Name - '||x_catgry,1);

Line 129: FROM dual;

125: END IF;
126:
127: SELECT SUBSTR(p_concatgset, INSTR(p_concatgset,'=', 1, 2)+1)
128: INTO x_catsetname
129: FROM dual;
130:
131:
132: -- Category Set Name
133: IF (l_Debug_Level <= 1) THEN

Line 216: SELECT cln_generic_s.nextval INTO x_set_process_id FROM dual;

212:
213: -- get a unique key for set process id based on which the concurrent program will
214: -- select the rows from the interface table and import them
215: -- If the inventory folks come up with sequence..we haveto replace this
216: SELECT cln_generic_s.nextval INTO x_set_process_id FROM dual;
217:
218: -- get a unique value for the group id used in the costing interface tables.
219: SELECT cst_lists_s.nextval INTO x_cost_group_id FROM dual;
220:

Line 219: SELECT cst_lists_s.nextval INTO x_cost_group_id FROM dual;

215: -- If the inventory folks come up with sequence..we haveto replace this
216: SELECT cln_generic_s.nextval INTO x_set_process_id FROM dual;
217:
218: -- get a unique value for the group id used in the costing interface tables.
219: SELECT cst_lists_s.nextval INTO x_cost_group_id FROM dual;
220:
221:
222: IF (l_Debug_Level <= 1) THEN
223: cln_debug_pub.Add('------------ PARAMETERS OBTAINED ----------', 1);

Line 299: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

295: RAISE FND_API.G_EXC_ERROR;
296: END;
297:
298: -- get a unique key for raising update collaboration event.
299: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
300:
301: l_cln_ch_parameters := wf_parameter_list_t();
302: /* Bug: 3479100
303: Desc : Document Number shuld be trading partner number.Running sequence Number

Line 307: SELECT CLN_SYNCITEM_S.nextval into l_syncitem_seq from dual;

303: Desc : Document Number shuld be trading partner number.Running sequence Number
304:
305: l_document_number := l_supplier_name||':'||l_buyer_organization||':'||to_char(sysdate,'YYYYMMDDHH:MM:SS');
306: */
307: SELECT CLN_SYNCITEM_S.nextval into l_syncitem_seq from dual;
308: l_document_number := to_char(p_sender_header_id) || '.' || to_char(l_syncitem_seq);
309:
310: IF (l_Debug_Level <= 1) THEN
311: cln_debug_pub.Add('Document Number : '||l_document_number, 1);

Line 426: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

422: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DETAILS');
423: x_msg_data := FND_MESSAGE.GET;
424:
425: -- get a unique key for raising add collaboration event.
426: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
427:
428: IF (l_Debug_Level <= 1) THEN
429: cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------',1);
430: cln_debug_pub.Add('Sync Indicator ---- '||p_sync_indicator,1);

Line 774: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

770:
771: ROLLBACK TO CHECK_COLLABORATION_PUB;
772:
773: -- get a unique key for raising update collaboration event.
774: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
775:
776: IF (l_Debug_Level <= 1) THEN
777: cln_debug_pub.Add('--------ERROR status -------------',1);
778: END IF;

Line 947: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

943:
944: IF (l_sender_header_id IS NOT NULL) THEN
945:
946: -- generate an event key which is also passed as xmlg document id.
947: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
948: IF (l_Debug_Level <= 1) THEN
949: cln_debug_pub.Add('XMLG Document ID set as : '||l_event_key, 1);
950: END IF;
951:

Line 1238: FROM DUAL

1234: -- check for failed rows..
1235: BEGIN
1236: SELECT 'x'
1237: INTO l_count_failed_rows
1238: FROM DUAL
1239: WHERE EXISTS (
1240: /*SELECT 'x'
1241: FROM MTL_INTERFACE_ERRORS
1242: WHERE REQUEST_ID = l_request_id

Line 1295: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

1291: END IF;
1292:
1293:
1294: -- generate an event key which is also passed as event key for update collaboration .
1295: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
1296:
1297: IF (l_Debug_Level <= 1) THEN
1298: cln_debug_pub.Add('Message for update collaboration = '||l_update_coll_msg, 1);
1299: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);

Line 1372: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

1368: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
1369: END IF;
1370:
1371: -- generate an event key which is also passed as event key for add collaboration event.
1372: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
1373:
1374:
1375: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
1376: IF (l_Debug_Level <= 1) THEN

Line 1627: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

1623: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1624: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1625:
1626: -- generate an event key which is also passed as event key for update collaboration .
1627: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
1628:
1629: IF (l_Debug_Level <= 1) THEN
1630: cln_debug_pub.Add('Message for update collaboration = '||l_msg_data, 1);
1631: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);

Line 2099: FROM dual

2095:
2096: -- check for failed rows..
2097: SELECT COUNT(*)
2098: INTO l_count_failed_rows
2099: FROM dual
2100: WHERE exists
2101: ( SELECT 'x'
2102: FROM cst_item_cst_dtls_interface cicdi
2103: WHERE error_flag = 'E'

Line 2130: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

2126: END IF;
2127: END IF;
2128:
2129: -- generate an event key which is also passed as event key for update collaboration .
2130: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2131:
2132: IF (l_Debug_Level <= 1) THEN
2133: cln_debug_pub.Add('Message for update collaboration = '||l_update_coll_msg, 1);
2134: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);

Line 2226: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

2222: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
2223: END IF;
2224:
2225: -- generate an event key which is also passed as event key for add collaboration event.
2226: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2227:
2228:
2229: WF_EVENT.AddParameterToList('REFERENCE_ID1','ERROR',l_cln_ch_parameters);
2230: WF_EVENT.AddParameterToList('REFERENCE_ID2','Org ID : '||l_master_organization_id,l_cln_ch_parameters);

Line 2283: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

2279:
2280:
2281: IF (l_mfg_details = '99') THEN
2282: -- generate an event key which is also passed as event key for update collaboration .
2283: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2284:
2285: IF (l_Debug_Level <= 1) THEN
2286: cln_debug_pub.Add('Message for update collaboration = '||l_return_desc_tp, 1);
2287: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);

Line 2554: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

2550: l_return_status_tp := '99';
2551: l_return_desc_tp := l_update_coll_msg;
2552:
2553: -- generate an event key which is also passed as event key for update collaboration .
2554: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2555:
2556: IF (l_Debug_Level <= 1) THEN
2557: cln_debug_pub.Add('Message for update collaboration = '||l_update_coll_msg, 1);
2558: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);

Line 2749: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

2745: l_update_coll_msg := FND_MESSAGE.GET;
2746:
2747:
2748: -- generate an event key which is also passed as event key for update collaboration .
2749: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2750:
2751: IF (l_Debug_Level <= 1) THEN
2752: cln_debug_pub.Add('Message for update collaboration = '||l_update_coll_msg, 1);
2753: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);

Line 2846: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

2842: ROLLBACK TO CHECK_ITEM_DELETION_PUB;
2843:
2844:
2845: -- get a unique key for raising add collaboration event.
2846: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
2847:
2848: IF (l_Debug_Level <= 1) THEN
2849: cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------',1);
2850: cln_debug_pub.Add('Supplier name ---- '||p_supplier_name,1);