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.AST_UWQ_WRAPPER_PKG dependencies on AS_API_RECORDS_PKG

Line 50: v_profile_tbl AS_UTILITY_PUB.profile_tbl_type := as_api_records_pkg.get_p_profile_tbl;

46: v_validation_level_full NUMBER := 100;
47: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
48: v_true VARCHAR2(5) := 'T';
49:
50: v_profile_tbl AS_UTILITY_PUB.profile_tbl_type := as_api_records_pkg.get_p_profile_tbl;
51: v_contact_tbl AS_OPPORTUNITY_PUB.contact_tbl_Type := as_api_records_pkg.get_p_contact_tbl;
52: v_contact_out_tbl AS_OPPORTUNITY_PUB.contact_out_tbl_Type := as_api_records_pkg.get_p_contact_out_tbl;
53: v_header_rec AS_OPPORTUNITY_PUB.header_rec_Type := as_api_records_pkg.get_p_header_rec;
54: BEGIN

Line 51: v_contact_tbl AS_OPPORTUNITY_PUB.contact_tbl_Type := as_api_records_pkg.get_p_contact_tbl;

47: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
48: v_true VARCHAR2(5) := 'T';
49:
50: v_profile_tbl AS_UTILITY_PUB.profile_tbl_type := as_api_records_pkg.get_p_profile_tbl;
51: v_contact_tbl AS_OPPORTUNITY_PUB.contact_tbl_Type := as_api_records_pkg.get_p_contact_tbl;
52: v_contact_out_tbl AS_OPPORTUNITY_PUB.contact_out_tbl_Type := as_api_records_pkg.get_p_contact_out_tbl;
53: v_header_rec AS_OPPORTUNITY_PUB.header_rec_Type := as_api_records_pkg.get_p_header_rec;
54: BEGIN
55: v_header_rec.lead_id := v_lead_id;

Line 52: v_contact_out_tbl AS_OPPORTUNITY_PUB.contact_out_tbl_Type := as_api_records_pkg.get_p_contact_out_tbl;

48: v_true VARCHAR2(5) := 'T';
49:
50: v_profile_tbl AS_UTILITY_PUB.profile_tbl_type := as_api_records_pkg.get_p_profile_tbl;
51: v_contact_tbl AS_OPPORTUNITY_PUB.contact_tbl_Type := as_api_records_pkg.get_p_contact_tbl;
52: v_contact_out_tbl AS_OPPORTUNITY_PUB.contact_out_tbl_Type := as_api_records_pkg.get_p_contact_out_tbl;
53: v_header_rec AS_OPPORTUNITY_PUB.header_rec_Type := as_api_records_pkg.get_p_header_rec;
54: BEGIN
55: v_header_rec.lead_id := v_lead_id;
56: v_header_rec.last_update_date := sysdate;

Line 53: v_header_rec AS_OPPORTUNITY_PUB.header_rec_Type := as_api_records_pkg.get_p_header_rec;

49:
50: v_profile_tbl AS_UTILITY_PUB.profile_tbl_type := as_api_records_pkg.get_p_profile_tbl;
51: v_contact_tbl AS_OPPORTUNITY_PUB.contact_tbl_Type := as_api_records_pkg.get_p_contact_tbl;
52: v_contact_out_tbl AS_OPPORTUNITY_PUB.contact_out_tbl_Type := as_api_records_pkg.get_p_contact_out_tbl;
53: v_header_rec AS_OPPORTUNITY_PUB.header_rec_Type := as_api_records_pkg.get_p_header_rec;
54: BEGIN
55: v_header_rec.lead_id := v_lead_id;
56: v_header_rec.last_update_date := sysdate;
57:

Line 860: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := AS_API_RECORDS_PKG.get_p_header_rec;

856: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_OPP');
857: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
858: l_init_msg_list VARCHAR2(5) := 'T';
859: l_commit VARCHAR2(5) := 'T';
860: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := AS_API_RECORDS_PKG.get_p_header_rec;
861: v_profile_tbl AS_UTILITY_PUB.PROFILE_TBL_TYPE := AS_API_RECORDS_PKG.get_p_profile_tbl;
862: l_vehicle_response_code VARCHAR2(200) := nvl(p_vehicle_response_code, FND_PROFILE.value('AS_OPP_RESPONSE_CODE'));
863:
864: -- Added by Sumita on 10.14.2004 for bug # 3812865

Line 861: v_profile_tbl AS_UTILITY_PUB.PROFILE_TBL_TYPE := AS_API_RECORDS_PKG.get_p_profile_tbl;

857: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
858: l_init_msg_list VARCHAR2(5) := 'T';
859: l_commit VARCHAR2(5) := 'T';
860: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := AS_API_RECORDS_PKG.get_p_header_rec;
861: v_profile_tbl AS_UTILITY_PUB.PROFILE_TBL_TYPE := AS_API_RECORDS_PKG.get_p_profile_tbl;
862: l_vehicle_response_code VARCHAR2(200) := nvl(p_vehicle_response_code, FND_PROFILE.value('AS_OPP_RESPONSE_CODE'));
863:
864: -- Added by Sumita on 10.14.2004 for bug # 3812865
865: l_source_promotion_id NUMBER;

Line 1079: l_salesteam_rec as_access_pub.sales_team_rec_type:=as_api_records_pkg.get_p_sales_team_rec;

1075: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;
1076: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1077: l_sales_lead_contact_out_tbl AS_SALES_LEADS_PUB.sales_lead_cnt_out_tbl_type;
1078: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1079: l_salesteam_rec as_access_pub.sales_team_rec_type:=as_api_records_pkg.get_p_sales_team_rec;
1080:
1081: -- Added by Sumita on 10.14.2004 for bug # 3812865
1082: l_action_key varchar2(100) := p_action_key;
1083: -- End Mod.

Line 1410: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type := AS_API_RECORDS_PKG.get_p_sales_lead_rec;

1406: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');
1407: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
1408: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1409: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1410: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type := AS_API_RECORDS_PKG.get_p_sales_lead_rec;
1411: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1412: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1413:
1414: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 1745: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_rec_type := AS_API_RECORDS_PKG.Get_P_Sales_Lead_Rec;

1741: l_commit VARCHAR2(10) := 'F';
1742: l_return_status VARCHAR2(10);
1743: l_msg_data VARCHAR2(2000);
1744: l_Sales_Lead_Profile_Tbl AS_UTILITY_PUB.Profile_Tbl_Type;
1745: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_rec_type := AS_API_RECORDS_PKG.Get_P_Sales_Lead_Rec;
1746: l_header_tbl AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Header_Tbl;
1747: l_purchase_tbl AS_OPPORTUNITY_PUB.LINE_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Line_Tbl;
1748:
1749: l_validation_level CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);

Line 1746: l_header_tbl AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Header_Tbl;

1742: l_return_status VARCHAR2(10);
1743: l_msg_data VARCHAR2(2000);
1744: l_Sales_Lead_Profile_Tbl AS_UTILITY_PUB.Profile_Tbl_Type;
1745: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_rec_type := AS_API_RECORDS_PKG.Get_P_Sales_Lead_Rec;
1746: l_header_tbl AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Header_Tbl;
1747: l_purchase_tbl AS_OPPORTUNITY_PUB.LINE_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Line_Tbl;
1748:
1749: l_validation_level CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1750: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 1747: l_purchase_tbl AS_OPPORTUNITY_PUB.LINE_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Line_Tbl;

1743: l_msg_data VARCHAR2(2000);
1744: l_Sales_Lead_Profile_Tbl AS_UTILITY_PUB.Profile_Tbl_Type;
1745: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_rec_type := AS_API_RECORDS_PKG.Get_P_Sales_Lead_Rec;
1746: l_header_tbl AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Header_Tbl;
1747: l_purchase_tbl AS_OPPORTUNITY_PUB.LINE_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Line_Tbl;
1748:
1749: l_validation_level CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1750: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1751:

Line 1856: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := AS_API_RECORDS_PKG.get_p_header_rec;

1852: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_OPP');
1853: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1854: l_init_msg_list VARCHAR2(5) := 'T';
1855: l_commit VARCHAR2(5) := 'T';
1856: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := AS_API_RECORDS_PKG.get_p_header_rec;
1857: v_profile_tbl AS_UTILITY_PUB.PROFILE_TBL_TYPE := AS_API_RECORDS_PKG.get_p_profile_tbl;
1858:
1859: l_count NUMBER;
1860: l_index NUMBER;

Line 1857: v_profile_tbl AS_UTILITY_PUB.PROFILE_TBL_TYPE := AS_API_RECORDS_PKG.get_p_profile_tbl;

1853: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1854: l_init_msg_list VARCHAR2(5) := 'T';
1855: l_commit VARCHAR2(5) := 'T';
1856: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := AS_API_RECORDS_PKG.get_p_header_rec;
1857: v_profile_tbl AS_UTILITY_PUB.PROFILE_TBL_TYPE := AS_API_RECORDS_PKG.get_p_profile_tbl;
1858:
1859: l_count NUMBER;
1860: l_index NUMBER;
1861: my_message VARCHAR2(1000);