DBA Data[Home] [Help]

APPS.AST_UWQ_WRAPPER_PKG dependencies on AS_ACCESS_PUB

Line 1078: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_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;
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;

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 1319: AS_ACCESS_PUB.Update_SalesTeam

1315: l_salesteam_rec.salesforce_id := p_assign_to_salesforce_id;
1316: l_salesteam_rec.person_id := l_assign_to_person_id;
1317: l_salesteam_rec.address_id := p_address_id;
1318:
1319: AS_ACCESS_PUB.Update_SalesTeam
1320: (
1321: p_api_version_number => l_api_version,
1322: p_init_msg_list => l_init_msg_list,
1323: p_commit => l_commit,

Line 1414: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_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;
1415:
1416: l_count NUMBER;
1417: l_index NUMBER;
1418: my_message VARCHAR2(1000);

Line 1553: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

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;
1557: my_message VARCHAR2(1000);

Line 1648: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

1644: l_init_msg_list VARCHAR2(5) := 'T';
1645: l_commit VARCHAR2(5) := 'T';
1646: l_message_name VARCHAR2(100);
1647: l_validation_level CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1648: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1649:
1650: l_count NUMBER;
1651: l_index NUMBER;
1652: my_message VARCHAR2(1000);

Line 1750: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

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:
1752: CURSOR c_lead_info (p_sales_lead_id NUMBER) is
1753: SELECT customer_id, source_promotion_id
1754: FROM as_sales_leads