APPS.BOM_BOMRASSY_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

                                   MODE="SELECT" DISPLAY="ALL" TABLEALIAS="item1"')*/NULL;

Line: 37

        SELECT
          BOM_LISTS_S.NEXTVAL
        INTO P_SEQUENCE_ID
        FROM
          DUAL;

Line: 42

        FOR C1 IN (SELECT
                     ORGANIZATION_ID
                   FROM
                     MTL_PARAMETERS MP
                   WHERE MASTER_ORGANIZATION_ID = (
                     SELECT
                       MASTER_ORGANIZATION_ID
                     FROM
                       MTL_PARAMETERS
                     WHERE ORGANIZATION_ID = P_ORG_ID )
                     AND MP.ORGANIZATION_ID IN (
                     SELECT
                       ORGANIZATION_ID
                     FROM
                       ORG_ACCESS_VIEW
                     WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')
                       AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP
          N := N + 1;

Line: 60

          INSERT INTO BOM_LISTS
            (ORGANIZATION_ID
            ,SEQUENCE_ID
            ,ALTERNATE_DESIGNATOR)
          VALUES   (C1.ORGANIZATION_ID
            ,P_SEQUENCE_ID
            ,C1.ORGANIZATION_ID);

Line: 74

          SELECT
            BOM_LISTS_S.NEXTVAL
          INTO P_SEQUENCE_ID
          FROM
            DUAL;

Line: 80

            INSERT INTO BOM_LISTS
              (ORGANIZATION_ID
              ,SEQUENCE_ID
              ,ALTERNATE_DESIGNATOR)
            VALUES   (T_ORG_CODE_LIST(I)
              ,P_SEQUENCE_ID
              ,T_ORG_CODE_LIST(I));

Line: 89

          SELECT
            BOM_LISTS_S.NEXTVAL
          INTO P_SEQUENCE_ID
          FROM
            DUAL;

Line: 94

          INSERT INTO BOM_LISTS
            (ORGANIZATION_ID
            ,SEQUENCE_ID)
          VALUES   (P_ORG_ID
            ,P_SEQUENCE_ID);

Line: 101

        SELECT
          BOM_LISTS_S.NEXTVAL
        INTO P_SEQUENCE_ID
        FROM
          DUAL;

Line: 106

        INSERT INTO BOM_LISTS
          (ORGANIZATION_ID
          ,SEQUENCE_ID)
        VALUES   (P_ORG_ID
          ,P_SEQUENCE_ID);

Line: 129

    DELETE FROM BOM_LISTS
     WHERE SEQUENCE_ID = P_SEQUENCE_ID;

Line: 142

      SELECT
        ORGANIZATION_CODE
      INTO COMMON_ORG
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = COMMON_ORGANIZATION_ID;

Line: 155

    SELECT
      ORGANIZATION_CODE
    INTO ORG_CODE
    FROM
      ORG_ORGANIZATION_DEFINITIONS ORG
    WHERE ORG.ORGANIZATION_ID = ORG_ID;