807: pa_retention_util.write_log('Create_Retn_Invoice_Lines: ' || 'Task Name : ' || l_task_name);
808: END IF;
809: -- Find out any lines are existing or not
810: IF g1_debug_mode = 'Y' THEN
811: pa_retention_util.write_log('Create_Retn_Invoice_Lines: ' || 'CAll pa_retention_pkg.Get_Invoice_Max_Line');
812: END IF;
813:
814: LastLineNum := pa_retention_pkg.Get_Invoice_Max_Line(p_project_id=>p_project_id,
815: p_draft_Invoice_num=>p_draft_invoice_num);
810: IF g1_debug_mode = 'Y' THEN
811: pa_retention_util.write_log('Create_Retn_Invoice_Lines: ' || 'CAll pa_retention_pkg.Get_Invoice_Max_Line');
812: END IF;
813:
814: LastLineNum := pa_retention_pkg.Get_Invoice_Max_Line(p_project_id=>p_project_id,
815: p_draft_Invoice_num=>p_draft_invoice_num);
816:
817: IF g1_debug_mode = 'Y' THEN
818: pa_retention_util.write_log('Create_Retn_Invoice_Lines: ' || 'CAll Get_Retn_Billing_Inv_Format');
1078:
1079: -- Update the balances
1080:
1081: IF g1_debug_mode = 'Y' THEN
1082: pa_retention_util.write_log('Create_Retn_Invoice_Lines: ' || 'Call pa_retention_pkg.Update_Retention_Balances');
1083: END IF;
1084:
1085: pa_retention_pkg.Update_Retention_Balances(
1086: p_project_id=>p_project_id,
1081: IF g1_debug_mode = 'Y' THEN
1082: pa_retention_util.write_log('Create_Retn_Invoice_Lines: ' || 'Call pa_retention_pkg.Update_Retention_Balances');
1083: END IF;
1084:
1085: pa_retention_pkg.Update_Retention_Balances(
1086: p_project_id=>p_project_id,
1087: p_agreement_id=>p_agreement_id,
1088: p_task_id=>p_task_id,
1089: p_customer_id=>p_customer_id,