APPS.JA_CN_CUSTOM_SOURCES dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 44: GDF_Item ap_invoice_distributions_all.global_attribute1%type:=null;

40: --===========================================================================
41: FUNCTION GDF_Item(p_invoice_id IN NUMBER,
42: p_invoice_distribution_id IN NUMBER)
43: RETURN VARCHAR2 IS
44: GDF_Item ap_invoice_distributions_all.global_attribute1%type:=null;
45: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
46: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
47: l_proc_name VARCHAR2(100) :='GDF_Item';
48:

Line 72: FROM AP_INVOICE_DISTRIBUTIONS_ALL

68: --First get custom source value from distribution
69:
70: SELECT GLOBAL_ATTRIBUTE1
71: INTO GDF_ITEM
72: FROM AP_INVOICE_DISTRIBUTIONS_ALL
73: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID;
74:
75: --IF THE VALUE IN DISTRIBUTION IS NULL,
76: --THEN GET THE VALUE FROM HEADER.

Line 151: -- get the invoice line number and invoice id from ap_invoice_distributions_all

147: );
148:
149: END IF; --(l_proc_level >= l_dbg_level)
150:
151: -- get the invoice line number and invoice id from ap_invoice_distributions_all
152: SELECT INVOICE_LINE_NUMBER,INVOICE_ID
153: INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
154: FROM AP_INVOICE_DISTRIBUTIONS_ALL
155: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;

Line 154: FROM AP_INVOICE_DISTRIBUTIONS_ALL

150:
151: -- get the invoice line number and invoice id from ap_invoice_distributions_all
152: SELECT INVOICE_LINE_NUMBER,INVOICE_ID
153: INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
154: FROM AP_INVOICE_DISTRIBUTIONS_ALL
155: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;
156:
157: --get key flexfield concatenated_segments as source value
158: --CATEGORY SET NAME is 'Cash Flow Category'

Line 297: Expense_Item_desc ap_invoice_distributions_all.description%type:=null;

293: --===========================================================================
294: FUNCTION Expense_Item(P_INVOICE_ID IN NUMBER,
295: p_invoice_distribution_id IN NUMBER)
296: RETURN VARCHAR2 IS
297: Expense_Item_desc ap_invoice_distributions_all.description%type:=null;
298: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
299: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
300: l_proc_name VARCHAR2(100) :='Expense_Item';
301:

Line 320: FROM ap_invoice_distributions_all

316:
317: --get the custom value from destribution
318: SELECT description
319: INTO Expense_Item_desc
320: FROM ap_invoice_distributions_all
321: WHERE invoice_distribution_id=p_invoice_distribution_id ;
322: RETURN Expense_Item_desc;
323: --RETURN nvl(Expense_Item_desc,'expense_item_desc_0');
324: EXCEPTION

Line 387: -- get the invoice line number and invoice id from ap_invoice_distributions_all

383: );
384:
385: END IF; --(l_proc_level >= l_dbg_level)
386:
387: -- get the invoice line number and invoice id from ap_invoice_distributions_all
388: SELECT INVOICE_LINE_NUMBER,INVOICE_ID
389: INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
390: FROM AP_INVOICE_DISTRIBUTIONS_ALL
391: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;

Line 390: FROM AP_INVOICE_DISTRIBUTIONS_ALL

386:
387: -- get the invoice line number and invoice id from ap_invoice_distributions_all
388: SELECT INVOICE_LINE_NUMBER,INVOICE_ID
389: INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
390: FROM AP_INVOICE_DISTRIBUTIONS_ALL
391: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;
392:
393: --get key flexfield concatenated_segments as source value
394: --CATEGORY SET NAME is 'Cash Flow Category'