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.AS_INTEREST_PUB dependencies on AS_INTEREST_PVT

Line 13: -- the AS_INTEREST_PVT.Create_Interest routine

9: -- Provide public interest record and table type to be used by APIs that
10: -- import interests/classifications into OSM
11: --
12: -- Convert the public interest records into private interest records for use by
13: -- the AS_INTEREST_PVT.Create_Interest routine
14: --
15: --
16: -- NOTES
17: -- The procedures in this package are not supported for use by anyone outside

Line 74: l_pvt_classification_tbl as_interest_pvt.interest_tbl_type;

70:
71: l_api_name constant varchar2(30) := 'Create_Interest';
72: l_api_version_number constant number := 2.0;
73: l_interest_tbl interest_tbl_type;
74: l_pvt_classification_tbl as_interest_pvt.interest_tbl_type;
75: l_pvt_interest_out_tbl as_interest_pvt.interest_out_tbl_type;
76: l_return_status varchar2(1);
77: l_mode constant varchar2(30) := 'ON-INSERT';
78: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.create_interest';

Line 75: l_pvt_interest_out_tbl as_interest_pvt.interest_out_tbl_type;

71: l_api_name constant varchar2(30) := 'Create_Interest';
72: l_api_version_number constant number := 2.0;
73: l_interest_tbl interest_tbl_type;
74: l_pvt_classification_tbl as_interest_pvt.interest_tbl_type;
75: l_pvt_interest_out_tbl as_interest_pvt.interest_out_tbl_type;
76: l_return_status varchar2(1);
77: l_mode constant varchar2(30) := 'ON-INSERT';
78: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.create_interest';
79:

Line 118: as_interest_pvt.create_interest ( p_api_version_number => 2.0

114: Convert_Values_To_Ids ( p_interest_tbl => l_interest_tbl,
115: p_pvt_interest_tbl => l_pvt_classification_tbl
116: );
117:
118: as_interest_pvt.create_interest ( p_api_version_number => 2.0
119: ,p_init_msg_list => fnd_api.g_false
120: ,p_commit => fnd_api.g_false
121: ,p_validation_level => p_validation_level
122: ,p_interest_tbl => l_pvt_classification_tbl

Line 278: l_interest_rec as_interest_pvt.interest_rec_type;

274: l_return_status VARCHAR2(1);
275: l_rowid ROWID;
276: l_interest_id NUMBER;
277: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
278: l_interest_rec as_interest_pvt.interest_rec_type;
279: l_interest_tbl as_interest_pub.interest_tbl_type;
280: l_pvt_interest_tbl as_interest_pvt.interest_tbl_type;
281: l_mode constant varchar2(30) := 'ON-UPDATE';
282: l_lead_id NUMBER;

Line 280: l_pvt_interest_tbl as_interest_pvt.interest_tbl_type;

276: l_interest_id NUMBER;
277: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
278: l_interest_rec as_interest_pvt.interest_rec_type;
279: l_interest_tbl as_interest_pub.interest_tbl_type;
280: l_pvt_interest_tbl as_interest_pvt.interest_tbl_type;
281: l_mode constant varchar2(30) := 'ON-UPDATE';
282: l_lead_id NUMBER;
283: l_address_id NUMBER;
284: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.Update_Interest';

Line 370: AS_INTEREST_PVT.Update_Interest ( p_api_version_number => 2.0,

366: l_interest_rec.attribute13 := p_interest_rec.attribute13 ;
367: l_interest_rec.attribute14 := p_interest_rec.attribute14 ;
368: l_interest_rec.attribute15 := p_interest_rec.attribute15 ;
369:
370: AS_INTEREST_PVT.Update_Interest ( p_api_version_number => 2.0,
371: p_init_msg_list => FND_API.G_FALSE,
372: p_commit => FND_API.G_FALSE,
373: p_validation_level => p_validation_level,
374: p_identity_salesforce_id=> p_identity_salesforce_id,

Line 483: p_pvt_interest_tbl OUT NOCOPY AS_INTEREST_PVT.INTEREST_TBL_TYPE)

479: -- it would fail on insert into the database.
480: --
481: --
482: PROCEDURE Convert_Values_To_Ids ( p_interest_tbl IN INTEREST_TBL_TYPE,
483: p_pvt_interest_tbl OUT NOCOPY AS_INTEREST_PVT.INTEREST_TBL_TYPE)
484: IS
485: l_interest_count CONSTANT NUMBER := p_interest_tbl.count;
486:
487: l_any_errors BOOLEAN := FALSE;

Line 493: l_pvt_interest_rec AS_INTEREST_PVT.INTEREST_REC_TYPE;

489:
490: l_val VARCHAR2(30);
491: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
492:
493: l_pvt_interest_rec AS_INTEREST_PVT.INTEREST_REC_TYPE;
494:
495: Cursor C_Get_Int_Status (X_Int_Status VARCHAR2, X_Product_Category_Id NUMBER, X_Product_Cat_Set_Id NUMBER) IS
496: SELECT ais.interest_status_code
497: FROM as_interest_statuses ais, as_lookups lkp

Line 973: l_interest_rec AS_INTEREST_PVT.Interest_Rec_Type;

969: x_msg_data OUT NOCOPY VARCHAR2
970: ) is
971: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Interest';
972: l_api_version_number CONSTANT NUMBER := 2.0;
973: l_interest_rec AS_INTEREST_PVT.Interest_Rec_Type;
974: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
975: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.Delete_Interest';
976: begin
977: SAVEPOINT DELETE_INTEREST_PUB;

Line 1018: as_interest_pvt.Delete_Interest ( p_api_version_number => 2.0,

1014: l_interest_rec.customer_id := p_interest_rec.customer_id;
1015: l_interest_rec.address_id := p_interest_rec.address_id;
1016: l_interest_rec.lead_id := p_interest_rec.lead_id;
1017:
1018: as_interest_pvt.Delete_Interest ( p_api_version_number => 2.0,
1019: p_init_msg_list => FND_API.G_FALSE,
1020: p_commit => FND_API.G_FALSE,
1021: p_validation_level => p_validation_level,
1022: p_identity_salesforce_id=> p_identity_salesforce_id,