DBA Data[Home] [Help]

APPS.AS_LEADS_AUDIT_PKG dependencies on AS_SALES_CREDITS

Line 104: p_new_lead_id IN as_sales_credits.lead_id%type,

100: p_old_uom IN as_lead_lines_all.UOM_CODE%type);
101:
102:
103: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
104: p_new_lead_id IN as_sales_credits.lead_id%type,
105: p_old_lead_id IN as_sales_credits.lead_id%type,
106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,

Line 105: p_old_lead_id IN as_sales_credits.lead_id%type,

101:
102:
103: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
104: p_new_lead_id IN as_sales_credits.lead_id%type,
105: p_old_lead_id IN as_sales_credits.lead_id%type,
106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:

Line 107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,

103: PROCEDURE Sales_Credits_Trigger_Handler(p_trigger_Mode IN VARCHAR2,
104: p_new_lead_id IN as_sales_credits.lead_id%type,
105: p_old_lead_id IN as_sales_credits.lead_id%type,
106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,

Line 108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,

104: p_new_lead_id IN as_sales_credits.lead_id%type,
105: p_old_lead_id IN as_sales_credits.lead_id%type,
106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,

Line 110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,

106:
107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:

Line 111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,

107: p_new_lead_line_id IN as_sales_credits.lead_line_id%type,
108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,

Line 112: p_new_last_update_date IN as_sales_credits.last_update_date%type,

108: p_old_lead_line_id IN as_sales_credits.lead_line_id%type,
109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,

Line 113: p_old_last_update_date IN as_sales_credits.last_update_date%type,

109:
110: p_new_sales_credit_id IN as_sales_credits.sales_credit_id%type,
111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:

Line 115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,

111: p_old_sales_credit_id IN as_sales_credits.sales_credit_id%type,
112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,

Line 116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,

112: p_new_last_update_date IN as_sales_credits.last_update_date%type,
113: p_old_last_update_date IN as_sales_credits.last_update_date%type,
114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:

Line 118: p_new_last_update_login IN as_sales_credits.last_update_login%type,

114:
115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,

Line 119: p_old_last_update_login IN as_sales_credits.last_update_login%type,

115: p_new_last_updated_by IN as_sales_credits.last_updated_by%type,
116: p_old_last_updated_by IN as_sales_credits.last_updated_by%type,
117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:

Line 121: p_new_creation_date IN as_sales_credits.creation_date%type,

117:
118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,

Line 122: p_old_creation_date IN as_sales_credits.creation_date%type,

118: p_new_last_update_login IN as_sales_credits.last_update_login%type,
119: p_old_last_update_login IN as_sales_credits.last_update_login%type,
120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:

Line 124: p_new_created_by IN as_sales_credits.created_by%type,

120:
121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,

Line 125: p_old_created_by IN as_sales_credits.created_by%type,

121: p_new_creation_date IN as_sales_credits.creation_date%type,
122: p_old_creation_date IN as_sales_credits.creation_date%type,
123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,

Line 127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,

123:
124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,

Line 128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,

124: p_new_created_by IN as_sales_credits.created_by%type,
125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,

Line 129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,

125: p_old_created_by IN as_sales_credits.created_by%type,
126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,

Line 130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,

126:
127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,

Line 131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,

127: p_new_salesforce_id IN as_sales_credits.salesforce_id%type,
128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,

Line 132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,

128: p_old_salesforce_id IN as_sales_credits.salesforce_id%type,
129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,

Line 133: p_new_credit_percent IN as_sales_credits.credit_percent%type,

129: p_new_salesgroup_id IN as_sales_credits.salesgroup_id%type,
130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,

Line 134: p_old_credit_percent IN as_sales_credits.credit_percent%type,

130: p_old_salesgroup_id IN as_sales_credits.salesgroup_id%type,
131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,

Line 135: p_new_credit_amount IN as_sales_credits.credit_amount%type,

131: p_new_credit_type_id IN as_sales_credits.credit_type_id%type,
132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,

Line 136: p_old_credit_amount IN as_sales_credits.credit_amount%type,

132: p_old_credit_type_id IN as_sales_credits.credit_type_id%type,
133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,

Line 137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,

133: p_new_credit_percent IN as_sales_credits.credit_percent%type,
134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,

Line 138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,

134: p_old_credit_percent IN as_sales_credits.credit_percent%type,
135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);

Line 139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,

135: p_new_credit_amount IN as_sales_credits.credit_amount%type,
136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
143:

Line 140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,

136: p_old_credit_amount IN as_sales_credits.credit_amount%type,
137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
143:
144: PROCEDURE GET_VALUE(p_old_last_update_date IN DATE,

Line 141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,

137: p_new_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
143:
144: PROCEDURE GET_VALUE(p_old_last_update_date IN DATE,
145: p_new_last_update_date IN DATE,

Line 142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);

138: p_old_opp_worst_frcst_amount IN as_sales_credits.opp_worst_forecast_amount%type,
139: p_new_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
140: p_old_opp_frcst_amount IN as_sales_credits.opp_forecast_amount%type,
141: p_new_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type,
142: p_old_opp_best_frcst_amount IN as_sales_credits.opp_best_forecast_amount%type);
143:
144: PROCEDURE GET_VALUE(p_old_last_update_date IN DATE,
145: p_new_last_update_date IN DATE,
146: IsInsert OUT NOCOPY NUMBER);