DBA Data[Home] [Help]

APPS.OKC_OPPORTUNITY_PVT dependencies on AS_OPPORTUNITY_PUB

Line 209: l_header_rec as_opportunity_pub.header_rec_type;

205: c6_rec c6%ROWTYPE;
206:
207: c7_rec c7%ROWTYPE;
208:
209: l_header_rec as_opportunity_pub.header_rec_type;
210: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
211: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
212: l_return_status Varchar2(1);
213: l_msg_count Number;

Line 408: okc_debug.log('3500: Before as_opportunity_pub.create_opp_header');

404: okc_debug.log('l_header_rec.address_id: ' || TO_CHAR(l_header_rec.address_id));
405: END IF;
406:
407: IF (l_debug = 'Y') THEN
408: okc_debug.log('3500: Before as_opportunity_pub.create_opp_header');
409: END IF;
410: -- Finally call the opp header api
411: AS_OPPORTUNITY_PUB.Create_Opp_Header(
412: p_api_version_number => 2.0, --p_api_version,---2.0,

Line 411: AS_OPPORTUNITY_PUB.Create_Opp_Header(

407: IF (l_debug = 'Y') THEN
408: okc_debug.log('3500: Before as_opportunity_pub.create_opp_header');
409: END IF;
410: -- Finally call the opp header api
411: AS_OPPORTUNITY_PUB.Create_Opp_Header(
412: p_api_version_number => 2.0, --p_api_version,---2.0,
413: p_init_msg_list => p_init_msg_list, --fnd_api.g_false,
414: p_commit => fnd_api.g_false,
415: p_validation_level => fnd_api.g_valid_level_full,

Line 432: okc_debug.log('3510: After as_opportunity_pub.create_opp_header');

428: x_lead_id => l_lead_id);
429: --
430: --Note: final commit is done in OKC_OPPORUNTITY_PUB.create_opportunity!
431: IF (l_debug = 'Y') THEN
432: okc_debug.log('3510: After as_opportunity_pub.create_opp_header');
433: END IF;
434: --TEMP okc_util.print_trace(9, 'x_lead_id returned: ' || l_lead_id);
435: IF (l_debug = 'Y') THEN
436: okc_debug.log('x_lead_id returned: ' || TO_CHAR(l_lead_id));

Line 582: l_header_rec as_opportunity_pub.header_rec_type;

578: l_number_of_items okc_k_items.number_of_items%Type;
579: l_rel_id_tbl id_tbl;
580: l_rel_lead_line_id_tbl Lead_Line_Id_tbl;
581: --
582: l_header_rec as_opportunity_pub.header_rec_type;
583: l_line_tbl as_opportunity_pub.line_tbl_type;
584: l_line_out_tbl as_opportunity_pub.line_out_tbl_type;
585: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
586: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;

Line 583: l_line_tbl as_opportunity_pub.line_tbl_type;

579: l_rel_id_tbl id_tbl;
580: l_rel_lead_line_id_tbl Lead_Line_Id_tbl;
581: --
582: l_header_rec as_opportunity_pub.header_rec_type;
583: l_line_tbl as_opportunity_pub.line_tbl_type;
584: l_line_out_tbl as_opportunity_pub.line_out_tbl_type;
585: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
586: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
587: --

Line 584: l_line_out_tbl as_opportunity_pub.line_out_tbl_type;

580: l_rel_lead_line_id_tbl Lead_Line_Id_tbl;
581: --
582: l_header_rec as_opportunity_pub.header_rec_type;
583: l_line_tbl as_opportunity_pub.line_tbl_type;
584: l_line_out_tbl as_opportunity_pub.line_out_tbl_type;
585: l_in_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
586: l_out_crjv_tbl okc_k_rel_objs_pub.crjv_tbl_type;
587: --
588: l_org_id Number;

Line 789: AS_OPPORTUNITY_PUB.Update_Opp_Header

785: IF (l_debug = 'Y') THEN
786: okc_debug.log('5005: Updating total header amount to '||l_updt_hdr_tot_amt, 2);
787: END IF;
788: -- update header now
789: AS_OPPORTUNITY_PUB.Update_Opp_Header
790: ( p_api_version_number => 2.0,
791: p_init_msg_list => p_init_msg_list,
792: p_commit => fnd_api.g_false,
793: p_validation_level => fnd_api.g_valid_level_full,

Line 935: okc_debug.log('5043: Before calling as_opportunity_pub.create_opp_lines');

931: END IF;
932: -- Call the opp lines api
933: IF l_line_tbl.count>0 THEN
934: IF (l_debug = 'Y') THEN
935: okc_debug.log('5043: Before calling as_opportunity_pub.create_opp_lines');
936: END IF;
937: AS_OPPORTUNITY_PUB.Create_Opp_Lines(
938: p_api_version_number => 2.0, --p_api_version,--2.0,
939: p_init_msg_list => p_init_msg_list, --fnd_api.g_false,

Line 937: AS_OPPORTUNITY_PUB.Create_Opp_Lines(

933: IF l_line_tbl.count>0 THEN
934: IF (l_debug = 'Y') THEN
935: okc_debug.log('5043: Before calling as_opportunity_pub.create_opp_lines');
936: END IF;
937: AS_OPPORTUNITY_PUB.Create_Opp_Lines(
938: p_api_version_number => 2.0, --p_api_version,--2.0,
939: p_init_msg_list => p_init_msg_list, --fnd_api.g_false,
940: p_commit => fnd_api.g_false,
941: p_validation_level => fnd_api.g_valid_level_full,

Line 958: okc_debug.log('5048: After calling as_opportunity_pub.create_opp_lines');

954: x_msg_count => l_msg_count,
955: x_msg_data => l_msg_data);
956: --
957: IF (l_debug = 'Y') THEN
958: okc_debug.log('5048: After calling as_opportunity_pub.create_opp_lines');
959: END IF;
960: If l_return_status <> okc_api.g_ret_sts_success Then
961: IF (l_debug = 'Y') THEN
962: okc_debug.log('5049: Opp Lines Return Status - ' || l_return_status);

Line 975: okc_debug.log('5063: Before calling as_opportunity_pub.Delete_Opp_Header');

971: END IF;
972: IF g_opp_h_created THEN
973: IF (l_debug = 'Y') THEN
974: okc_debug.log('5061: We should remove Opportunity Header because we''ve created it by mistake');
975: okc_debug.log('5063: Before calling as_opportunity_pub.Delete_Opp_Header');
976: END IF;
977: AS_OPPORTUNITY_PUB.Delete_Opp_Header(
978: p_api_version_number => 2.0, --p_api_version,--2.0,
979: p_init_msg_list => p_init_msg_list, --fnd_api.g_false,

Line 977: AS_OPPORTUNITY_PUB.Delete_Opp_Header(

973: IF (l_debug = 'Y') THEN
974: okc_debug.log('5061: We should remove Opportunity Header because we''ve created it by mistake');
975: okc_debug.log('5063: Before calling as_opportunity_pub.Delete_Opp_Header');
976: END IF;
977: AS_OPPORTUNITY_PUB.Delete_Opp_Header(
978: p_api_version_number => 2.0, --p_api_version,--2.0,
979: p_init_msg_list => p_init_msg_list, --fnd_api.g_false,
980: p_commit => fnd_api.g_false,
981: p_validation_level => fnd_api.g_valid_level_full,

Line 996: okc_debug.log('5068: After calling as_opportunity_pub.Delete_Opp_Header');

992: x_lead_id => l_lead_id
993: );
994: --
995: IF (l_debug = 'Y') THEN
996: okc_debug.log('5068: After calling as_opportunity_pub.Delete_Opp_Header');
997: END IF;
998: If l_return_status <> okc_api.g_ret_sts_success Then
999: IF (l_debug = 'Y') THEN
1000: okc_debug.log('5069: Opp Lines Return Status - ' || l_return_status);