357: x_msg_data OUT NOCOPY VARCHAR2);
358:
359: PROCEDURE sum_retained_amount(
360: p_task_id IN NUMBER,
361: p_SetOfBookIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
362: p_RetainedAmtPFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
363: p_RetainedAmtFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
364: x_RetainedAmtTab IN OUT NOCOPY RetainedAmtTabTyp,
365: x_return_status OUT NOCOPY VARCHAR2,
358:
359: PROCEDURE sum_retained_amount(
360: p_task_id IN NUMBER,
361: p_SetOfBookIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
362: p_RetainedAmtPFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
363: p_RetainedAmtFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
364: x_RetainedAmtTab IN OUT NOCOPY RetainedAmtTabTyp,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
359: PROCEDURE sum_retained_amount(
360: p_task_id IN NUMBER,
361: p_SetOfBookIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
362: p_RetainedAmtPFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
363: p_RetainedAmtFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
364: x_RetainedAmtTab IN OUT NOCOPY RetainedAmtTabTyp,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2);
391: PROCEDURE populate_invoice_amount(
392: p_project_id IN NUMBER,
393: p_agreement_id IN NUMBER,
394: p_task_id IN NUMBER,
395: p_SetOfBookIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
396: p_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
397: p_BillAmtIPCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
398: p_BillAmtFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
399: p_BillAmtPFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
392: p_project_id IN NUMBER,
393: p_agreement_id IN NUMBER,
394: p_task_id IN NUMBER,
395: p_SetOfBookIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
396: p_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
397: p_BillAmtIPCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
398: p_BillAmtFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
399: p_BillAmtPFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
400: x_return_status OUT NOCOPY VARCHAR2,
393: p_agreement_id IN NUMBER,
394: p_task_id IN NUMBER,
395: p_SetOfBookIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
396: p_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
397: p_BillAmtIPCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
398: p_BillAmtFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
399: p_BillAmtPFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
394: p_task_id IN NUMBER,
395: p_SetOfBookIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
396: p_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
397: p_BillAmtIPCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
398: p_BillAmtFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
399: p_BillAmtPFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2) ;
395: p_SetOfBookIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
396: p_TaskIdTab IN PA_PLSQL_DATATYPES.IdTabTyp,
397: p_BillAmtIPCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
398: p_BillAmtFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
399: p_BillAmtPFCTab IN PA_PLSQL_DATATYPES.NumTabTyp,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2) ;
403: