74:
75: l_debug_info := 'Insert rejection information to ap_interface_rejections';
76: ---------------------------------------------------------------------------
77:
78: -- Get the information of WHO Columns from FND_GLOBAL
79: v_last_update_by := FND_GLOBAL.User_ID;
80: v_last_update_login := FND_GLOBAL.Login_Id;
81:
82: -- Select next value from the sequence.
75: l_debug_info := 'Insert rejection information to ap_interface_rejections';
76: ---------------------------------------------------------------------------
77:
78: -- Get the information of WHO Columns from FND_GLOBAL
79: v_last_update_by := FND_GLOBAL.User_ID;
80: v_last_update_login := FND_GLOBAL.Login_Id;
81:
82: -- Select next value from the sequence.
83: SELECT jl_zz_ap_inv_dis_wh_s.nextval
76: ---------------------------------------------------------------------------
77:
78: -- Get the information of WHO Columns from FND_GLOBAL
79: v_last_update_by := FND_GLOBAL.User_ID;
80: v_last_update_login := FND_GLOBAL.Login_Id;
81:
82: -- Select next value from the sequence.
83: SELECT jl_zz_ap_inv_dis_wh_s.nextval
84: INTO Seq_Inv_Dis_Awt_Id
877: -- ditribution lines.
878: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
879: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
880: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;
881: v_last_update_login number := FND_GLOBAL.Login_Id;
882: v_last_update_by number := FND_GLOBAL.User_ID;
883: DistWithholdings Number := 0;
884: -- Variable added for bug 6869263
885: v_related_dist_id ap_invoice_distributions_all.related_id%TYPE;
878: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
879: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
880: v_line_type ap_invoice_distributions_all.line_type_lookup_code %TYPE;
881: v_last_update_login number := FND_GLOBAL.Login_Id;
882: v_last_update_by number := FND_GLOBAL.User_ID;
883: DistWithholdings Number := 0;
884: -- Variable added for bug 6869263
885: v_related_dist_id ap_invoice_distributions_all.related_id%TYPE;
886: