77: /* of mandatory parameters. */
78: /* The mandatory parameters are: */
79: /* 1) X_vendor_id */
80: /* 2) X_invoice_date */
81: /* 3) X_invoice_lines_rec -- Lines record as defined in AP_INVOICES_PKG */
82: /* 4) X_dist_tab -- Variable to contain the plsql table of dists */
83: /* 5) X_dist_set_total_percent - 100 = Full Dist set, <> 100 = Skeleton */
84: /* 6) X_exchange_rate */
85: /* 7) X_exchange_rate_type */
102: /* -- Should be null otherwise. */
103: /* */
104: /*==========================================================================*/
105: FUNCTION Generate_Dist_Tab_For_Dist_Set(
106: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
107: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
108: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
109: X_line_source IN VARCHAR2,
110: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
103: /* */
104: /*==========================================================================*/
105: FUNCTION Generate_Dist_Tab_For_Dist_Set(
106: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
107: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
108: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
109: X_line_source IN VARCHAR2,
110: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
111: X_dist_set_total_percent IN NUMBER,
104: /*==========================================================================*/
105: FUNCTION Generate_Dist_Tab_For_Dist_Set(
106: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
107: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
108: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
109: X_line_source IN VARCHAR2,
110: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
111: X_dist_set_total_percent IN NUMBER,
112: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
108: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
109: X_line_source IN VARCHAR2,
110: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
111: X_dist_set_total_percent IN NUMBER,
112: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
113: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
114: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
115: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
116: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
109: X_line_source IN VARCHAR2,
110: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
111: X_dist_set_total_percent IN NUMBER,
112: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
113: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
114: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
115: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
116: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
117: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
110: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
111: X_dist_set_total_percent IN NUMBER,
112: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
113: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
114: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
115: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
116: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
117: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
118: X_Error_Code OUT NOCOPY VARCHAR2,
111: X_dist_set_total_percent IN NUMBER,
112: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
113: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
114: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
115: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
116: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
117: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
118: X_Error_Code OUT NOCOPY VARCHAR2,
119: X_Debug_Info OUT NOCOPY VARCHAR2,
112: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
113: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
114: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
115: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
116: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
117: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
118: X_Error_Code OUT NOCOPY VARCHAR2,
119: X_Debug_Info OUT NOCOPY VARCHAR2,
120: X_Debug_Context OUT NOCOPY VARCHAR2,