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_UTILITY_PUB

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 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 1071: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;

1067: -- Added by Sumita on 10.14.2004 for bug # 3812865
1068: l_source_promotion_id NUMBER;
1069: -- End Mod.
1070:
1071: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1072: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1073: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
1074: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1075: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;

Line 1408: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;

1404: l_init_msg_list VARCHAR2(5) := 'T';
1405: l_commit VARCHAR2(5) := 'T';
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;

Line 1552: l_Sales_Lead_Profile_Tbl AS_UTILITY_PUB.Profile_Tbl_Type;

1548: l_commit VARCHAR2(5) := 'T';
1549: l_validation_level NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1550: l_opp_status VARCHAR2(30) := nvl(FND_PROFILE.value('AS_OPP_STATUS'), null);
1551: l_query_string varchar2(200);
1552: l_Sales_Lead_Profile_Tbl AS_UTILITY_PUB.Profile_Tbl_Type;
1553: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1554:
1555: l_count NUMBER;
1556: l_index NUMBER;

Line 1744: l_Sales_Lead_Profile_Tbl AS_UTILITY_PUB.Profile_Tbl_Type;

1740: l_init_msg_list VARCHAR2(5) := 'T';
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:

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);