APPS.INV_INVKBCPR_XMLP_PKG SQL Statements

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

Line: 29

                   ,'Failed in before report trigger, item select. ')*/NULL;

Line: 37

                   ,'Failed in before report trigger, locator select. ')*/NULL;

Line: 45

                   ,'Failed in before report trigger, source locator select. ')*/NULL;

Line: 120

        P_CALL_WHERE := P_CALL_WHERE || ' AND (MKC.KANBAN_CARD_ID IN ( SELECT MKBNT.KANBAN_CARD_ID FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT
                                    WHERE MKBNT.REPORT_ID = ' || TO_CHAR(P_REPORT_ID) || ')
                                  OR MKC.KANBAN_CARD_ID IN ( SELECT MKC.KANBAN_CARD_ID FROM MTL_KANBAN_CARDS MKC WHERE
                                    MKC.PULL_SEQUENCE_ID IN ( SELECT MKBNT.PULL_SEQUENCE_ID
                                         FROM MTL_KANBAN_CARD_PRINT_TEMP MKBNT
                                        WHERE MKBNT.REPORT_ID = ' || TO_CHAR(P_REPORT_ID) || ')))';

Line: 154

        DELETE FROM MTL_KANBAN_CARD_PRINT_TEMP
         WHERE REPORT_ID = P_REPORT_ID;

Line: 213

         SELECT mtl_kanban_card_print_temp_s.NEXTVAL
           INTO v_report_id
           FROM DUAL;

Line: 218

      INSERT INTO mtl_kanban_card_print_temp
                  (report_id, kanban_card_id
                  )
          select v_report_id,kanban_card_id from MTL_KANBAN_CARDS_V
                  where pull_sequence_id=pull_sequence_id;

Line: 234

      SELECT REGEXP_SUBSTR (p_mul_kbn_card_ids, '[^,]+', 1, i)
        INTO l_value
        FROM DUAL;

Line: 239

         SELECT mtl_kanban_card_print_temp_s.NEXTVAL
           INTO v_report_id
           FROM DUAL;

Line: 244

      INSERT INTO mtl_kanban_card_print_temp
                  (report_id, kanban_card_id
                  )
           VALUES (v_report_id, l_value
                  );

Line: 257

		SELECT LOWER(FL.iso_language),ISO_TERRITORY
		INTO l_language,l_territory
		FROM NLS_SESSION_PARAMETERS NSP
		,fnd_languages FL
		WHERE NSP.parameter = 'NLS_LANGUAGE'
		AND NSP.value = FL.nls_language;