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 734: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);

730: -- initialize the record sent to api for creation
731: l_modifier_list_rec := null;
732:
733: -- populate ui values into record.
734: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
735: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
736: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
737: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
738: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);

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

731: l_modifier_list_rec := null;
732:
733: -- populate ui values into record.
734: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
735: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
736: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
737: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
738: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
739: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);

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

732:
733: -- populate ui values into record.
734: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
735: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
736: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
737: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
738: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
739: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);
740:

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

733: -- populate ui values into record.
734: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
735: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
736: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
737: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
738: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
739: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);
740:
741: FOR l_offer_details IN c_offer_details(p_listHeaderId) LOOP

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

734: AMS_CpyUtility_PVT.get_column_value ('newObjName' , p_copy_columns_table , l_modifier_list_rec.description);
735: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
736: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
737: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
738: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
739: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);
740:
741: FOR l_offer_details IN c_offer_details(p_listHeaderId) LOOP
742: -- populate source object values into the record

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

735: AMS_CpyUtility_PVT.get_column_value ('offerCode' , p_copy_columns_table , l_modifier_list_rec.offer_code);
736: AMS_CpyUtility_PVT.get_column_value ('startDateActive' , p_copy_columns_table , l_modifier_list_rec.start_date_active);
737: AMS_CpyUtility_PVT.get_column_value ('endDateActive' , p_copy_columns_table , l_modifier_list_rec.end_date_active);
738: AMS_CpyUtility_PVT.get_column_value ('ownerId' , p_copy_columns_table , l_modifier_list_rec.owner_id);
739: AMS_CpyUtility_PVT.get_column_value ('description' , p_copy_columns_table , l_modifier_list_rec.comments);
740:
741: FOR l_offer_details IN c_offer_details(p_listHeaderId) LOOP
742: -- populate source object values into the record
743: l_modifier_list_rec.modifier_level_code := l_offer_details.modifier_level_code;

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

845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847:
848: -- copy qualifiers
849: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
850: ozf_utility_pvt.debug_message('Copy Eligibility');
851: copy_vo_qualifiers
852: (
853: p_api_version => 1.0

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

866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868: -- copy market options
869: -- market options are created with default options, so update the market options to the ones in the source offer
870: IF AMS_CpyUtility_PVT.is_copy_attribute ('MKT_OPT', p_attributes_table) = FND_API.G_TRUE THEN
871: ozf_utility_pvt.debug_message('Copy Market Options');
872: copy_vo_mkt_options
873: (
874: p_api_version => 1.0

Line 1538: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

1534: x_return_status OUT NOCOPY VARCHAR2,
1535: x_msg_count OUT NOCOPY NUMBER,
1536: x_msg_data OUT NOCOPY VARCHAR2,
1537: p_source_object_id IN NUMBER,
1538: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
1539: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
1540: x_new_object_id OUT NOCOPY NUMBER,
1541: p_custom_setup_id IN NUMBER)
1542: IS

Line 1539: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

1535: x_msg_count OUT NOCOPY NUMBER,
1536: x_msg_data OUT NOCOPY VARCHAR2,
1537: p_source_object_id IN NUMBER,
1538: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
1539: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
1540: x_new_object_id OUT NOCOPY NUMBER,
1541: p_custom_setup_id IN NUMBER)
1542: IS
1543:

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

1739:
1740: l_offer_rec.custom_setup_id := p_custom_setup_id;
1741:
1742: -- getting values from UI
1743: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1744: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1745: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1746: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1747: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);

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

1740: l_offer_rec.custom_setup_id := p_custom_setup_id;
1741:
1742: -- getting values from UI
1743: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1744: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1745: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1746: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1747: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1748: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);

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

1741:
1742: -- getting values from UI
1743: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1744: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1745: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1746: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1747: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1748: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1749: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);

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

1742: -- getting values from UI
1743: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1744: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1745: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1746: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1747: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1748: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1749: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);
1750:

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

1743: AMS_CpyUtility_PVT.get_column_value ('newObjName', p_copy_columns_table, l_modifier_list_rec.description);
1744: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1745: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1746: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1747: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1748: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1749: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);
1750:
1751: -- bug fix 2779988: validate start date and end date

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

1744: AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_offer_rec.offer_code);
1745: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1746: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1747: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1748: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1749: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);
1750:
1751: -- bug fix 2779988: validate start date and end date
1752: IF l_modifier_list_rec.start_date_active IS NOT NULL

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

1745: --AMS_CpyUtility_PVT.get_column_value ('offerCode', p_copy_columns_table, l_modifier_list_rec.name);
1746: AMS_CpyUtility_PVT.get_column_value ('startDateActive', p_copy_columns_table, l_modifier_list_rec.start_date_active);
1747: AMS_CpyUtility_PVT.get_column_value ('endDateActive', p_copy_columns_table, l_modifier_list_rec.end_date_active);
1748: AMS_CpyUtility_PVT.get_column_value ('ownerId', p_copy_columns_table, l_offer_rec.owner_id);
1749: AMS_CpyUtility_PVT.get_column_value ('description', p_copy_columns_table, l_modifier_list_rec.comments);
1750:
1751: -- bug fix 2779988: validate start date and end date
1752: IF l_modifier_list_rec.start_date_active IS NOT NULL
1753: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE THEN

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

2582: l_offer_rec.qp_list_header_id := l_listHeaderId;
2583: END;
2584: END IF;
2585:
2586: IF AMS_CpyUtility_PVT.is_copy_attribute ('ATCH', p_attributes_table) = FND_API.G_TRUE THEN
2587: l_errnum := 0;
2588: l_errcode := NULL;
2589: l_errmsg := NULL;
2590: ams_copyelements_pvt.copy_act_attachments( p_src_act_type => 'OZF_OFFR',

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

2594: p_errcode => l_errcode,
2595: p_errmsg => l_errmsg);
2596: END IF;
2597:
2598: IF AMS_CpyUtility_PVT.is_copy_attribute ('CPNT', p_attributes_table) = FND_API.G_TRUE THEN
2599: FOR l_contact_point IN c_contact_point LOOP
2600: l_contact_point_rec.contact_point_id := Fnd_Api.g_miss_num;
2601: l_contact_point_rec.last_update_date := SYSDATE;
2602: l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;

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

2646: END IF;
2647: END LOOP;
2648: END IF;
2649: /* ELIG is copied by QP API
2650: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_TRUE THEN
2651: FOR l_market_elig_rec IN c_market_elig LOOP
2652: l_index2 := l_index2 + 1;
2653: l_qualifier_tbl(l_index2).qualifier_context := l_market_elig_rec.qualifier_context;
2654: l_qualifier_tbl(l_index2).qualifier_attribute := l_market_elig_rec.qualifier_attribute;

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

2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;
2682: END IF;
2683: */
2684: IF AMS_CpyUtility_PVT.is_copy_attribute ('ELIG', p_attributes_table) = FND_API.G_FALSE THEN
2685: IF l_offer_rec.offer_type IN ('ACCRUAL', 'OFF_INVOICE', 'TERMS', 'ORDER', 'OID') THEN
2686: DELETE FROM qp_qualifiers
2687: WHERE list_header_id = l_offer_rec.qp_list_header_id
2688: AND list_line_id = -1;

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

2693: ,p_new_offer_id => l_offer_rec.offer_id);
2694: END IF;
2695: END IF;
2696:
2697: IF AMS_CpyUtility_PVT.is_copy_attribute ('CONTENT', p_attributes_table) = FND_API.G_TRUE THEN
2698: l_errnum := 0;
2699: l_errcode := NULL;
2700: l_errmsg := NULL;
2701: ams_copyelements_pvt.copy_act_content(p_src_act_type => 'OZF_OFFR',

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

2705: p_errcode => l_errcode,
2706: p_errmsg => l_errmsg);
2707: END IF;
2708:
2709: IF AMS_CpyUtility_PVT.is_copy_attribute ('TEAM', p_attributes_table) = FND_API.G_TRUE THEN
2710: l_errnum := 0;
2711: l_errcode := NULL;
2712: l_errmsg := NULL;
2713: ams_copyelements_pvt.copy_act_access(p_src_act_type => 'OFFR',

Line 2775: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,

2771: x_return_status OUT NOCOPY VARCHAR2,
2772: x_msg_count OUT NOCOPY NUMBER,
2773: x_msg_data OUT NOCOPY VARCHAR2,
2774: p_source_object_id IN NUMBER,
2775: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
2776: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
2777: x_new_object_id OUT NOCOPY NUMBER,
2778: x_custom_setup_id OUT NOCOPY NUMBER)
2779: IS

Line 2776: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,

2772: x_msg_count OUT NOCOPY NUMBER,
2773: x_msg_data OUT NOCOPY VARCHAR2,
2774: p_source_object_id IN NUMBER,
2775: p_attributes_table IN AMS_CpyUtility_PVT.copy_attributes_table_type,
2776: p_copy_columns_table IN AMS_CpyUtility_PVT.copy_columns_table_type,
2777: x_new_object_id OUT NOCOPY NUMBER,
2778: x_custom_setup_id OUT NOCOPY NUMBER)
2779: IS
2780: CURSOR c_budget_offer_yn IS