107: x_AMOUNT_CANCELLED OUT NOCOPY NUMBER,
108: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
109: IS
110: l_api_name CONSTANT VARCHAR2(100) := 'Get_Funding_Info';
111: l_distribution_type PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE ;
112: l_accrue_on_receipt_flag PO_DISTRIBUTIONS_ALL.accrue_on_receipt_flag%TYPE ;
113: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE ;
114: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE ;
115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%TYPE ;
108: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
109: IS
110: l_api_name CONSTANT VARCHAR2(100) := 'Get_Funding_Info';
111: l_distribution_type PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE ;
112: l_accrue_on_receipt_flag PO_DISTRIBUTIONS_ALL.accrue_on_receipt_flag%TYPE ;
113: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE ;
114: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE ;
115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%TYPE ;
116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%TYPE ;
109: IS
110: l_api_name CONSTANT VARCHAR2(100) := 'Get_Funding_Info';
111: l_distribution_type PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE ;
112: l_accrue_on_receipt_flag PO_DISTRIBUTIONS_ALL.accrue_on_receipt_flag%TYPE ;
113: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE ;
114: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE ;
115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%TYPE ;
116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%TYPE ;
117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%TYPE ;
110: l_api_name CONSTANT VARCHAR2(100) := 'Get_Funding_Info';
111: l_distribution_type PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE ;
112: l_accrue_on_receipt_flag PO_DISTRIBUTIONS_ALL.accrue_on_receipt_flag%TYPE ;
113: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE ;
114: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE ;
115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%TYPE ;
116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%TYPE ;
117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%TYPE ;
118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%TYPE ;
111: l_distribution_type PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE ;
112: l_accrue_on_receipt_flag PO_DISTRIBUTIONS_ALL.accrue_on_receipt_flag%TYPE ;
113: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE ;
114: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE ;
115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%TYPE ;
116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%TYPE ;
117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%TYPE ;
118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%TYPE ;
119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
112: l_accrue_on_receipt_flag PO_DISTRIBUTIONS_ALL.accrue_on_receipt_flag%TYPE ;
113: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE ;
114: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE ;
115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%TYPE ;
116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%TYPE ;
117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%TYPE ;
118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%TYPE ;
119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
113: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%TYPE ;
114: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE ;
115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%TYPE ;
116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%TYPE ;
117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%TYPE ;
118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%TYPE ;
119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
121: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
114: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%TYPE ;
115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%TYPE ;
116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%TYPE ;
117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%TYPE ;
118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%TYPE ;
119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
121: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
122: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%TYPE ;
116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%TYPE ;
117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%TYPE ;
118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%TYPE ;
119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
121: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
122: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
123: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%TYPE ;
117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%TYPE ;
118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%TYPE ;
119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
121: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
122: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
123: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
124: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE ;
117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%TYPE ;
118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%TYPE ;
119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
121: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
122: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
123: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
124: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE ;
125: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%TYPE ;
119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
121: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
122: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
123: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
124: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE ;
125: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
126: l_quantity_received PO_LINE_LOCATIONS.quantity_received%TYPE;
119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%TYPE ;
120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
121: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
122: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
123: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
124: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE ;
125: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
126: l_quantity_received PO_LINE_LOCATIONS.quantity_received%TYPE;
127: l_amount_received PO_LINE_LOCATIONS.amount_received%TYPE;
120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%TYPE ;
121: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%TYPE ;
122: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%TYPE ;
123: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
124: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE ;
125: l_matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE;
126: l_quantity_received PO_LINE_LOCATIONS.quantity_received%TYPE;
127: l_amount_received PO_LINE_LOCATIONS.amount_received%TYPE;
128: l_hold_name VARCHAR2(30);