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.BOM_BOMRBOMC_XMLP_PKG dependencies on DBMS_SQL

Line 88: CURSOR_NAME := DBMS_SQL.OPEN_CURSOR;

84: ORDER BY fifst.id_flex_num;
85:
86: BEGIN
87:
88: CURSOR_NAME := DBMS_SQL.OPEN_CURSOR;
89: OPEN C1('MSTK', 'SYSTEM_ITEMS');
90: FETCH C1 INTO l_idFlexNuM;
91: CLOSE C1;
92:

Line 393: DBMS_SQL.PARSE(CURSOR_NAME

389: /*
390: EXECUTE IMMEDIATE
391: L_STR; */
392:
393: DBMS_SQL.PARSE(CURSOR_NAME
394: ,L_STR
395: ,1);
396:
397: FOR i IN 1..l_NumOf_Bind_Vars_Assy LOOP

Line 399: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).varchar2_value);

395: ,1);
396:
397: FOR i IN 1..l_NumOf_Bind_Vars_Assy LOOP
398: IF (l_bind_variables_tab_assy(i).data_type='VARCHAR2') THEN
399: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).varchar2_value);
400: ELSIF (l_bind_variables_tab_assy(i).data_type='NUMBER') THEN
401: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).canonical_value);
402: ELSIF (l_bind_variables_tab_assy(i).data_type='DATE') THEN
403: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).date_value);

Line 401: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).canonical_value);

397: FOR i IN 1..l_NumOf_Bind_Vars_Assy LOOP
398: IF (l_bind_variables_tab_assy(i).data_type='VARCHAR2') THEN
399: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).varchar2_value);
400: ELSIF (l_bind_variables_tab_assy(i).data_type='NUMBER') THEN
401: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).canonical_value);
402: ELSIF (l_bind_variables_tab_assy(i).data_type='DATE') THEN
403: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).date_value);
404: END IF;
405: END LOOP ;

Line 403: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).date_value);

399: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).varchar2_value);
400: ELSIF (l_bind_variables_tab_assy(i).data_type='NUMBER') THEN
401: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).canonical_value);
402: ELSIF (l_bind_variables_tab_assy(i).data_type='DATE') THEN
403: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_assy(i).name,l_bind_variables_tab_assy(i).date_value);
404: END IF;
405: END LOOP ;
406:
407: FOR i IN 1..l_NumOf_Bind_Vars_Cat LOOP

Line 409: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).varchar2_value);

405: END LOOP ;
406:
407: FOR i IN 1..l_NumOf_Bind_Vars_Cat LOOP
408: IF (l_bind_variables_tab_cat(i).data_type='VARCHAR2') THEN
409: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).varchar2_value);
410: ELSIF (l_bind_variables_tab_cat(i).data_type='NUMBER') THEN
411: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).canonical_value);
412: ELSIF (l_bind_variables_tab_cat(i).data_type='DATE') THEN
413: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).date_value);

Line 411: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).canonical_value);

407: FOR i IN 1..l_NumOf_Bind_Vars_Cat LOOP
408: IF (l_bind_variables_tab_cat(i).data_type='VARCHAR2') THEN
409: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).varchar2_value);
410: ELSIF (l_bind_variables_tab_cat(i).data_type='NUMBER') THEN
411: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).canonical_value);
412: ELSIF (l_bind_variables_tab_cat(i).data_type='DATE') THEN
413: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).date_value);
414: END IF;
415: END LOOP ;

Line 413: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).date_value);

409: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).varchar2_value);
410: ELSIF (l_bind_variables_tab_cat(i).data_type='NUMBER') THEN
411: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).canonical_value);
412: ELSIF (l_bind_variables_tab_cat(i).data_type='DATE') THEN
413: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).date_value);
414: END IF;
415: END LOOP ;
416:
417: ROWS_PROCESSED := DBMS_SQL.EXECUTE(CURSOR_NAME);

Line 417: ROWS_PROCESSED := DBMS_SQL.EXECUTE(CURSOR_NAME);

413: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_bind_variables_tab_cat(i).name,l_bind_variables_tab_cat(i).date_value);
414: END IF;
415: END LOOP ;
416:
417: ROWS_PROCESSED := DBMS_SQL.EXECUTE(CURSOR_NAME);
418: DBMS_SQL.CLOSE_CURSOR(CURSOR_NAME);
419:
420:
421:

Line 418: DBMS_SQL.CLOSE_CURSOR(CURSOR_NAME);

414: END IF;
415: END LOOP ;
416:
417: ROWS_PROCESSED := DBMS_SQL.EXECUTE(CURSOR_NAME);
418: DBMS_SQL.CLOSE_CURSOR(CURSOR_NAME);
419:
420:
421:
422: TABLE_NAME := 'CALL EXPLODER';