APPS.IGIPMSLR dependencies on IGI_MPP_SUBLEDGER

Line 6: SUBTYPE SUBLGR IS IGI_MPP_SUBLEDGER%ROWTYPE;

2: -- $Header: igipmslb.pls 115.6 2003/12/01 15:00:09 sdixit ship $
3: -- ---------
4: -- SUBTYPES
5: -- --------
6: SUBTYPE SUBLGR IS IGI_MPP_SUBLEDGER%ROWTYPE;
7: -- ---------
8: -- CONSTANTS
9: -- ---------
10:

Line 90: FROM igi_mpp_subledger

86: )
87: RETURN BOOLEAN IS
88: CURSOR c_exists IS
89: SELECT count('x') ct
90: FROM igi_mpp_subledger
91: WHERE invoice_id = p_invoice_id
92: AND distribution_line_number = p_distribution_line_number
93: AND reference1 = '0'
94: ;

Line 110: FROM igi_mpp_subledger

106: )
107: RETURN BOOLEAN IS
108: CURSOR c_exists IS
109: SELECT 'x'
110: FROM igi_mpp_subledger
111: WHERE invoice_id = p_invoice_id
112: AND distribution_line_number = p_distribution_line_number
113: AND ( nvl(expense_recognized_flag,'N') = 'Y'
114: OR nvl(gl_posted_flag,'N') = 'Y' )

Line 247: INSERT INTO IGI_MPP_SUBLEDGER

243: l_factor );
244:
245: l_date := nvl( l_date, p_sublgr.gl_date );
246:
247: INSERT INTO IGI_MPP_SUBLEDGER
248: (
249: invoice_id
250: ,distribution_line_number
251: ,last_update_date

Line 370: SELECT igi_mpp_subledger_s.nextval

366: , l_sublgr.functional_currency_code
367: );
368: END IF;
369:
370: SELECT igi_mpp_subledger_s.nextval
371: INTO l_sublgr.subledger_entry_id
372: FROM sys.dual;
373:
374: InsertIntoSublgr ( l_sublgr );

Line 431: SELECT igi_mpp_subledger_s.nextval

427: , l_sublgr.currency_code
428: , l_sublgr.functional_currency_code
429: );
430: END IF;
431: SELECT igi_mpp_subledger_s.nextval
432: INTO l_sublgr.subledger_entry_id
433: FROM sys.dual;
434:
435: InsertIntoSublgr ( l_sublgr );

Line 668: delete from igi_mpp_subledger

664: '>> >> Delete from Subledger Entries...');
665: END IF;
666: --bug 3199481 fnd logging changes: sdixit: end block
667:
668: delete from igi_mpp_subledger
669: where invoice_id = l_dist.invoice_id
670: and distribution_line_number = l_dist.distribution_line_number
671: ;
672: --bug 3199481: fnd logging changes:sdixit :start