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.

APPS.OZF_COPY_OFFER_PVT dependencies on AMS_CPYUTILITY_PVT

Line 644: , p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type

640: , x_msg_data OUT NOCOPY VARCHAR2
641: , p_listHeaderId IN NUMBER
642: , x_OfferId OUT NOCOPY NUMBER
643: , x_listHeaderId OUT NOCOPY NUMBER
644: , p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type
645: , p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type
646: , p_custom_setup_id IN NUMBER
647: )
648: IS

Line 645: , p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type

641: , p_listHeaderId IN NUMBER
642: , x_OfferId OUT NOCOPY NUMBER
643: , x_listHeaderId OUT NOCOPY NUMBER
644: , p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type
645: , p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type
646: , p_custom_setup_id IN NUMBER
647: )
648: IS
649: l_modifier_list_rec OZF_OFFER_PVT.modifier_list_rec_type ;

Line 746: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);

742: -- initialize the record sent to api for creation
743: l_modifier_list_rec := null;
744:
745: -- populate ui values into record.
746: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
747: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
748: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
749: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
750: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);

Line 747: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);

743: l_modifier_list_rec := null;
744:
745: -- populate ui values into record.
746: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
747: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
748: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
749: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
750: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
751: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);

Line 748: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);

744:
745: -- populate ui values into record.
746: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
747: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
748: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
749: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
750: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
751: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);
752:

Line 749: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);

745: -- populate ui values into record.
746: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
747: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
748: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
749: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
750: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
751: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);
752:
753: FOR l_offer_details IN c_offer_details(p_listHeaderId) LOOP

Line 750: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);

746: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
747: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
748: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
749: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
750: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
751: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);
752:
753: FOR l_offer_details IN c_offer_details(p_listHeaderId) LOOP
754:

Line 751: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);

747: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
748: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
749: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
750: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
751: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);
752:
753: FOR l_offer_details IN c_offer_details(p_listHeaderId) LOOP
754:
755: --rvkondur Bug#12888855

Line 876: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN

872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: END IF;
874:
875: -- copy qualifiers
876: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
877: ozf_utility_pvt.debug_message('Copy Eligibility');
878: copy_vo_qualifiers
879: (
880: p_api_version => 1.0

Line 897: IF AMS_CpyUtility_PVT.is_copy_attribute ('MKT_OPT', p_attributes_table) = FND_API.G_TRUE THEN

893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895: -- copy market options
896: -- market options are created with default options, so update the market options to the ones in the source offer
897: IF AMS_CpyUtility_PVT.is_copy_attribute ('MKT_OPT', p_attributes_table) = FND_API.G_TRUE THEN
898: ozf_utility_pvt.debug_message('Copy Market Options');
899: copy_vo_mkt_options
900: (
901: p_api_version => 1.0

Line 1565: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

1561: x_return_status OUT NOCOPY VARCHAR2,
1562: x_msg_count OUT NOCOPY NUMBER,
1563: x_msg_data OUT NOCOPY VARCHAR2,
1564: p_source_object_id IN NUMBER,
1565: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
1566: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
1567: x_new_object_id OUT NOCOPY NUMBER,
1568: p_custom_setup_id IN NUMBER)
1569: IS

Line 1566: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

1562: x_msg_count OUT NOCOPY NUMBER,
1563: x_msg_data OUT NOCOPY VARCHAR2,
1564: p_source_object_id IN NUMBER,
1565: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
1566: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
1567: x_new_object_id OUT NOCOPY NUMBER,
1568: p_custom_setup_id IN NUMBER)
1569: IS
1570:

Line 1790: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);

1786:
1787: l_offer_rec.custom_setup_id := p_custom_setup_id;
1788:
1789: -- getting values from UI
1790: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1791: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1792: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1793: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1794: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);

Line 1791: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);

1787: l_offer_rec.custom_setup_id := p_custom_setup_id;
1788:
1789: -- getting values from UI
1790: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1791: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1792: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1793: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1794: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1795: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);

Line 1792: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);

1788:
1789: -- getting values from UI
1790: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1791: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1792: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1793: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1794: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1795: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1796: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);

Line 1793: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);

1789: -- getting values from UI
1790: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1791: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1792: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1793: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1794: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1795: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1796: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);
1797:

Line 1794: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);

1790: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1791: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1792: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1793: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1794: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1795: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1796: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);
1797:
1798: /*ninarasi bug 12621645 - removed start date validation for copy offer.

Line 1795: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);

1791: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1792: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1793: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1794: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1795: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1796: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);
1797:
1798: /*ninarasi bug 12621645 - removed start date validation for copy offer.
1799: -- bug fix 2779988: validate start date and end date

Line 1796: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);

1792: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1793: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1794: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1795: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1796: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);
1797:
1798: /*ninarasi bug 12621645 - removed start date validation for copy offer.
1799: -- bug fix 2779988: validate start date and end date
1800: IF l_modifier_list_rec.start_date_active IS NOT NULL

Line 2655: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE THEN

2651: l_offer_rec.qp_list_header_id := l_listHeaderId;
2652: END;
2653: END IF;
2654:
2655: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE THEN
2656: l_errnum := 0;
2657: l_errcode := NULL;
2658: l_errmsg := NULL;
2659: ams_copyelements_pvt.copy_act_attachments( p_src_act_type => 'OZF_OFFR',

Line 2667: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN

2663: p_errcode => l_errcode,
2664: p_errmsg => l_errmsg);
2665: END IF;
2666:
2667: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN
2668: FOR l_contact_point IN c_contact_point LOOP
2669: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2670: l_contact_point_rec.last_update_date := SYSDATE;
2671: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;

Line 2719: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN

2715: END IF;
2716: END LOOP;
2717: END IF;
2718: /* ELIG is copied by QP API
2719: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
2720: FOR l_market_elig_rec IN c_market_elig LOOP
2721: l_index2 := l_index2 + 1;
2722: l_qualifier_tbl(l_index2).qualifier_context := l_market_elig_rec.qualifier_context;
2723: l_qualifier_tbl(l_index2).qualifier_attribute := l_market_elig_rec.qualifier_attribute;

Line 2753: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_FALSE THEN

2749: RAISE FND_API.G_EXC_ERROR;
2750: END IF;
2751: END IF;
2752: */
2753: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_FALSE THEN
2754: IF l_offer_rec.offer_type IN ('ACCRUAL', 'OFF_INVOICE', 'TERMS', 'ORDER', 'OID') THEN
2755: DELETE FROM qp_qualifiers
2756: WHERE list_header_id = l_offer_rec.qp_list_header_id
2757: AND list_line_id = -1;

Line 2766: IF AMS_CpyUtility_PVT.is_copy_attribute ('CONTENT', p_attributes_table) = FND_API.G_TRUE THEN

2762: ,p_new_offer_id => l_offer_rec.offer_id);
2763: END IF;
2764: END IF;
2765:
2766: IF AMS_CpyUtility_PVT.is_copy_attribute ('CONTENT', p_attributes_table) = FND_API.G_TRUE THEN
2767: l_errnum := 0;
2768: l_errcode := NULL;
2769: l_errmsg := NULL;
2770: ams_copyelements_pvt.copy_act_content(p_src_act_type => 'OZF_OFFR',

Line 2778: IF AMS_CpyUtility_PVT.is_copy_attribute ('TEAM', p_attributes_table) = FND_API.G_TRUE THEN

2774: p_errcode => l_errcode,
2775: p_errmsg => l_errmsg);
2776: END IF;
2777:
2778: IF AMS_CpyUtility_PVT.is_copy_attribute ('TEAM', p_attributes_table) = FND_API.G_TRUE THEN
2779: l_errnum := 0;
2780: l_errcode := NULL;
2781: l_errmsg := NULL;
2782: ams_copyelements_pvt.copy_act_access(p_src_act_type => 'OFFR',

Line 2844: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

2840: x_return_status OUT NOCOPY VARCHAR2,
2841: x_msg_count OUT NOCOPY NUMBER,
2842: x_msg_data OUT NOCOPY VARCHAR2,
2843: p_source_object_id IN NUMBER,
2844: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
2845: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
2846: x_new_object_id OUT NOCOPY NUMBER,
2847: x_custom_setup_id OUT NOCOPY NUMBER)
2848: IS

Line 2845: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

2841: x_msg_count OUT NOCOPY NUMBER,
2842: x_msg_data OUT NOCOPY VARCHAR2,
2843: p_source_object_id IN NUMBER,
2844: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
2845: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
2846: x_new_object_id OUT NOCOPY NUMBER,
2847: x_custom_setup_id OUT NOCOPY NUMBER)
2848: IS
2849: CURSOR c_budget_offer_yn IS