DBA Data[Home] [Help]

APPS.FV_DISB_IN_TRANSIT dependencies on FND_GLOBAL

Line 189: last_updated_by = fnd_global.user_id,

185: UPDATE ap_checks c
186: SET treasury_pay_number = v_begin_doc,
187: treasury_pay_date = v_confirm_date,
188: last_update_date = SYSDATE,
189: last_updated_by = fnd_global.user_id,
190: last_update_login = fnd_global.login_id
191: WHERE c.check_id = l_check_tbl(l_row_num).check_id;
192: l_row_num := l_row_num+1;
193: v_begin_doc := v_begin_doc +1;

Line 190: last_update_login = fnd_global.login_id

186: SET treasury_pay_number = v_begin_doc,
187: treasury_pay_date = v_confirm_date,
188: last_update_date = SYSDATE,
189: last_updated_by = fnd_global.user_id,
190: last_update_login = fnd_global.login_id
191: WHERE c.check_id = l_check_tbl(l_row_num).check_id;
192: l_row_num := l_row_num+1;
193: v_begin_doc := v_begin_doc +1;
194: END LOOP;

Line 552: SYSDATE, fnd_global.user_id,

548: v_functional_curr_code,
549: v_curr_conv_type,
550: v_curr_conv_date,
551: v_curr_conv_rate,
552: SYSDATE, fnd_global.user_id,
553: 'A', 'Treasury Confirmation',
554: 'Payables', a_segments(1),
555: a_segments(2), a_segments(3),
556: a_segments(4), a_segments(5),

Line 619: SYSDATE, fnd_global.user_id,

615: v_functional_curr_code,
616: v_curr_conv_type,
617: v_curr_conv_date,
618: v_curr_conv_rate,
619: SYSDATE, fnd_global.user_id,
620: 'A', 'Treasury Confirmation',
621: 'Payables', a_segments(1),
622: a_segments(2), a_segments(3),
623: a_segments(4), a_segments(5),

Line 685: last_updated_by = fnd_global.user_id,

681: -- if the process is backout, status is Confirmed
682: SET confirmation_status_flag = DECODE(v_process_job, 'C', 'N', 'B', 'Y'),
683: gl_period = NULL,
684: last_update_date = SYSDATE,
685: last_updated_by = fnd_global.user_id,
686: last_update_login = fnd_global.login_id
687: WHERE treasury_confirmation_id = x_treasury_confirmation_id;
688: END IF;
689:

Line 686: last_update_login = fnd_global.login_id

682: SET confirmation_status_flag = DECODE(v_process_job, 'C', 'N', 'B', 'Y'),
683: gl_period = NULL,
684: last_update_date = SYSDATE,
685: last_updated_by = fnd_global.user_id,
686: last_update_login = fnd_global.login_id
687: WHERE treasury_confirmation_id = x_treasury_confirmation_id;
688: END IF;
689:
690: x_err_code := 2;

Line 970: SYSDATE, fnd_global.user_id,

966: v_accounting_date, v_currency_code,
967: v_curr_con_type,v_curr_con_rate,
968: v_curr_con_date,
969: v_func_currency_code,
970: SYSDATE, fnd_global.user_id,
971: 'A', 'Treasury Confirmation',
972: 'Payables', a_segments(1),
973: a_segments(2), a_segments(3),
974: a_segments(4), a_segments(5),

Line 1172: fnd_global.user_id,

1168: checkrun_name,
1169: check_id,
1170: 'U',
1171: SYSDATE,
1172: fnd_global.user_id,
1173: SYSDATE,
1174: fnd_global.user_id,
1175: fnd_global.login_id,
1176: org_id

Line 1174: fnd_global.user_id,

1170: 'U',
1171: SYSDATE,
1172: fnd_global.user_id,
1173: SYSDATE,
1174: fnd_global.user_id,
1175: fnd_global.login_id,
1176: org_id
1177: FROM ap_checks_all ac
1178: WHERE org_id = l_org_id

Line 1175: fnd_global.login_id,

1171: SYSDATE,
1172: fnd_global.user_id,
1173: SYSDATE,
1174: fnd_global.user_id,
1175: fnd_global.login_id,
1176: org_id
1177: FROM ap_checks_all ac
1178: WHERE org_id = l_org_id
1179: AND void_date IS NOT NULL

Line 1335: fnd_global.user_id,

1331: voided_checks_list_rec.exchange_date,
1332: cur_process_void_check_rec.currency_conversion_rate,
1333: l_func_currency_code,
1334: SYSDATE,
1335: fnd_global.user_id,
1336: 'A',
1337: 'Treasury Confirmation',
1338: 'Payables',
1339: cur_process_void_check_rec.entered_cr,

Line 1873: last_updated_by = fnd_global.user_id,

1869: UPDATE AP_CHECKS
1870: SET treasury_pay_number = NULL,
1871: treasury_pay_date = NULL,
1872: last_update_date = SYSDATE,
1873: last_updated_by = fnd_global.user_id,
1874: last_update_login = fnd_global.login_id
1875: WHERE payment_id IN
1876: (SELECT payment_id
1877: FROM fv_treasury_confirmations ftca,

Line 1874: last_update_login = fnd_global.login_id

1870: SET treasury_pay_number = NULL,
1871: treasury_pay_date = NULL,
1872: last_update_date = SYSDATE,
1873: last_updated_by = fnd_global.user_id,
1874: last_update_login = fnd_global.login_id
1875: WHERE payment_id IN
1876: (SELECT payment_id
1877: FROM fv_treasury_confirmations ftca,
1878: iby_payments_all ipa

Line 1885: last_updated_by = fnd_global.user_id,

1881:
1882: UPDATE fv_treasury_confirmations
1883: SET confirmation_status_flag = 'B',
1884: last_update_date = SYSDATE,
1885: last_updated_by = fnd_global.user_id,
1886: last_update_login = fnd_global.login_id
1887: WHERE treasury_confirmation_id = v_treasury_confirmation_id;
1888:
1889: --delete the offset record related to this payment

Line 1886: last_update_login = fnd_global.login_id

1882: UPDATE fv_treasury_confirmations
1883: SET confirmation_status_flag = 'B',
1884: last_update_date = SYSDATE,
1885: last_updated_by = fnd_global.user_id,
1886: last_update_login = fnd_global.login_id
1887: WHERE treasury_confirmation_id = v_treasury_confirmation_id;
1888:
1889: --delete the offset record related to this payment
1890: --batch.

Line 1911: last_updated_by = fnd_global.user_id,

1907: UPDATE fv_treasury_confirmations
1908: SET confirmation_status_flag = 'Y',
1909: gl_period = v_period,
1910: last_update_date = SYSDATE,
1911: last_updated_by = fnd_global.user_id,
1912: last_update_login = fnd_global.login_id
1913: WHERE treasury_confirmation_id = v_treasury_confirmation_id;
1914: END IF;
1915:

Line 1912: last_update_login = fnd_global.login_id

1908: SET confirmation_status_flag = 'Y',
1909: gl_period = v_period,
1910: last_update_date = SYSDATE,
1911: last_updated_by = fnd_global.user_id,
1912: last_update_login = fnd_global.login_id
1913: WHERE treasury_confirmation_id = v_treasury_confirmation_id;
1914: END IF;
1915:
1916: END IF;