APPS.JA_CN_CUSTOM_SOURCES dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

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

102: --===========================================================================
103: FUNCTION GDF_Item(p_invoice_id IN NUMBER,
104: p_invoice_distribution_id IN NUMBER)
105: RETURN VARCHAR2 IS
106: GDF_Item ap_invoice_distributions_all.global_attribute1%type:=null;
107: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
108: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
109: l_proc_name VARCHAR2(100) :='GDF_Item';
110:

Line 134: FROM AP_INVOICE_DISTRIBUTIONS_ALL

130: --First get custom source value from distribution
131:
132: SELECT GLOBAL_ATTRIBUTE1
133: INTO GDF_ITEM
134: FROM AP_INVOICE_DISTRIBUTIONS_ALL
135: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID;
136:
137: --IF THE VALUE IN DISTRIBUTION IS NULL,
138: --THEN GET THE VALUE FROM HEADER.

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

209: );
210:
211: END IF; --(l_proc_level >= l_dbg_level)
212:
213: -- get the invoice line number and invoice id from ap_invoice_distributions_all
214: SELECT INVOICE_LINE_NUMBER,INVOICE_ID
215: INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
216: FROM AP_INVOICE_DISTRIBUTIONS_ALL
217: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;

Line 216: FROM AP_INVOICE_DISTRIBUTIONS_ALL

212:
213: -- get the invoice line number and invoice id from ap_invoice_distributions_all
214: SELECT INVOICE_LINE_NUMBER,INVOICE_ID
215: INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
216: FROM AP_INVOICE_DISTRIBUTIONS_ALL
217: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;
218:
219: --get key flexfield concatenated_segments as source value
220: --CATEGORY SET NAME is 'Cash Flow Category'

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

355: --===========================================================================
356: FUNCTION Expense_Item(P_INVOICE_ID IN NUMBER,
357: p_invoice_distribution_id IN NUMBER)
358: RETURN VARCHAR2 IS
359: Expense_Item_desc ap_invoice_distributions_all.description%type:=null;
360: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
361: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
362: l_proc_name VARCHAR2(100) :='Expense_Item';
363:

Line 382: FROM ap_invoice_distributions_all

378:
379: --get the custom value from destribution
380: SELECT description
381: INTO Expense_Item_desc
382: FROM ap_invoice_distributions_all
383: WHERE invoice_distribution_id=p_invoice_distribution_id ;
384: RETURN Expense_Item_desc;
385: --RETURN nvl(Expense_Item_desc,'expense_item_desc_0');
386: EXCEPTION

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

445: );
446:
447: END IF; --(l_proc_level >= l_dbg_level)
448:
449: -- get the invoice line number and invoice id from ap_invoice_distributions_all
450: SELECT INVOICE_LINE_NUMBER,INVOICE_ID
451: INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
452: FROM AP_INVOICE_DISTRIBUTIONS_ALL
453: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;

Line 452: FROM AP_INVOICE_DISTRIBUTIONS_ALL

448:
449: -- get the invoice line number and invoice id from ap_invoice_distributions_all
450: SELECT INVOICE_LINE_NUMBER,INVOICE_ID
451: INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
452: FROM AP_INVOICE_DISTRIBUTIONS_ALL
453: WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;
454:
455: --get key flexfield concatenated_segments as source value
456: --CATEGORY SET NAME is 'Cash Flow Category'