3:
4: --Global Variables
5:
6: TYPE r_inv_aprvl_hist IS RECORD(
7: APPROVAL_HISTORY_ID ap_inv_aprvl_hist_all.approval_history_id%TYPE,
8: INVOICE_ID ap_inv_aprvl_hist_all.invoice_id%TYPE,
9: ITERATION ap_inv_aprvl_hist_all.iteration%TYPE,
10: RESPONSE ap_inv_aprvl_hist_all.response%TYPE,
11: APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
4: --Global Variables
5:
6: TYPE r_inv_aprvl_hist IS RECORD(
7: APPROVAL_HISTORY_ID ap_inv_aprvl_hist_all.approval_history_id%TYPE,
8: INVOICE_ID ap_inv_aprvl_hist_all.invoice_id%TYPE,
9: ITERATION ap_inv_aprvl_hist_all.iteration%TYPE,
10: RESPONSE ap_inv_aprvl_hist_all.response%TYPE,
11: APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
12: AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
5:
6: TYPE r_inv_aprvl_hist IS RECORD(
7: APPROVAL_HISTORY_ID ap_inv_aprvl_hist_all.approval_history_id%TYPE,
8: INVOICE_ID ap_inv_aprvl_hist_all.invoice_id%TYPE,
9: ITERATION ap_inv_aprvl_hist_all.iteration%TYPE,
10: RESPONSE ap_inv_aprvl_hist_all.response%TYPE,
11: APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
12: AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
13: APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
6: TYPE r_inv_aprvl_hist IS RECORD(
7: APPROVAL_HISTORY_ID ap_inv_aprvl_hist_all.approval_history_id%TYPE,
8: INVOICE_ID ap_inv_aprvl_hist_all.invoice_id%TYPE,
9: ITERATION ap_inv_aprvl_hist_all.iteration%TYPE,
10: RESPONSE ap_inv_aprvl_hist_all.response%TYPE,
11: APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
12: AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
13: APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
14: CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
7: APPROVAL_HISTORY_ID ap_inv_aprvl_hist_all.approval_history_id%TYPE,
8: INVOICE_ID ap_inv_aprvl_hist_all.invoice_id%TYPE,
9: ITERATION ap_inv_aprvl_hist_all.iteration%TYPE,
10: RESPONSE ap_inv_aprvl_hist_all.response%TYPE,
11: APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
12: AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
13: APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
14: CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
15: CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
8: INVOICE_ID ap_inv_aprvl_hist_all.invoice_id%TYPE,
9: ITERATION ap_inv_aprvl_hist_all.iteration%TYPE,
10: RESPONSE ap_inv_aprvl_hist_all.response%TYPE,
11: APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
12: AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
13: APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
14: CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
15: CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
16: LAST_UPDATE_DATE ap_inv_aprvl_hist_all.last_update_date%TYPE,
9: ITERATION ap_inv_aprvl_hist_all.iteration%TYPE,
10: RESPONSE ap_inv_aprvl_hist_all.response%TYPE,
11: APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
12: AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
13: APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
14: CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
15: CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
16: LAST_UPDATE_DATE ap_inv_aprvl_hist_all.last_update_date%TYPE,
17: LAST_UPDATED_BY ap_inv_aprvl_hist_all.last_updated_by%TYPE,
10: RESPONSE ap_inv_aprvl_hist_all.response%TYPE,
11: APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
12: AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
13: APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
14: CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
15: CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
16: LAST_UPDATE_DATE ap_inv_aprvl_hist_all.last_update_date%TYPE,
17: LAST_UPDATED_BY ap_inv_aprvl_hist_all.last_updated_by%TYPE,
18: LAST_UPDATE_LOGIN ap_inv_aprvl_hist_all.last_update_login%TYPE,
11: APPROVER_ID ap_inv_aprvl_hist_all.approver_id%TYPE,
12: AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
13: APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
14: CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
15: CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
16: LAST_UPDATE_DATE ap_inv_aprvl_hist_all.last_update_date%TYPE,
17: LAST_UPDATED_BY ap_inv_aprvl_hist_all.last_updated_by%TYPE,
18: LAST_UPDATE_LOGIN ap_inv_aprvl_hist_all.last_update_login%TYPE,
19: ORG_ID ap_inv_aprvl_hist_all.org_id%TYPE);
12: AMOUNT_APPROVED ap_inv_aprvl_hist_all.amount_approved%TYPE,
13: APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
14: CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
15: CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
16: LAST_UPDATE_DATE ap_inv_aprvl_hist_all.last_update_date%TYPE,
17: LAST_UPDATED_BY ap_inv_aprvl_hist_all.last_updated_by%TYPE,
18: LAST_UPDATE_LOGIN ap_inv_aprvl_hist_all.last_update_login%TYPE,
19: ORG_ID ap_inv_aprvl_hist_all.org_id%TYPE);
20:
13: APPROVER_COMMENTS ap_inv_aprvl_hist_all.approver_comments%TYPE,
14: CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
15: CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
16: LAST_UPDATE_DATE ap_inv_aprvl_hist_all.last_update_date%TYPE,
17: LAST_UPDATED_BY ap_inv_aprvl_hist_all.last_updated_by%TYPE,
18: LAST_UPDATE_LOGIN ap_inv_aprvl_hist_all.last_update_login%TYPE,
19: ORG_ID ap_inv_aprvl_hist_all.org_id%TYPE);
20:
21: TYPE r_line_aprvl_hist IS RECORD(
14: CREATED_BY ap_inv_aprvl_hist_all.created_by%TYPE,
15: CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
16: LAST_UPDATE_DATE ap_inv_aprvl_hist_all.last_update_date%TYPE,
17: LAST_UPDATED_BY ap_inv_aprvl_hist_all.last_updated_by%TYPE,
18: LAST_UPDATE_LOGIN ap_inv_aprvl_hist_all.last_update_login%TYPE,
19: ORG_ID ap_inv_aprvl_hist_all.org_id%TYPE);
20:
21: TYPE r_line_aprvl_hist IS RECORD(
22: LINE_APRVL_HISTORY_ID ap_line_aprvl_hist_all.line_aprvl_history_id%TYPE,
15: CREATION_DATE ap_inv_aprvl_hist_all.creation_date%TYPE,
16: LAST_UPDATE_DATE ap_inv_aprvl_hist_all.last_update_date%TYPE,
17: LAST_UPDATED_BY ap_inv_aprvl_hist_all.last_updated_by%TYPE,
18: LAST_UPDATE_LOGIN ap_inv_aprvl_hist_all.last_update_login%TYPE,
19: ORG_ID ap_inv_aprvl_hist_all.org_id%TYPE);
20:
21: TYPE r_line_aprvl_hist IS RECORD(
22: LINE_APRVL_HISTORY_ID ap_line_aprvl_hist_all.line_aprvl_history_id%TYPE,
23: LINE_NUMBER ap_line_aprvl_hist_all.line_number%TYPE,