DBA Data[Home] [Help]

APPS.QP_MODIFIER_LIST_UTIL SQL Statements

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

Line: 185

        IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)
        THEN
            l_index := l_index + 1;
Line: 188

            l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
Line: 191

        IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)
        THEN
            l_index := l_index + 1;
Line: 194

            l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
Line: 197

        IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)
        THEN
            l_index := l_index + 1;
Line: 200

            l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
Line: 227

        IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)
        THEN
            l_index := l_index + 1;
Line: 230

            l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 455

    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        l_index := l_index + 1;
Line: 457

        l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
Line: 458

    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        l_index := l_index + 1;
Line: 460

        l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
Line: 461

    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        l_index := l_index + 1;
Line: 463

        l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
Line: 476

    ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
        l_index := l_index + 1;
Line: 478

        l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 570

select distinct pricing_phase_id from qp_list_lines
where list_header_id = l_list_header_id;
Line: 659

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 698

	  IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
            qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 714

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 739

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 764

    IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)
    THEN
        NULL;
Line: 769

    IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)
    THEN
        NULL;
Line: 774

    IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)
    THEN
        NULL;
Line: 788

	  IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
            qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 805

         IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 830

    IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)
    THEN
        NULL;
Line: 860

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 884

	   IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
            qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 900

         IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
            qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 932

          	p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,
			p_param1 => p_MODIFIER_LIST_rec.active_flag,
          	x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 943

                p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
                x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 947

            	 IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                  qp_delayed_requests_pvt.log_request(
		  p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		  p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		  p_request_unique_key1 => NULL,
		  p_request_unique_key2 => 'UD',
		  p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		  p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		  p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		  x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 963

         IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                  qp_delayed_requests_pvt.log_request(
		  p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		  p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		  p_request_unique_key1 => NULL,
		  p_request_unique_key2 => 'UD',
		  p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		  p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		  p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		  x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 978

  IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

	BEGIN
	select 'Y' into l_modifiers_exist
	from qp_list_lines
	where list_header_id = p_MODIFIER_LIST_rec.list_header_id
	and rownum = 1;
Line: 1002

                 p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE,
                 x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1011

                p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
                x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1016

  IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

           Update QP_QUALIFIERS
           set    active_flag = p_MODIFIER_LIST_rec.active_flag
           where  list_header_id = p_MODIFIER_LIST_rec.list_header_id;
Line: 1024

	update qp_pte_segments set used_in_setup='Y'
	where nvl(used_in_setup,'N')='N'
	and segment_id in
	(select  a.segment_id
	from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c
	where c.list_header_id         = p_MODIFIER_LIST_rec.list_header_id
	and   a.segment_mapping_column = c .qualifier_attribute
	and   a.prc_context_id         = b.prc_context_id
	and   b.prc_context_type       = 'QUALIFIER'
	and   b.prc_context_code       = c.qualifier_context);
Line: 1035

	update qp_pte_segments d set used_in_setup='Y'
	where nvl(used_in_setup,'N')='N'
	and exists
	(select  'x'
	from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
	where c.list_header_id         = p_MODIFIER_LIST_rec.list_header_id
	and   a.segment_mapping_column = c.pricing_attribute
        and   a.segment_id             = d.segment_id
	and   a.prc_context_id         = b.prc_context_id
	and   b.prc_context_type       = 'PRICING_ATTRIBUTE'
	and   b.prc_context_code       = c.pricing_attribute_context);
Line: 1047

	update qp_pte_segments d set used_in_setup='Y'
	where nvl(used_in_setup,'N')='N'
	and exists
	(select  'x'
	from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
	where c.list_header_id         = p_MODIFIER_LIST_rec.list_header_id
	and   a.segment_mapping_column = c.product_attribute
        and   a.segment_id             = d.segment_id
	and   a.prc_context_id         = b.prc_context_id
	and   b.prc_context_type       = 'PRODUCT'
	and   b.prc_context_code       = c.product_attribute_context);
Line: 1059

	update qp_pte_segments set used_in_setup='Y'
	where nvl(used_in_setup,'N')='N'
	and segment_id in
	(select  a.segment_id
	from qp_segments_b a,qp_prc_contexts_b b,qp_limits c
	where c.list_header_id         = p_MODIFIER_LIST_rec.list_header_id
	and   a.segment_mapping_column = c.multival_attribute1
	and   a.prc_context_id         = b.prc_context_id
	and   b.prc_context_type       = c.multival_attr1_type
	and   b.prc_context_code       = c.multival_attr1_context);
Line: 1070

	update qp_pte_segments set used_in_setup='Y'
	where nvl(used_in_setup,'N')='N'
	and segment_id in
	(select  a.segment_id
	from qp_segments_b a,qp_prc_contexts_b b,qp_limits c
	where c.list_header_id         = p_MODIFIER_LIST_rec.list_header_id
	and   a.segment_mapping_column = c.multival_attribute2
	and   a.prc_context_id         = b.prc_context_id
	and   b.prc_context_type       = c.multival_attr2_type
	and   b.prc_context_code       = c.multival_attr2_context);
Line: 1082

	update qp_pte_segments set used_in_setup='Y'
	where nvl(used_in_setup,'N')='N'
	and segment_id in
	(select  a.segment_id
	from qp_segments_b a,qp_prc_contexts_b b,qp_limit_attributes c,qp_limits d
	where c.limit_id               = d.limit_id
        and   d.list_header_id         = p_MODIFIER_LIST_rec.list_header_id
	and   a.segment_mapping_column = c.limit_attribute
	and   a.prc_context_id         = b.prc_context_id
	and   b.prc_context_type       = c.limit_attribute_type
	and   b.prc_context_code       = c.limit_attribute_context);
Line: 1109

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1129

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1149

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1169

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1189

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1210

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1230

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
                qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1249

	  IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
             qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1265

         IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
             qp_delayed_requests_pvt.log_request(
		p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_unique_key1 => NULL,
		p_request_unique_key2 => 'UD',
		p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
		p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
		p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
		x_return_status => x_MODIFIER_LIST_rec.return_status);
Line: 1428

    IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_MODIFIER_LIST_rec.last_updated_by := p_old_MODIFIER_LIST_rec.last_updated_by;
Line: 1432

    IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_MODIFIER_LIST_rec.last_update_date := p_old_MODIFIER_LIST_rec.last_update_date;
Line: 1436

    IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_MODIFIER_LIST_rec.last_update_login := p_old_MODIFIER_LIST_rec.last_update_login;
Line: 1456

    IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_MODIFIER_LIST_rec.program_update_date := p_old_MODIFIER_LIST_rec.program_update_date;
Line: 1680

    IF l_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_MODIFIER_LIST_rec.last_updated_by := NULL;
Line: 1684

    IF l_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_MODIFIER_LIST_rec.last_update_date := NULL;
Line: 1688

    IF l_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_MODIFIER_LIST_rec.last_update_login := NULL;
Line: 1708

    IF l_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_MODIFIER_LIST_rec.program_update_date := NULL;
Line: 1801

PROCEDURE Update_Row
(   p_MODIFIER_LIST_rec             IN  QP_Modifiers_PUB.Modifier_List_Rec_Type
)
IS
l_active_date_first_type   VARCHAR2(30);
Line: 1813

	oe_debug_pub.add('BEGIN update_row in QPXUMLHB');
Line: 1834

    if QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
                                   p_instance_type => QP_Security.G_MODIFIER_OBJECT,
                                   p_instance_pk1 => p_MODIFIER_LIST_rec.list_header_id) <> 'F' then

    --for moac changes QP_LIST_HEADERS_B to all_b to enable updates to ML with orig_org_id
    --that do not belong to the responsibility when the user has update privilges
    UPDATE  QP_LIST_HEADERS_ALL_B
    SET     ATTRIBUTE1                     = p_MODIFIER_LIST_rec.attribute1
    ,       ATTRIBUTE10                    = p_MODIFIER_LIST_rec.attribute10
    ,       ATTRIBUTE11                    = p_MODIFIER_LIST_rec.attribute11
    ,       ATTRIBUTE12                    = p_MODIFIER_LIST_rec.attribute12
    ,       ATTRIBUTE13                    = p_MODIFIER_LIST_rec.attribute13
    ,       ATTRIBUTE14                    = p_MODIFIER_LIST_rec.attribute14
    ,       ATTRIBUTE15                    = p_MODIFIER_LIST_rec.attribute15
    ,       ATTRIBUTE2                     = p_MODIFIER_LIST_rec.attribute2
    ,       ATTRIBUTE3                     = p_MODIFIER_LIST_rec.attribute3
    ,       ATTRIBUTE4                     = p_MODIFIER_LIST_rec.attribute4
    ,       ATTRIBUTE5                     = p_MODIFIER_LIST_rec.attribute5
    ,       ATTRIBUTE6                     = p_MODIFIER_LIST_rec.attribute6
    ,       ATTRIBUTE7                     = p_MODIFIER_LIST_rec.attribute7
    ,       ATTRIBUTE8                     = p_MODIFIER_LIST_rec.attribute8
    ,       ATTRIBUTE9                     = p_MODIFIER_LIST_rec.attribute9
    ,       AUTOMATIC_FLAG                 = p_MODIFIER_LIST_rec.automatic_flag
    ,       COMMENTS                       = p_MODIFIER_LIST_rec.comments
    ,       CONTEXT                        = p_MODIFIER_LIST_rec.context
    ,       CREATED_BY                     = p_MODIFIER_LIST_rec.created_by
    ,       CREATION_DATE                  = p_MODIFIER_LIST_rec.creation_date
    ,       CURRENCY_CODE                  = p_MODIFIER_LIST_rec.currency_code
    ,       DISCOUNT_LINES_FLAG            = p_MODIFIER_LIST_rec.discount_lines_flag
    ,       END_DATE_ACTIVE                = TRUNC(p_MODIFIER_LIST_rec.end_date_active)
    ,       FREIGHT_TERMS_CODE             = p_MODIFIER_LIST_rec.freight_terms_code
    ,       GSA_INDICATOR                  = p_MODIFIER_LIST_rec.gsa_indicator
    ,       LAST_UPDATED_BY                = p_MODIFIER_LIST_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_MODIFIER_LIST_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_MODIFIER_LIST_rec.last_update_login
    ,       LIST_HEADER_ID                 = p_MODIFIER_LIST_rec.list_header_id
    ,       LIST_TYPE_CODE                 = p_MODIFIER_LIST_rec.list_type_code
    ,       PROGRAM_APPLICATION_ID         = p_MODIFIER_LIST_rec.program_application_id
    ,       PROGRAM_ID                     = p_MODIFIER_LIST_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_MODIFIER_LIST_rec.program_update_date
    ,       PRORATE_FLAG                   = p_MODIFIER_LIST_rec.prorate_flag
    ,       REQUEST_ID                     = p_MODIFIER_LIST_rec.request_id
    ,       ROUNDING_FACTOR                = p_MODIFIER_LIST_rec.rounding_factor
    ,       SHIP_METHOD_CODE               = p_MODIFIER_LIST_rec.ship_method_code
    ,       START_DATE_ACTIVE              = TRUNC(p_MODIFIER_LIST_rec.start_date_active)
    ,       TERMS_ID                       = p_MODIFIER_LIST_rec.terms_id
    ,       SOURCE_SYSTEM_CODE             = p_MODIFIER_LIST_rec.source_system_code
    ,       PTE_CODE                       = p_MODIFIER_LIST_rec.pte_code
    ,       ACTIVE_FLAG                    = p_MODIFIER_LIST_rec.active_flag
    ,       PARENT_LIST_HEADER_ID          = p_MODIFIER_LIST_rec.parent_list_header_id
    ,       START_DATE_ACTIVE_FIRST        = TRUNC(l_start_date_active_first)
    ,       END_DATE_ACTIVE_FIRST          = TRUNC(l_end_date_active_first)
    ,       ACTIVE_DATE_FIRST_TYPE         = l_active_date_first_type
    ,       START_DATE_ACTIVE_SECOND       = TRUNC(l_start_date_active_second)
    ,       GLOBAL_FLAG                    = p_MODIFIER_LIST_rec.global_flag
    ,       END_DATE_ACTIVE_SECOND         = TRUNC(l_end_date_active_second)
    ,       ACTIVE_DATE_SECOND_TYPE        = l_active_date_second_type
    ,       ASK_FOR_FLAG                   = p_MODIFIER_LIST_rec.ask_for_flag
    ,       LIST_SOURCE_CODE               = p_MODIFIER_LIST_rec.list_source_code
    ,       ORIG_SYSTEM_HEADER_REF         = p_MODIFIER_LIST_rec.orig_system_header_ref
    ,       SHAREABLE_FLAG                 = p_MODIFIER_LIST_rec.shareable_flag
    ,       ORIG_ORG_ID                    = p_MODIFIER_LIST_rec.org_id
    WHERE   LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
    ;
Line: 1901

       update QP_LIST_HEADERS_TL set
         NAME                   = p_MODIFIER_LIST_rec.NAME
       , DESCRIPTION            = p_MODIFIER_LIST_rec.DESCRIPTION
       , VERSION_NO             = p_MODIFIER_LIST_rec.VERSION_NO
       , LAST_UPDATE_DATE       = p_MODIFIER_LIST_rec.LAST_UPDATE_DATE
       , LAST_UPDATED_BY        = p_MODIFIER_LIST_rec.LAST_UPDATED_BY
       , LAST_UPDATE_LOGIN      = p_MODIFIER_LIST_rec.LAST_UPDATE_LOGIN
       , SOURCE_LANG            = userenv('LANG')
       where LIST_HEADER_ID     = p_MODIFIER_LIST_rec.LIST_HEADER_ID
       and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
Line: 1925

                   ,      'Update_Row'
                   );
Line: 1945

            ,   'Update_Row'
            );
Line: 1951

END Update_Row;
Line: 1955

PROCEDURE Insert_Row
(   p_MODIFIER_LIST_rec             IN  QP_Modifiers_PUB.Modifier_List_Rec_Type
)
IS
l_return_status   VARCHAR2(30);
Line: 1972

insert into QP_LIST_HEADERS_TL
( LIST_HEADER_ID
, NAME
, DESCRIPTION
, VERSION_NO
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LANGUAGE
, SOURCE_LANG
) select
  p_MODIFIER_LIST_rec.LIST_HEADER_ID
, p_MODIFIER_LIST_rec.NAME
, p_MODIFIER_LIST_rec.DESCRIPTION
, p_MODIFIER_LIST_rec.VERSION_NO
, p_MODIFIER_LIST_rec.CREATION_DATE
, p_MODIFIER_LIST_rec.CREATED_BY
, p_MODIFIER_LIST_rec.LAST_UPDATE_DATE
, p_MODIFIER_LIST_rec.LAST_UPDATED_BY
, p_MODIFIER_LIST_rec.LAST_UPDATE_LOGIN
, L.LANGUAGE_CODE
, userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I','B')
and not exists
(select NULL from QP_LIST_HEADERS_TL T
where T.LIST_HEADER_ID = p_MODIFIER_LIST_rec.LIST_HEADER_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
Line: 2016

            ,   'Insert_Row'
            );
Line: 2024

	oe_debug_pub.add('BEGIN insert_row in QPXUMLHB');
Line: 2045

    INSERT  INTO QP_LIST_HEADERS_B
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AUTOMATIC_FLAG
    ,       COMMENTS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_CODE
    ,       DISCOUNT_LINES_FLAG
    ,       END_DATE_ACTIVE
    ,       FREIGHT_TERMS_CODE
    ,       GSA_INDICATOR
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_TYPE_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PRORATE_FLAG
    ,       REQUEST_ID
    ,       ROUNDING_FACTOR
    ,       SHIP_METHOD_CODE
    ,       START_DATE_ACTIVE
    ,       TERMS_ID
    ,       SOURCE_SYSTEM_CODE
    ,       PTE_CODE
    ,       ACTIVE_FLAG
    ,       PARENT_LIST_HEADER_ID
    ,       START_DATE_ACTIVE_FIRST
    ,       END_DATE_ACTIVE_FIRST
    ,       ACTIVE_DATE_FIRST_TYPE
    ,       START_DATE_ACTIVE_SECOND
    ,       GLOBAL_FLAG
    ,       END_DATE_ACTIVE_SECOND
    ,       ACTIVE_DATE_SECOND_TYPE
    , 	    ASK_FOR_FLAG
    , 	    orig_org_id
    ,       LIST_SOURCE_CODE
    ,       ORIG_SYSTEM_HEADER_REF
    ,       SHAREABLE_FLAG
    )
    VALUES
    (       p_MODIFIER_LIST_rec.attribute1
    ,       p_MODIFIER_LIST_rec.attribute10
    ,       p_MODIFIER_LIST_rec.attribute11
    ,       p_MODIFIER_LIST_rec.attribute12
    ,       p_MODIFIER_LIST_rec.attribute13
    ,       p_MODIFIER_LIST_rec.attribute14
    ,       p_MODIFIER_LIST_rec.attribute15
    ,       p_MODIFIER_LIST_rec.attribute2
    ,       p_MODIFIER_LIST_rec.attribute3
    ,       p_MODIFIER_LIST_rec.attribute4
    ,       p_MODIFIER_LIST_rec.attribute5
    ,       p_MODIFIER_LIST_rec.attribute6
    ,       p_MODIFIER_LIST_rec.attribute7
    ,       p_MODIFIER_LIST_rec.attribute8
    ,       p_MODIFIER_LIST_rec.attribute9
    ,       p_MODIFIER_LIST_rec.automatic_flag
    ,       p_MODIFIER_LIST_rec.comments
    ,       p_MODIFIER_LIST_rec.context
    ,       p_MODIFIER_LIST_rec.created_by
    ,       p_MODIFIER_LIST_rec.creation_date
    ,       p_MODIFIER_LIST_rec.currency_code
    ,       p_MODIFIER_LIST_rec.discount_lines_flag
    ,       TRUNC(p_MODIFIER_LIST_rec.end_date_active)
    ,       p_MODIFIER_LIST_rec.freight_terms_code
    ,       p_MODIFIER_LIST_rec.gsa_indicator
    ,       p_MODIFIER_LIST_rec.last_updated_by
    ,       p_MODIFIER_LIST_rec.last_update_date
    ,       p_MODIFIER_LIST_rec.last_update_login
    ,       p_MODIFIER_LIST_rec.list_header_id
    ,       p_MODIFIER_LIST_rec.list_type_code
    ,       p_MODIFIER_LIST_rec.program_application_id
    ,       p_MODIFIER_LIST_rec.program_id
    ,       p_MODIFIER_LIST_rec.program_update_date
    ,       p_MODIFIER_LIST_rec.prorate_flag
    ,       p_MODIFIER_LIST_rec.request_id
    ,       p_MODIFIER_LIST_rec.rounding_factor
    ,       p_MODIFIER_LIST_rec.ship_method_code
    ,       TRUNC(p_MODIFIER_LIST_rec.start_date_active)
    ,       p_MODIFIER_LIST_rec.terms_id
    ,       p_MODIFIER_LIST_rec.source_system_code
    ,       p_MODIFIER_LIST_rec.pte_code
    ,       p_MODIFIER_LIST_rec.active_flag
    ,       p_MODIFIER_LIST_rec.parent_list_header_id
    ,       TRUNC(l_start_date_active_first)
    ,       TRUNC(l_end_date_active_first)
    ,       l_active_date_first_type
    ,       TRUNC(l_start_date_active_second)
    ,       p_MODIFIER_LIST_rec.global_flag
    ,       TRUNC(l_end_date_active_second)
    ,       l_active_date_second_type
    ,       p_MODIFIER_LIST_rec.ask_for_flag
            --added for MOAC
    ,       p_MODIFIER_LIST_rec.org_id
    ,       p_MODIFIER_LIST_rec.list_source_code
    ,       p_MODIFIER_LIST_rec.orig_system_header_ref
    ,       p_MODIFIER_LIST_rec.shareable_flag
    );
Line: 2165

	oe_debug_pub.add('insert QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));
Line: 2196

	oe_debug_pub.add('insert after QPXUMLHB'||p_MODIFIER_LIST_rec.VERSION_NO||to_char(p_modifier_list_rec.list_header_id));
Line: 2197

	oe_debug_pub.add('END insert_row in QPXUMLHB');
Line: 2218

            ,   'Insert_Row'
            );
Line: 2244

            ,   'Insert_Row'
            );
Line: 2257

            ,   'Insert_Row'
            );
Line: 2263

END Insert_Row;
Line: 2267

PROCEDURE Delete_Row
(   p_list_header_id                IN  NUMBER
)
IS
CURSOR C1(a_list_header_id NUMBER)
IS
  SELECT list_line_id
  FROM   qp_list_lines
  WHERE  list_header_id = a_list_header_id;
Line: 2279

	oe_debug_pub.add('BEGIN delete_row in QPXUMLHB');
Line: 2284

    DELETE FROM QP_PRICING_ATTRIBUTES
    WHERE LIST_LINE_ID = list_lines.list_line_id;
Line: 2287

    DELETE FROM QP_RLTD_MODIFIERS
    WHERE FROM_RLTD_MODIFIER_ID = list_lines.list_line_id;
Line: 2292

    DELETE FROM QP_LIST_LINES
    WHERE LIST_HEADER_ID = p_list_header_id;
Line: 2295

    DELETE FROM QP_QUALIFIERS
    WHERE LIST_HEADER_ID = p_list_header_id;
Line: 2298

    DELETE FROM QP_LIST_HEADERS_TL
    WHERE LIST_HEADER_ID = p_list_header_id;
Line: 2301

    DELETE  FROM QP_LIST_HEADERS_B
    WHERE   LIST_HEADER_ID = p_list_header_id ;
Line: 2304

	oe_debug_pub.add('END delete_row in QPXUMLHB');
Line: 2313

            ,   'Delete_Row'
            );
Line: 2319

END Delete_Row;
Line: 2332

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AUTOMATIC_FLAG
    ,       COMMENTS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CURRENCY_CODE
    ,       DISCOUNT_LINES_FLAG
    ,       END_DATE_ACTIVE
    ,       FREIGHT_TERMS_CODE
    ,       GSA_INDICATOR
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_TYPE_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PRORATE_FLAG
    ,       REQUEST_ID
    ,       ROUNDING_FACTOR
    ,       SHIP_METHOD_CODE
    ,       START_DATE_ACTIVE
    ,       TERMS_ID
    ,       SOURCE_SYSTEM_CODE
    ,       PTE_CODE
    ,       ACTIVE_FLAG
    ,       PARENT_LIST_HEADER_ID
    ,       START_DATE_ACTIVE_FIRST
    ,       END_DATE_ACTIVE_FIRST
    ,       ACTIVE_DATE_FIRST_TYPE
    ,       START_DATE_ACTIVE_SECOND
    ,       GLOBAL_FLAG
    ,       END_DATE_ACTIVE_SECOND
    ,       ACTIVE_DATE_SECOND_TYPE
    ,       ASK_FOR_FLAG
    ,       LIST_SOURCE_CODE
    ,       ORIG_SYSTEM_HEADER_REF
    ,       SHAREABLE_FLAG
            --added for MOAC
    ,       orig_org_id
    INTO    l_MODIFIER_LIST_rec.attribute1
    ,       l_MODIFIER_LIST_rec.attribute10
    ,       l_MODIFIER_LIST_rec.attribute11
    ,       l_MODIFIER_LIST_rec.attribute12
    ,       l_MODIFIER_LIST_rec.attribute13
    ,       l_MODIFIER_LIST_rec.attribute14
    ,       l_MODIFIER_LIST_rec.attribute15
    ,       l_MODIFIER_LIST_rec.attribute2
    ,       l_MODIFIER_LIST_rec.attribute3
    ,       l_MODIFIER_LIST_rec.attribute4
    ,       l_MODIFIER_LIST_rec.attribute5
    ,       l_MODIFIER_LIST_rec.attribute6
    ,       l_MODIFIER_LIST_rec.attribute7
    ,       l_MODIFIER_LIST_rec.attribute8
    ,       l_MODIFIER_LIST_rec.attribute9
    ,       l_MODIFIER_LIST_rec.automatic_flag
    ,       l_MODIFIER_LIST_rec.comments
    ,       l_MODIFIER_LIST_rec.context
    ,       l_MODIFIER_LIST_rec.created_by
    ,       l_MODIFIER_LIST_rec.creation_date
    ,       l_MODIFIER_LIST_rec.currency_code
    ,       l_MODIFIER_LIST_rec.discount_lines_flag
    ,       l_MODIFIER_LIST_rec.end_date_active
    ,       l_MODIFIER_LIST_rec.freight_terms_code
    ,       l_MODIFIER_LIST_rec.gsa_indicator
    ,       l_MODIFIER_LIST_rec.last_updated_by
    ,       l_MODIFIER_LIST_rec.last_update_date
    ,       l_MODIFIER_LIST_rec.last_update_login
    ,       l_MODIFIER_LIST_rec.list_header_id
    ,       l_MODIFIER_LIST_rec.list_type_code
    ,       l_MODIFIER_LIST_rec.program_application_id
    ,       l_MODIFIER_LIST_rec.program_id
    ,       l_MODIFIER_LIST_rec.program_update_date
    ,       l_MODIFIER_LIST_rec.prorate_flag
    ,       l_MODIFIER_LIST_rec.request_id
    ,       l_MODIFIER_LIST_rec.rounding_factor
    ,       l_MODIFIER_LIST_rec.ship_method_code
    ,       l_MODIFIER_LIST_rec.start_date_active
    ,       l_MODIFIER_LIST_rec.terms_id
    ,       l_MODIFIER_LIST_rec.source_system_code
    ,       l_MODIFIER_LIST_rec.pte_code
    ,       l_MODIFIER_LIST_rec.active_flag
    ,       l_MODIFIER_LIST_rec.parent_list_header_id
    ,       l_MODIFIER_LIST_rec.start_date_active_first
    ,       l_MODIFIER_LIST_rec.end_date_active_first
    ,       l_MODIFIER_LIST_rec.active_date_first_type
    ,       l_MODIFIER_LIST_rec.start_date_active_second
    ,       l_MODIFIER_LIST_rec.global_flag
    ,       l_MODIFIER_LIST_rec.end_date_active_second
    ,       l_MODIFIER_LIST_rec.active_date_second_type
    ,       l_MODIFIER_LIST_rec.ask_for_flag
    ,       l_MODIFIER_LIST_rec.list_source_code
    ,       l_MODIFIER_LIST_rec.orig_system_header_ref
    ,       l_MODIFIER_LIST_rec.shareable_flag
            --added for MOAC
    ,      l_MODIFIER_LIST_rec.org_id
    FROM    QP_LIST_HEADERS_B
    WHERE   LIST_HEADER_ID = p_list_header_id
    ;
Line: 2448

    SELECT  NAME
    ,       DESCRIPTION
    ,       VERSION_NO
    INTO    l_MODIFIER_LIST_rec.name
    ,       l_MODIFIER_LIST_rec.description
    ,       l_MODIFIER_LIST_rec.version_no
    FROM    qp_list_headers_tl
    WHERE   LIST_HEADER_ID = p_list_header_id
    AND     LANGUAGE = userenv('LANG');
Line: 2495

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AUTOMATIC_FLAG
    ,       COMMENTS
    ,       CONTEXT
    ,       CREATED_BY
    , trunc(CREATION_DATE)
    ,       CURRENCY_CODE
    ,       DISCOUNT_LINES_FLAG
    , trunc(END_DATE_ACTIVE)
    ,       FREIGHT_TERMS_CODE
    ,       GSA_INDICATOR
    ,       LAST_UPDATED_BY
    , trunc(LAST_UPDATE_DATE)
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_TYPE_CODE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    , trunc(PROGRAM_UPDATE_DATE)
    ,       PRORATE_FLAG
    ,       REQUEST_ID
    ,       ROUNDING_FACTOR
    ,       SHIP_METHOD_CODE
    , trunc(START_DATE_ACTIVE)
    ,       TERMS_ID
    ,       SOURCE_SYSTEM_CODE
    ,       PTE_CODE
    ,       ACTIVE_FLAG
    ,       PARENT_LIST_HEADER_ID
    , trunc(START_DATE_ACTIVE_FIRST)
    , trunc(END_DATE_ACTIVE_FIRST)
    ,      (ACTIVE_DATE_FIRST_TYPE)
    , trunc(START_DATE_ACTIVE_SECOND)
    ,       GLOBAL_FLAG
    , trunc(END_DATE_ACTIVE_SECOND)
    ,      (ACTIVE_DATE_SECOND_TYPE)
    ,       ASK_FOR_FLAG
    ,       LIST_SOURCE_CODE
    ,       ORIG_SYSTEM_HEADER_REF
    ,       SHAREABLE_FLAG
    ,       ORIG_ORG_ID
    INTO    l_MODIFIER_LIST_rec.attribute1
    ,       l_MODIFIER_LIST_rec.attribute10
    ,       l_MODIFIER_LIST_rec.attribute11
    ,       l_MODIFIER_LIST_rec.attribute12
    ,       l_MODIFIER_LIST_rec.attribute13
    ,       l_MODIFIER_LIST_rec.attribute14
    ,       l_MODIFIER_LIST_rec.attribute15
    ,       l_MODIFIER_LIST_rec.attribute2
    ,       l_MODIFIER_LIST_rec.attribute3
    ,       l_MODIFIER_LIST_rec.attribute4
    ,       l_MODIFIER_LIST_rec.attribute5
    ,       l_MODIFIER_LIST_rec.attribute6
    ,       l_MODIFIER_LIST_rec.attribute7
    ,       l_MODIFIER_LIST_rec.attribute8
    ,       l_MODIFIER_LIST_rec.attribute9
    ,       l_MODIFIER_LIST_rec.automatic_flag
    ,       l_MODIFIER_LIST_rec.comments
    ,       l_MODIFIER_LIST_rec.context
    ,       l_MODIFIER_LIST_rec.created_by
    ,       l_MODIFIER_LIST_rec.creation_date
    ,       l_MODIFIER_LIST_rec.currency_code
    ,       l_MODIFIER_LIST_rec.discount_lines_flag
    ,       l_MODIFIER_LIST_rec.end_date_active
    ,       l_MODIFIER_LIST_rec.freight_terms_code
    ,       l_MODIFIER_LIST_rec.gsa_indicator
    ,       l_MODIFIER_LIST_rec.last_updated_by
    ,       l_MODIFIER_LIST_rec.last_update_date
    ,       l_MODIFIER_LIST_rec.last_update_login
    ,       l_MODIFIER_LIST_rec.list_header_id
    ,       l_MODIFIER_LIST_rec.list_type_code
    ,       l_MODIFIER_LIST_rec.program_application_id
    ,       l_MODIFIER_LIST_rec.program_id
    ,       l_MODIFIER_LIST_rec.program_update_date
    ,       l_MODIFIER_LIST_rec.prorate_flag
    ,       l_MODIFIER_LIST_rec.request_id
    ,       l_MODIFIER_LIST_rec.rounding_factor
    ,       l_MODIFIER_LIST_rec.ship_method_code
    ,       l_MODIFIER_LIST_rec.start_date_active
    ,       l_MODIFIER_LIST_rec.terms_id
    ,       l_MODIFIER_LIST_rec.source_system_code
    ,       l_MODIFIER_LIST_rec.pte_code
    ,       l_MODIFIER_LIST_rec.active_flag
    ,       l_MODIFIER_LIST_rec.parent_list_header_id
    ,       l_MODIFIER_LIST_rec.start_date_active_first
    ,       l_MODIFIER_LIST_rec.end_date_active_first
    ,       l_MODIFIER_LIST_rec.active_date_first_type
    ,       l_MODIFIER_LIST_rec.start_date_active_second
    ,       l_MODIFIER_LIST_rec.global_flag
    ,       l_MODIFIER_LIST_rec.end_date_active_second
    ,       l_MODIFIER_LIST_rec.active_date_second_type
    ,       l_MODIFIER_LIST_rec.ask_for_flag
    ,       l_MODIFIER_LIST_rec.list_source_code
    ,       l_MODIFIER_LIST_rec.orig_system_header_ref
    ,       l_MODIFIER_LIST_rec.shareable_flag
            --added for MOAC
    ,       l_MODIFIER_LIST_rec.org_id
    --for moac changes QP_LIST_HEADERS_B to all_b to enable locks/updates to ML with orig_org_id
    --that do not belong to the responsibility when the user has update privilges
    FROM    QP_LIST_HEADERS_ALL_B
    WHERE   LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
        FOR UPDATE NOWAIT;
Line: 2612

    SELECT  NAME
    ,       DESCRIPTION
    ,       VERSION_NO
    INTO    l_MODIFIER_LIST_rec.name
    ,       l_MODIFIER_LIST_rec.description
    ,       l_MODIFIER_LIST_rec.version_no
    FROM    qp_list_headers_tl
    WHERE   LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
    AND     LANGUAGE = userenv('LANG');
Line: 2674

    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
                         l_MODIFIER_LIST_rec.last_updated_by)
--    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
--                         l_MODIFIER_LIST_rec.last_update_date)
    AND  QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
                         l_MODIFIER_LIST_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
                         l_MODIFIER_LIST_rec.list_header_id)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
                         l_MODIFIER_LIST_rec.list_type_code)
    --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
    --                     l_MODIFIER_LIST_rec.program_application_id)
    --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
    --                     l_MODIFIER_LIST_rec.program_id)
    --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
    --                     l_MODIFIER_LIST_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
                         l_MODIFIER_LIST_rec.prorate_flag)
    --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
    --                     l_MODIFIER_LIST_rec.request_id)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
                         l_MODIFIER_LIST_rec.rounding_factor)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
                         l_MODIFIER_LIST_rec.ship_method_code)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
                         l_MODIFIER_LIST_rec.start_date_active)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
                         l_MODIFIER_LIST_rec.terms_id)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
                         l_MODIFIER_LIST_rec.source_system_code)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
                         l_MODIFIER_LIST_rec.pte_code)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
                         l_MODIFIER_LIST_rec.active_flag)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
                         l_MODIFIER_LIST_rec.parent_list_header_id)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
                         l_MODIFIER_LIST_rec.start_date_active_first)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
                         l_MODIFIER_LIST_rec.end_date_active_first)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
                         l_MODIFIER_LIST_rec.active_date_first_type)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
                         l_MODIFIER_LIST_rec.start_date_active_second)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
                         l_MODIFIER_LIST_rec.global_flag)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
                         l_MODIFIER_LIST_rec.end_date_active_second)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
                         l_MODIFIER_LIST_rec.active_date_second_type)
    AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
                         l_MODIFIER_LIST_rec.ask_for_flag)
    AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
                         l_MODIFIER_LIST_rec.list_source_code)
    AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,
                         l_MODIFIER_LIST_rec.orig_system_header_ref)
    AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,
                         l_MODIFIER_LIST_rec.shareable_flag)
    THEN

        --  Row has not changed. Set out parameter.

        x_MODIFIER_LIST_rec            := l_MODIFIER_LIST_rec;
Line: 2773

	oe_debug_pub.add('last_updated_by              :'||l_MODIFIER_LIST_rec.last_updated_by||':'||p_MODIFIER_LIST_rec.last_updated_by||':');
Line: 2774

	oe_debug_pub.add('last_update_date             :'||l_MODIFIER_LIST_rec.last_update_date||':'||p_MODIFIER_LIST_rec.last_update_date||':');
Line: 2775

	oe_debug_pub.add('last_update_login            :'||l_MODIFIER_LIST_rec.last_update_login||':'||p_MODIFIER_LIST_rec.last_update_login||':');
Line: 2780

	oe_debug_pub.add('program_update_date          :'||l_MODIFIER_LIST_rec.program_update_date||':'||p_MODIFIER_LIST_rec.program_update_date||':');
Line: 2828

            FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
Line: 3268

   select qualifier_context, qualifier_attribute
     from qp_qualifiers
    where list_header_id = p_list_header_id
      and ((qualifier_grouping_no = p_qualifier_grouping_no) OR (qualifier_grouping_no = -1))
      and list_line_id = p_list_line_id;