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.

[Home] [Help]

APPS.QP_MODIFIERS_ISETUP_IMP dependencies on DBMS_XMLSAVE

Line 175: insCtx DBMS_XMLSave.ctxType;

171: X_return_status OUT NOCOPY VARCHAR2,
172: X_msg_count OUT NOCOPY NUMBER,
173: X_G_MSG_DATA OUT NOCOPY Long ) IS
174:
175: insCtx DBMS_XMLSave.ctxType;
176: rows NUMBER;
177: i NUMBER;
178: j NUMBER;
179: l NUMBER :=1;

Line 531: insCtx := Dbms_Xmlsave.newContext('QP_LIST_HEADER_TEMP');

527: IF (P_modifier_list_XML IS NOT NULL) THEN
528: -- Modifier Header Record
529: -- get the context handle
530:
531: insCtx := Dbms_Xmlsave.newContext('QP_LIST_HEADER_TEMP');
532: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
533: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
534: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListHeadersVO');
535: -- this inserts the document

Line 532: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);

528: -- Modifier Header Record
529: -- get the context handle
530:
531: insCtx := Dbms_Xmlsave.newContext('QP_LIST_HEADER_TEMP');
532: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
533: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
534: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListHeadersVO');
535: -- this inserts the document
536: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_XML);

Line 533: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

529: -- get the context handle
530:
531: insCtx := Dbms_Xmlsave.newContext('QP_LIST_HEADER_TEMP');
532: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
533: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
534: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListHeadersVO');
535: -- this inserts the document
536: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_XML);
537: -- this closes the handle

Line 534: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListHeadersVO');

530:
531: insCtx := Dbms_Xmlsave.newContext('QP_LIST_HEADER_TEMP');
532: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
533: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
534: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListHeadersVO');
535: -- this inserts the document
536: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_XML);
537: -- this closes the handle
538: Dbms_Xmlsave.closeContext(insCtx);

Line 536: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_XML);

532: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
533: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
534: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListHeadersVO');
535: -- this inserts the document
536: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_XML);
537: -- this closes the handle
538: Dbms_Xmlsave.closeContext(insCtx);
539:
540: END IF;

Line 538: Dbms_Xmlsave.closeContext(insCtx);

534: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListHeadersVO');
535: -- this inserts the document
536: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_XML);
537: -- this closes the handle
538: Dbms_Xmlsave.closeContext(insCtx);
539:
540: END IF;
541:
542:

Line 547: insCtx := Dbms_Xmlsave.newContext('QP_LIST_LINES_TEMP');

543:
544: IF (P_modifier_list_lines_XML IS NOT NULL) THEN
545: -- Modifier List Line Record
546: -- get the context handle
547: insCtx := Dbms_Xmlsave.newContext('QP_LIST_LINES_TEMP');
548: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
549: Dbms_Xmlsave.setDateFormat(insCtx, 'YYYY-MM-dd HH:mm:ss');
550: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListLinesVO');
551: -- this inserts the document

Line 548: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);

544: IF (P_modifier_list_lines_XML IS NOT NULL) THEN
545: -- Modifier List Line Record
546: -- get the context handle
547: insCtx := Dbms_Xmlsave.newContext('QP_LIST_LINES_TEMP');
548: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
549: Dbms_Xmlsave.setDateFormat(insCtx, 'YYYY-MM-dd HH:mm:ss');
550: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListLinesVO');
551: -- this inserts the document
552: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_lines_XML);

Line 549: Dbms_Xmlsave.setDateFormat(insCtx, 'YYYY-MM-dd HH:mm:ss');

545: -- Modifier List Line Record
546: -- get the context handle
547: insCtx := Dbms_Xmlsave.newContext('QP_LIST_LINES_TEMP');
548: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
549: Dbms_Xmlsave.setDateFormat(insCtx, 'YYYY-MM-dd HH:mm:ss');
550: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListLinesVO');
551: -- this inserts the document
552: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_lines_XML);
553: -- this closes the handle

Line 550: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListLinesVO');

546: -- get the context handle
547: insCtx := Dbms_Xmlsave.newContext('QP_LIST_LINES_TEMP');
548: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
549: Dbms_Xmlsave.setDateFormat(insCtx, 'YYYY-MM-dd HH:mm:ss');
550: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListLinesVO');
551: -- this inserts the document
552: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_lines_XML);
553: -- this closes the handle
554: Dbms_Xmlsave.closeContext(insCtx);

Line 552: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_lines_XML);

548: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
549: Dbms_Xmlsave.setDateFormat(insCtx, 'YYYY-MM-dd HH:mm:ss');
550: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListLinesVO');
551: -- this inserts the document
552: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_lines_XML);
553: -- this closes the handle
554: Dbms_Xmlsave.closeContext(insCtx);
555: END IF;
556:

Line 554: Dbms_Xmlsave.closeContext(insCtx);

550: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersListLinesVO');
551: -- this inserts the document
552: rows := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_lines_XML);
553: -- this closes the handle
554: Dbms_Xmlsave.closeContext(insCtx);
555: END IF;
556:
557:
558: IF (P_pricing_attributes_XML IS NOT NULL) THEN

Line 561: insCtx := Dbms_Xmlsave.newContext('QP_PRICING_ATTRIBUTES_TEMP');

557:
558: IF (P_pricing_attributes_XML IS NOT NULL) THEN
559: -- PricingAttributes Record
560: -- get the context handle
561: insCtx := Dbms_Xmlsave.newContext('QP_PRICING_ATTRIBUTES_TEMP');
562: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
563: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
564: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersPricingAttributesVO');
565: -- this inserts the document

Line 562: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);

558: IF (P_pricing_attributes_XML IS NOT NULL) THEN
559: -- PricingAttributes Record
560: -- get the context handle
561: insCtx := Dbms_Xmlsave.newContext('QP_PRICING_ATTRIBUTES_TEMP');
562: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
563: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
564: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersPricingAttributesVO');
565: -- this inserts the document
566: rows := Dbms_Xmlsave.insertXML(insCtx, P_pricing_attributes_XML);

Line 563: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

559: -- PricingAttributes Record
560: -- get the context handle
561: insCtx := Dbms_Xmlsave.newContext('QP_PRICING_ATTRIBUTES_TEMP');
562: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
563: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
564: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersPricingAttributesVO');
565: -- this inserts the document
566: rows := Dbms_Xmlsave.insertXML(insCtx, P_pricing_attributes_XML);
567: -- this closes the handle

Line 564: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersPricingAttributesVO');

560: -- get the context handle
561: insCtx := Dbms_Xmlsave.newContext('QP_PRICING_ATTRIBUTES_TEMP');
562: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
563: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
564: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersPricingAttributesVO');
565: -- this inserts the document
566: rows := Dbms_Xmlsave.insertXML(insCtx, P_pricing_attributes_XML);
567: -- this closes the handle
568: Dbms_Xmlsave.closeContext(insCtx);

Line 566: rows := Dbms_Xmlsave.insertXML(insCtx, P_pricing_attributes_XML);

562: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
563: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
564: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersPricingAttributesVO');
565: -- this inserts the document
566: rows := Dbms_Xmlsave.insertXML(insCtx, P_pricing_attributes_XML);
567: -- this closes the handle
568: Dbms_Xmlsave.closeContext(insCtx);
569: END IF;
570:

Line 568: Dbms_Xmlsave.closeContext(insCtx);

564: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersPricingAttributesVO');
565: -- this inserts the document
566: rows := Dbms_Xmlsave.insertXML(insCtx, P_pricing_attributes_XML);
567: -- this closes the handle
568: Dbms_Xmlsave.closeContext(insCtx);
569: END IF;
570:
571:
572: IF (P_Qualifiers_XML IS NOT NULL) THEN

Line 575: insCtx := Dbms_Xmlsave.newContext('QP_QUALIFIERS_TEMP');

571:
572: IF (P_Qualifiers_XML IS NOT NULL) THEN
573: -- Qualifiers Record
574: -- get the context handle
575: insCtx := Dbms_Xmlsave.newContext('QP_QUALIFIERS_TEMP');
576: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
577: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
578: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersQualifiersVO');
579: -- this inserts the document

Line 576: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);

572: IF (P_Qualifiers_XML IS NOT NULL) THEN
573: -- Qualifiers Record
574: -- get the context handle
575: insCtx := Dbms_Xmlsave.newContext('QP_QUALIFIERS_TEMP');
576: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
577: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
578: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersQualifiersVO');
579: -- this inserts the document
580: rows := Dbms_Xmlsave.insertXML(insCtx, P_Qualifiers_XML);

Line 577: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

573: -- Qualifiers Record
574: -- get the context handle
575: insCtx := Dbms_Xmlsave.newContext('QP_QUALIFIERS_TEMP');
576: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
577: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
578: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersQualifiersVO');
579: -- this inserts the document
580: rows := Dbms_Xmlsave.insertXML(insCtx, P_Qualifiers_XML);
581: -- this closes the handle

Line 578: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersQualifiersVO');

574: -- get the context handle
575: insCtx := Dbms_Xmlsave.newContext('QP_QUALIFIERS_TEMP');
576: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
577: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
578: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersQualifiersVO');
579: -- this inserts the document
580: rows := Dbms_Xmlsave.insertXML(insCtx, P_Qualifiers_XML);
581: -- this closes the handle
582: Dbms_Xmlsave.closeContext(insCtx);

Line 580: rows := Dbms_Xmlsave.insertXML(insCtx, P_Qualifiers_XML);

576: Dbms_Xmlsave.setIgnoreCase(insCtx, 1);
577: Dbms_Xmlsave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
578: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersQualifiersVO');
579: -- this inserts the document
580: rows := Dbms_Xmlsave.insertXML(insCtx, P_Qualifiers_XML);
581: -- this closes the handle
582: Dbms_Xmlsave.closeContext(insCtx);
583: END IF;
584:

Line 582: Dbms_Xmlsave.closeContext(insCtx);

578: Dbms_Xmlsave.setRowTag(insCtx , 'ModifiersQualifiersVO');
579: -- this inserts the document
580: rows := Dbms_Xmlsave.insertXML(insCtx, P_Qualifiers_XML);
581: -- this closes the handle
582: Dbms_Xmlsave.closeContext(insCtx);
583: END IF;
584:
585:
586: