DBA Data[Home] [Help]

APPS.CTO_AUTO_PROCURE_PK dependencies on PO_AUTOSOURCE_SV

Line 217: p_vendor_list IN PO_AUTOSOURCE_SV.vendor_record_details,

213:
214: Procedure config_asl_exists(
215: p_vendor_id IN Number,
216: p_vendor_site_id IN Number,
217: p_vendor_list IN PO_AUTOSOURCE_SV.vendor_record_details,
218: x_asl_found OUT NOCOPY Boolean,
219: x_index OUT NOCOPY Number);
220:
221: procedure Reduce_vendor_by_ou(

Line 222: p_vendor_details in PO_AUTOSOURCE_SV.vendor_record_details,

218: x_asl_found OUT NOCOPY Boolean,
219: x_index OUT NOCOPY Number);
220:
221: procedure Reduce_vendor_by_ou(
222: p_vendor_details in PO_AUTOSOURCE_SV.vendor_record_details,
223: p_config_item_id in Number,
224: p_line_id in Number,
225: p_mode in Varchar2,
226: x_vendor_details out NOCOPY PO_AUTOSOURCE_SV.vendor_record_details);

Line 226: x_vendor_details out NOCOPY PO_AUTOSOURCE_SV.vendor_record_details);

222: p_vendor_details in PO_AUTOSOURCE_SV.vendor_record_details,
223: p_config_item_id in Number,
224: p_line_id in Number,
225: p_mode in Varchar2,
226: x_vendor_details out NOCOPY PO_AUTOSOURCE_SV.vendor_record_details);
227:
228:
229:
230: procedure insert_blanket_line(

Line 2578: x_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;

2574: x_msg_count out NOCOPY number,
2575: x_msg_data out NOCOPY varchar2) is
2576:
2577: lStmtNumber Number;
2578: x_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2579: x_config_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2580: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2581: l_doc_header_id Number;
2582: l_doc_type_code Varchar2(20);

Line 2579: x_config_vendors PO_AUTOSOURCE_SV.vendor_record_details;

2575: x_msg_data out NOCOPY varchar2) is
2576:
2577: lStmtNumber Number;
2578: x_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2579: x_config_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2580: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2581: l_doc_header_id Number;
2582: l_doc_type_code Varchar2(20);
2583: l_doc_line_num Number;

Line 2580: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;

2576:
2577: lStmtNumber Number;
2578: x_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2579: x_config_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2580: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2581: l_doc_header_id Number;
2582: l_doc_type_code Varchar2(20);
2583: l_doc_line_num Number;
2584: l_doc_line_id Number;

Line 2635: PO_AUTOSOURCE_SV.get_all_item_asl(

2631: -- Asl id for the model.
2632: lStmtNumber := 20;
2633:
2634: lStmtNumber := 30;
2635: PO_AUTOSOURCE_SV.get_all_item_asl(
2636: x_item_id => l_model_item_id,
2637: X_using_organization_id => -1,
2638: x_vendor_details => l_model_vendors,
2639: x_return_status => x_return_status,

Line 2673: PO_AUTOSOURCE_SV.get_all_item_asl(

2669: -- Get all the ASL's Defined for Config item (You may have some
2670: -- in the case of matching)
2671: lstmtNumber := 50;
2672:
2673: PO_AUTOSOURCE_SV.get_all_item_asl(
2674: x_item_id => p_config_item_id,
2675: x_using_organization_id => -1,
2676: x_vendor_details => x_config_vendors,
2677: x_return_status => x_return_status,

Line 2774: PO_AUTOSOURCE_SV.blanket_document_sourcing(

2770: l_doc_header_id := null;
2771:
2772: lStmtNumber := 90;
2773:
2774: PO_AUTOSOURCE_SV.blanket_document_sourcing(
2775: x_item_id => p_config_item_id,
2776: x_vendor_id => x_config_vendors(x_index).vendor_id,
2777: x_vendor_site_id => x_config_vendors(x_index).vendor_site_id,
2778: x_asl_id => x_config_vendors(x_index).asl_id,

Line 2846: PO_AUTOSOURCE_SV.blanket_document_sourcing(

2842: else
2843: l_doc_line_id := null;
2844: l_doc_header_id := null;
2845: lStmtNumber := 120;
2846: PO_AUTOSOURCE_SV.blanket_document_sourcing(
2847: x_item_id => l_model_item_id,
2848: x_vendor_id => x_model_vendors(i).vendor_id,
2849: x_vendor_site_id => x_model_vendors(i).vendor_site_id,
2850: x_asl_id => x_model_vendors(i).asl_id,

Line 2874: ||'success status false for po_autosource_sv.blanket_document_sourcing...',1);

2870:
2871: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2872: IF PG_DEBUG <> 0 THEN
2873: oe_debug_pub.add(lpad(' ',g_pg_level)
2874: ||'success status false for po_autosource_sv.blanket_document_sourcing...',1);
2875:
2876: END IF;
2877:
2878: return ;

Line 3060: p_vendor_list IN PO_AUTOSOURCE_SV.vendor_record_details,

3056:
3057: Procedure config_asl_exists(
3058: p_vendor_id IN Number,
3059: p_vendor_site_id IN Number,
3060: p_vendor_list IN PO_AUTOSOURCE_SV.vendor_record_details,
3061: x_asl_found OUT NOCOPY Boolean,
3062: x_index OUT NOCOPY Number) is
3063:
3064: i Number;

Line 3599: p_vendor_details in PO_AUTOSOURCE_SV.vendor_record_details,

3595:
3596:
3597:
3598: procedure Reduce_vendor_by_ou(
3599: p_vendor_details in PO_AUTOSOURCE_SV.vendor_record_details,
3600: p_config_item_id in Number,
3601: p_line_id in Number,
3602: p_mode in Varchar2,
3603: x_vendor_details out NOCOPY PO_AUTOSOURCE_SV.vendor_record_details) is

Line 3603: x_vendor_details out NOCOPY PO_AUTOSOURCE_SV.vendor_record_details) is

3599: p_vendor_details in PO_AUTOSOURCE_SV.vendor_record_details,
3600: p_config_item_id in Number,
3601: p_line_id in Number,
3602: p_mode in Varchar2,
3603: x_vendor_details out NOCOPY PO_AUTOSOURCE_SV.vendor_record_details) is
3604:
3605: j Number := 0;
3606: l_oper_unit Number;
3607: i Number;