APPS.BOM_BOMRBOMS_XMLP_PKG dependencies on DBMS_SQL

Line 338: CURSOR_NAME := DBMS_SQL.OPEN_CURSOR;

334: END IF;
335: END IF;
336:
337: TABLE_NAME := 'bom_lists';
338: CURSOR_NAME := DBMS_SQL.OPEN_CURSOR;
339: /***** Commented out to fix bug #6769853 ********
340: P_ASS_BETWEEN := BOMRBOMS_NEW.P_ASS_BETWEEN;
341: P_CAT_BETWEEN := BOMRBOMS_NEW.P_CAT_BETWEEN;
342: ***** Commented out to fix bug #6769853 ********/

Line 455: DBMS_SQL.PARSE(CURSOR_NAME

451: (' || ':b_P_BOM_OR_ENG' || ' = ''ENG'')
452: )';
453:
454:
455: DBMS_SQL.PARSE(CURSOR_NAME
456: ,L_STR
457: ,1);
458: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
459: ,':b_l_seq_id'

Line 458: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

454:
455: DBMS_SQL.PARSE(CURSOR_NAME
456: ,L_STR
457: ,1);
458: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
459: ,':b_l_seq_id'
460: ,L_SEQ_ID);
461: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
462: ,':b_P_ALT_OPTION_TYPE'

Line 461: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

457: ,1);
458: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
459: ,':b_l_seq_id'
460: ,L_SEQ_ID);
461: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
462: ,':b_P_ALT_OPTION_TYPE'
463: ,P_ALT_OPTION_TYPE);
464: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
465: ,':b_P_ALTERNATE_DESG'

Line 464: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

460: ,L_SEQ_ID);
461: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
462: ,':b_P_ALT_OPTION_TYPE'
463: ,P_ALT_OPTION_TYPE);
464: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
465: ,':b_P_ALTERNATE_DESG'
466: ,P_ALTERNATE_DESG);
467: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
468: ,':b_P_BOM_OR_ENG'

Line 467: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

463: ,P_ALT_OPTION_TYPE);
464: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
465: ,':b_P_ALTERNATE_DESG'
466: ,P_ALTERNATE_DESG);
467: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
468: ,':b_P_BOM_OR_ENG'
469: ,P_BOM_OR_ENG);
470: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
471: ,':b_P_ORGANIZATION_ID'

Line 470: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

466: ,P_ALTERNATE_DESG);
467: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
468: ,':b_P_BOM_OR_ENG'
469: ,P_BOM_OR_ENG);
470: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
471: ,':b_P_ORGANIZATION_ID'
472: ,LP_ORGANIZATION_ID);
473: IF (FLAG = TRUE) THEN
474: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

Line 474: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

470: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
471: ,':b_P_ORGANIZATION_ID'
472: ,LP_ORGANIZATION_ID);
473: IF (FLAG = TRUE) THEN
474: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
475: ,':b_P_ITEM_ID'
476: ,P_ITEM_ID);
477: ELSIF (FLAG = FALSE) THEN
478: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

Line 478: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

474: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
475: ,':b_P_ITEM_ID'
476: ,P_ITEM_ID);
477: ELSIF (FLAG = FALSE) THEN
478: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
479: ,':b_P_CATEGORY_SET_ID'
480: ,P_CATEGORY_SET_ID);
481: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
482: ,':b_P_CATEGORY_STRUCTURE_ID'

Line 481: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME

477: ELSIF (FLAG = FALSE) THEN
478: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
479: ,':b_P_CATEGORY_SET_ID'
480: ,P_CATEGORY_SET_ID);
481: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME
482: ,':b_P_CATEGORY_STRUCTURE_ID'
483: ,P_CATEGORY_STRUCTURE_ID);
484:
485: /* Added for bug 9364923 */

Line 488: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).varchar2_value);

484:
485: /* Added for bug 9364923 */
486: FOR i IN 1..x_numof_binds LOOP
487: IF (l_binds(i).data_type='VARCHAR2') THEN
488: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).varchar2_value);
489: ELSIF (l_binds(i).data_type='NUMBER') THEN
490: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).canonical_value);
491: ELSIF (l_binds(i).data_type='DATE') THEN
492: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).date_value);

Line 490: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).canonical_value);

486: FOR i IN 1..x_numof_binds LOOP
487: IF (l_binds(i).data_type='VARCHAR2') THEN
488: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).varchar2_value);
489: ELSIF (l_binds(i).data_type='NUMBER') THEN
490: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).canonical_value);
491: ELSIF (l_binds(i).data_type='DATE') THEN
492: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).date_value);
493: END IF;
494: END LOOP ;

Line 492: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).date_value);

488: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).varchar2_value);
489: ELSIF (l_binds(i).data_type='NUMBER') THEN
490: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).canonical_value);
491: ELSIF (l_binds(i).data_type='DATE') THEN
492: DBMS_SQL.BIND_VARIABLE(CURSOR_NAME,l_binds(i).name,l_binds(i).date_value);
493: END IF;
494: END LOOP ;
495: /* End of changes for bug 9324623 */
496: END IF;

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

494: END LOOP ;
495: /* End of changes for bug 9324623 */
496: END IF;
497:
498: ROWS_PROCESSED := DBMS_SQL.EXECUTE(CURSOR_NAME);
499: DBMS_SQL.CLOSE_CURSOR(CURSOR_NAME);
500: TABLE_NAME := 'exploder';
501:
502: IF LP_REVISION_DATE IS NULL THEN

Line 499: DBMS_SQL.CLOSE_CURSOR(CURSOR_NAME);

495: /* End of changes for bug 9324623 */
496: END IF;
497:
498: ROWS_PROCESSED := DBMS_SQL.EXECUTE(CURSOR_NAME);
499: DBMS_SQL.CLOSE_CURSOR(CURSOR_NAME);
500: TABLE_NAME := 'exploder';
501:
502: IF LP_REVISION_DATE IS NULL THEN
503: LP_REVISION_DATE := TO_CHAR(SYSDATE