62: -- PROCEDURE : Sites_Conversion PUBLIC
63: -- PARAMETERS: p_vendor_id Vednor ID
64: -- p_vendor_site_id Specific Site to be Processed
65: -- p_site_conv_from_ncu NCU Sites to be Converted
66: -- p_conv_standard_po_flag Flag to indicate conversion of
67: -- Standard PO
68: -- p_conv_blanket_po_flag Flag to indicate conversion of
69: -- Blanket PO
70: -- p_conv_planned_po_flag Flag to indicate conversion of
63: -- PARAMETERS: p_vendor_id Vednor ID
64: -- p_vendor_site_id Specific Site to be Processed
65: -- p_site_conv_from_ncu NCU Sites to be Converted
66: -- p_conv_standard_po_flag Flag to indicate conversion of
67: -- Standard PO
68: -- p_conv_blanket_po_flag Flag to indicate conversion of
69: -- Blanket PO
70: -- p_conv_planned_po_flag Flag to indicate conversion of
71: -- Planned PO
81: PROCEDURE Sites_Conversion
82: ( p_vendor_id IN NUMBER
83: , p_vendor_site_id IN NUMBER
84: , p_site_conv_from_ncu IN VARCHAR2
85: , p_conv_standard_po_flag IN VARCHAR2 := 'N'
86: , p_conv_blanket_po_flag IN VARCHAR2 := 'N'
87: , p_conv_planned_po_flag IN VARCHAR2 := 'N'
88: , p_conv_contract_po_flag IN VARCHAR2 := 'N'
89: , p_po_conv_from_ncu IN VARCHAR2
98: END Sites_Conversion;
99:
100: --========================================================================
101: -- PROCEDURE : All_Vendor_Conversion PUBLIC
102: -- PARAMETERS: p_standard_po_flag Indicate if Standard PO needs to be converted
103: -- p_blanket_po_flag Indicate if Blanket PO needs to be converted
104: -- p_planned_po_flag Indicate if Planned PO needs to be converted
105: -- p_contract_po_flag Indicate if Contract PO needs to be converted
106: -- p_po_from_ncu NCU POs to be converted
110: -- COMMENT : Main Logic to Process the All Vendor Conversion
111: --
112: --=======================================================================
113: PROCEDURE All_Vendor_Conversion
114: ( p_standard_po_flag IN VARCHAR2 DEFAULT 'N'
115: , p_blanket_po_flag IN VARCHAR2 DEFAULT 'N'
116: , p_planned_po_flag IN VARCHAR2 DEFAULT 'N'
117: , p_contract_po_flag IN VARCHAR2 DEFAULT 'N'
118: , p_po_from_ncu IN VARCHAR2 DEFAULT NULL