APPS.AST_UWQ_WRAPPER_PKG dependencies on AS_OPPORTUNITY_PUB

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 69: AS_OPPORTUNITY_PUB.CREATE_CONTACTS(

65: -- v_contact_tbl(1).created_by := p_created_by;
66: v_contact_tbl(1).enabled_flag := 'Y';
67: v_contact_tbl(1).primary_contact_flag := 'Y';
68:
69: AS_OPPORTUNITY_PUB.CREATE_CONTACTS(
70: p_api_version_number => 2.0,
71: p_init_msg_list => v_true,
72: p_commit => v_true,
73: p_validation_level => v_validation_level_full,

Line 714: header_rec IN OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_type

710:
711: p_close_comment IN VARCHAR2,
712: p_parent_project IN VARCHAR2,
713: p_freeze_flag IN VARCHAR2,
714: header_rec IN OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_type
715: )
716: AS
717: l_num NUMBER := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_NUM');
718: l_char VARCHAR2(1) := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_CHAR');

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 964: AS_OPPORTUNITY_PUB.Create_Opp_Header

960: header_rec
961: );
962:
963:
964: AS_OPPORTUNITY_PUB.Create_Opp_Header
965: (
966: p_api_version_number => l_api_version,
967: p_init_msg_list => l_init_msg_list,
968: p_commit => l_commit,

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 1911: AS_OPPORTUNITY_PUB.Update_Opp_Header

1907: x_return_status=>x_return_status,
1908: x_msg_count=>x_msg_count,
1909: x_msg_data=>x_msg_data,
1910: x_event_key=>x_event_key);
1911: AS_OPPORTUNITY_PUB.Update_Opp_Header
1912: (
1913: p_api_version_number => l_api_version,
1914: p_init_msg_list => l_init_msg_list,
1915: p_commit => l_commit,