[Home] [Help]
80: 'Set_purge_status<-'||P_calling_sequence;
81: --
82: debug_info := 'Starting Set_purge_status';
83: IF (p_debug_switch in ('y','Y')) THEN
84: Print('(Updating table financials_purges)'||debug_info);
85: END IF;
86:
87: UPDATE financials_purges
88: SET status = P_Status
83: IF (p_debug_switch in ('y','Y')) THEN
84: Print('(Updating table financials_purges)'||debug_info);
85: END IF;
86:
87: UPDATE financials_purges
88: SET status = P_Status
89: WHERE purge_name = P_Purge_Name;
90: --
91: debug_info := 'End Set_purge_status';
89: WHERE purge_name = P_Purge_Name;
90: --
91: debug_info := 'End Set_purge_status';
92: IF (g_debug_switch in ('y','Y')) THEN
93: Print('(Done updating table financials_purges)'||debug_info);
94: END IF;
95: RETURN(TRUE);
96:
97: RETURN NULL;
4021: Print('(Record_Initial_Statistics)'||debug_info);
4022: END IF;
4023:
4024:
4025: UPDATE financials_purges
4026: SET
4027: ap_checks = fp_check_rows,
4028: ap_invoice_payments = fp_invoice_payment_rows,
4029: ap_invoices = fp_invoice_rows,
6498: end if;
6499: END IF;
6500:
6501: -- record_final_statistics
6502: UPDATE financials_purges
6503: SET
6504: ap_checks = nvl(ap_checks, 0) - check_rows,
6505: ap_invoice_payments = nvl(ap_invoice_payments, 0) - invoice_payment_rows,
6506: ap_invoices = nvl(ap_invoices, 0) - invoice_rows,