DBA Data[Home] [Help]

APPS.AP_CLM_PVT_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 111: l_distribution_type PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE ;

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 ;

Line 112: l_accrue_on_receipt_flag PO_DISTRIBUTIONS_ALL.accrue_on_receipt_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 ;

Line 113: l_code_combination_id PO_DISTRIBUTIONS_ALL.code_combination_id%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 ;

Line 114: l_budget_account_id PO_DISTRIBUTIONS_ALL.budget_account_id%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 ;

Line 115: l_partial_funded_flag PO_DISTRIBUTIONS_ALL.partial_funded_flag%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 ;

Line 116: l_funded_value PO_DISTRIBUTIONS_ALL.funded_value%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 ;

Line 117: l_quantity_funded PO_DISTRIBUTIONS_ALL.quantity_funded%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 ;

Line 118: l_amount_funded PO_DISTRIBUTIONS_ALL.amount_funded%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 ;

Line 119: l_quantity_delivered PO_DISTRIBUTIONS_ALL.quantity_delivered%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 ;

Line 120: l_amount_delivered PO_DISTRIBUTIONS_ALL.amount_delivered%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 ;

Line 121: l_quantity_billed PO_DISTRIBUTIONS_ALL.quantity_billed%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;

Line 122: l_amount_billed PO_DISTRIBUTIONS_ALL.amount_billed%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;

Line 123: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%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;

Line 124: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%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);