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 2963: x_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;

2959: x_msg_count out NOCOPY number,
2960: x_msg_data out NOCOPY varchar2) is
2961:
2962: lStmtNumber Number;
2963: x_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2964: x_config_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2965: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2966: l_doc_header_id Number;
2967: l_doc_type_code Varchar2(20);

Line 2964: x_config_vendors PO_AUTOSOURCE_SV.vendor_record_details;

2960: x_msg_data out NOCOPY varchar2) is
2961:
2962: lStmtNumber Number;
2963: x_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2964: x_config_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2965: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2966: l_doc_header_id Number;
2967: l_doc_type_code Varchar2(20);
2968: l_doc_line_num Number;

Line 2965: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;

2961:
2962: lStmtNumber Number;
2963: x_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2964: x_config_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2965: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
2966: l_doc_header_id Number;
2967: l_doc_type_code Varchar2(20);
2968: l_doc_line_num Number;
2969: l_doc_line_id Number;

Line 3020: PO_AUTOSOURCE_SV.get_all_item_asl(

3016: -- Asl id for the model.
3017: lStmtNumber := 20;
3018:
3019: lStmtNumber := 30;
3020: PO_AUTOSOURCE_SV.get_all_item_asl(
3021: x_item_id => l_model_item_id,
3022: X_using_organization_id => -1,
3023: x_vendor_details => l_model_vendors,
3024: x_return_status => x_return_status,

Line 3058: PO_AUTOSOURCE_SV.get_all_item_asl(

3054: -- Get all the ASL's Defined for Config item (You may have some
3055: -- in the case of matching)
3056: lstmtNumber := 50;
3057:
3058: PO_AUTOSOURCE_SV.get_all_item_asl(
3059: x_item_id => p_config_item_id,
3060: x_using_organization_id => -1,
3061: x_vendor_details => x_config_vendors,
3062: x_return_status => x_return_status,

Line 3159: PO_AUTOSOURCE_SV.blanket_document_sourcing(

3155: l_doc_header_id := null;
3156:
3157: lStmtNumber := 90;
3158:
3159: PO_AUTOSOURCE_SV.blanket_document_sourcing(
3160: x_item_id => p_config_item_id,
3161: x_vendor_id => x_config_vendors(x_index).vendor_id,
3162: x_vendor_site_id => x_config_vendors(x_index).vendor_site_id,
3163: x_asl_id => x_config_vendors(x_index).asl_id,

Line 3231: PO_AUTOSOURCE_SV.blanket_document_sourcing(

3227: else
3228: l_doc_line_id := null;
3229: l_doc_header_id := null;
3230: lStmtNumber := 120;
3231: PO_AUTOSOURCE_SV.blanket_document_sourcing(
3232: x_item_id => l_model_item_id,
3233: x_vendor_id => x_model_vendors(i).vendor_id,
3234: x_vendor_site_id => x_model_vendors(i).vendor_site_id,
3235: x_asl_id => x_model_vendors(i).asl_id,

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

3255:
3256: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3257: IF PG_DEBUG <> 0 THEN
3258: oe_debug_pub.add(lpad(' ',g_pg_level)
3259: ||'success status false for po_autosource_sv.blanket_document_sourcing...',1);
3260:
3261: END IF;
3262:
3263: return ;

Line 3445: p_vendor_list IN PO_AUTOSOURCE_SV.vendor_record_details,

3441:
3442: Procedure config_asl_exists(
3443: p_vendor_id IN Number,
3444: p_vendor_site_id IN Number,
3445: p_vendor_list IN PO_AUTOSOURCE_SV.vendor_record_details,
3446: x_asl_found OUT NOCOPY Boolean,
3447: x_index OUT NOCOPY Number) is
3448:
3449: i Number;

Line 4009: p_vendor_details in PO_AUTOSOURCE_SV.vendor_record_details,

4005:
4006:
4007:
4008: procedure Reduce_vendor_by_ou(
4009: p_vendor_details in PO_AUTOSOURCE_SV.vendor_record_details,
4010: p_config_item_id in Number,
4011: p_line_id in Number,
4012: p_mode in Varchar2,
4013: x_vendor_details out NOCOPY PO_AUTOSOURCE_SV.vendor_record_details) is

Line 4013: x_vendor_details out NOCOPY PO_AUTOSOURCE_SV.vendor_record_details) is

4009: p_vendor_details in PO_AUTOSOURCE_SV.vendor_record_details,
4010: p_config_item_id in Number,
4011: p_line_id in Number,
4012: p_mode in Varchar2,
4013: x_vendor_details out NOCOPY PO_AUTOSOURCE_SV.vendor_record_details) is
4014:
4015: j Number := 0;
4016: l_oper_unit Number;
4017: i Number;