eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_DISB_IN_TRANSIT dependencies on GL_PERIOD_STATUSES

Line 10: c_gl_appl_id gl_period_statuses.application_id%TYPE;

6: -- v_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
7:
8: v_set_of_books_id gl_ledgers_public_v.ledger_id%TYPE;
9: v_org_id fv_operating_units.org_id%TYPE;
10: c_gl_appl_id gl_period_statuses.application_id%TYPE;
11: g_treasury_confirmation_id NUMBER;
12: v_treasury_doc_date fv_treasury_confirmations.treasury_doc_date%TYPE;
13: c_application_short_name VARCHAR2(10);
14: c_key_flex_code VARCHAR2(4);

Line 223: FROM gl_period_statuses g

219: -- get name of open period that treasury doc date is in
220: BEGIN
221: SELECT period_name
222: INTO v_period
223: FROM gl_period_statuses g
224: WHERE g.application_id = c_gl_appl_id
225: AND g.set_of_books_id = v_set_of_books_id
226: AND g.closing_status IN ('O', 'F')
227: AND v_confirm_date BETWEEN

Line 237: FROM gl_period_statuses g

233: -- get name of next open period
234: BEGIN
235: SELECT period_name
236: INTO v_period
237: FROM gl_period_statuses g
238: WHERE g.application_id = c_gl_appl_id
239: AND g.set_of_books_id = v_set_of_books_id
240: AND g.adjustment_period_flag = 'N'
241: AND g.start_date = (SELECT MIN(start_date)

Line 242: FROM gl_period_statuses g2

238: WHERE g.application_id = c_gl_appl_id
239: AND g.set_of_books_id = v_set_of_books_id
240: AND g.adjustment_period_flag = 'N'
241: AND g.start_date = (SELECT MIN(start_date)
242: FROM gl_period_statuses g2
243: WHERE g2.application_id = c_gl_appl_id
244: AND g2.set_of_books_id = v_set_of_books_id
245: AND g2.end_date > v_confirm_date
246: AND g2.closing_status IN ('O', 'F')

Line 339: v_period_start_date gl_period_statuses.start_date%TYPE;

335: v_cr_account_segment_value gl_ussgl_account_pairs.cr_account_segment_value%TYPE;
336: v_checkrun_name fv_treasury_confirmations.checkrun_name%TYPE ;
337: v_check_id ap_checks.check_id%TYPE;
338: v_vendor_id po_vendors.vendor_id%TYPE;
339: v_period_start_date gl_period_statuses.start_date%TYPE;
340: v_period_end_date gl_period_statuses.end_date%TYPE;
341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;

Line 340: v_period_end_date gl_period_statuses.end_date%TYPE;

336: v_checkrun_name fv_treasury_confirmations.checkrun_name%TYPE ;
337: v_check_id ap_checks.check_id%TYPE;
338: v_vendor_id po_vendors.vendor_id%TYPE;
339: v_period_start_date gl_period_statuses.start_date%TYPE;
340: v_period_end_date gl_period_statuses.end_date%TYPE;
341: v_invoice_id ap_invoice_payments.invoice_id%TYPE;
342: v_cr_acct_amt ap_ae_lines.accounted_cr%TYPE;
343: v_dr_acct_amt ap_ae_lines.accounted_dr%TYPE;
344: v_curr_conv_type ap_ae_lines.currency_conversion_type%TYPE;

Line 439: FROM gl_period_statuses p

435: WHERE treasury_confirmation_id = x_treasury_confirmation_id;
436:
437: SELECT p.start_date, p.end_date
438: INTO v_period_start_date, v_period_end_date
439: FROM gl_period_statuses p
440: WHERE p.period_name = v_period
441: AND p.application_id = c_gl_appl_id
442: AND p.set_of_books_id = v_set_of_books_id
443: AND p.adjustment_period_flag = 'N';

Line 802: v_period gl_period_statuses.period_name%TYPE;

798: c_reference1 gl_interface.reference1%TYPE;
799: v_tc_id gl_interface.reference1%TYPE;
800: v_check_id ap_checks.check_id%TYPE;
801: v_invoice_id gl_je_lines.reference_4%TYPE;
802: v_period gl_period_statuses.period_name%TYPE;
803: v_period_start_date gl_period_statuses.start_date%TYPE;
804: v_period_end_date gl_period_statuses.end_date%TYPE;
805: v_accounting_date gl_interface.accounting_date%TYPE;
806: v_cr_acct_amt gl_je_lines.accounted_cr%TYPE;

Line 803: v_period_start_date gl_period_statuses.start_date%TYPE;

799: v_tc_id gl_interface.reference1%TYPE;
800: v_check_id ap_checks.check_id%TYPE;
801: v_invoice_id gl_je_lines.reference_4%TYPE;
802: v_period gl_period_statuses.period_name%TYPE;
803: v_period_start_date gl_period_statuses.start_date%TYPE;
804: v_period_end_date gl_period_statuses.end_date%TYPE;
805: v_accounting_date gl_interface.accounting_date%TYPE;
806: v_cr_acct_amt gl_je_lines.accounted_cr%TYPE;
807: v_dr_acct_amt gl_je_lines.accounted_dr%TYPE;

Line 804: v_period_end_date gl_period_statuses.end_date%TYPE;

800: v_check_id ap_checks.check_id%TYPE;
801: v_invoice_id gl_je_lines.reference_4%TYPE;
802: v_period gl_period_statuses.period_name%TYPE;
803: v_period_start_date gl_period_statuses.start_date%TYPE;
804: v_period_end_date gl_period_statuses.end_date%TYPE;
805: v_accounting_date gl_interface.accounting_date%TYPE;
806: v_cr_acct_amt gl_je_lines.accounted_cr%TYPE;
807: v_dr_acct_amt gl_je_lines.accounted_dr%TYPE;
808: v_curr_con_type gl_je_headers.currency_conversion_type%TYPE;

Line 834: FROM gl_period_statuses g

830: -- get name of open period that treasury doc date is in
831: BEGIN
832: SELECT period_name,g.start_date,g.end_date
833: INTO v_period,v_period_start_date,v_period_end_date
834: FROM gl_period_statuses g
835: WHERE g.application_id = c_gl_appl_id
836: AND g.set_of_books_id = v_set_of_books_id
837: AND g.closing_status IN ('O', 'F')
838: AND v_treasury_doc_date BETWEEN

Line 848: FROM gl_period_statuses g

844: -- get name of next open period
845: BEGIN
846: SELECT period_name,g.end_date,g.start_date
847: INTO v_period,v_period_end_date,v_period_start_date
848: FROM gl_period_statuses g
849: WHERE g.application_id = c_gl_appl_id
850: AND g.set_of_books_id = v_set_of_books_id
851: AND g.adjustment_period_flag = 'N'
852: AND g.start_date = (SELECT MIN(start_date)

Line 853: FROM gl_period_statuses g2

849: WHERE g.application_id = c_gl_appl_id
850: AND g.set_of_books_id = v_set_of_books_id
851: AND g.adjustment_period_flag = 'N'
852: AND g.start_date = (SELECT MIN(start_date)
853: FROM gl_period_statuses g2
854: WHERE g2.application_id = c_gl_appl_id
855: AND g2.set_of_books_id = v_set_of_books_id
856: AND g2.end_date > v_treasury_doc_date
857: AND g2.closing_status IN ('O', 'F')

Line 1041: v_accounting_date gl_period_statuses.end_date%TYPE;

1037: l_processed_flag fv_voided_checks.processed_flag%TYPE;
1038: l_treasury_conf_id1 NUMBER;
1039: l_insert_je_line BOOLEAN := FALSE;
1040: l_treasury_conf_id NUMBER;
1041: v_accounting_date gl_period_statuses.end_date%TYPE;
1042: l_set_of_books_name VARCHAR2(200);
1043:
1044: CURSOR voided_checks_list_cursor
1045: (

Line 1249: FROM gl_period_statuses g

1245: -- get name of open period that void gl date of check is in
1246: BEGIN
1247: SELECT end_date
1248: INTO v_accounting_date
1249: FROM gl_period_statuses g
1250: WHERE g.application_id = c_gl_appl_id
1251: AND g.set_of_books_id = v_set_of_books_id
1252: AND g.closing_status IN ('O', 'F')
1253: AND v_accounting_date BETWEEN

Line 1264: FROM gl_period_statuses g

1260: -- get name of next open period
1261: BEGIN
1262: SELECT end_date
1263: INTO v_accounting_date
1264: FROM gl_period_statuses g
1265: WHERE g.application_id = c_gl_appl_id
1266: AND g.set_of_books_id = v_set_of_books_id
1267: AND g.adjustment_period_flag = 'N'
1268: AND g.start_date = (SELECT MIN(start_date)

Line 1269: FROM gl_period_statuses g2

1265: WHERE g.application_id = c_gl_appl_id
1266: AND g.set_of_books_id = v_set_of_books_id
1267: AND g.adjustment_period_flag = 'N'
1268: AND g.start_date = (SELECT MIN(start_date)
1269: FROM gl_period_statuses g2
1270: WHERE g2.application_id = c_gl_appl_id
1271: AND g2.set_of_books_id = v_set_of_books_id
1272: AND g2.end_date > v_accounting_date
1273: AND g2.closing_status IN ('O', 'F')