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.JL_CMERGE dependencies on JL_BR_JOURNALS

Line 513: -- JL_BR_JOURNALS_UPD --

509:
510:
511: ----------------------------------------------------------------------------
512: -- PROCEDURE --
513: -- JL_BR_JOURNALS_UPD --
514: -- --
515: -- DESCRIPTION --
516: -- Merge duplicate customer_id stored in column of --
517: -- JL_BR_JOURNALS_ALL that refers to cust_account_id column of --

Line 517: -- JL_BR_JOURNALS_ALL that refers to cust_account_id column of --

513: -- JL_BR_JOURNALS_UPD --
514: -- --
515: -- DESCRIPTION --
516: -- Merge duplicate customer_id stored in column of --
517: -- JL_BR_JOURNALS_ALL that refers to cust_account_id column of --
518: -- HZ_CUST_ACCOUNTS --
519: -- --
520: -- PURPOSE: --
521: -- Oracle Applications Rel 11.5 --

Line 531: PROCEDURE jl_br_journals_upd (req_id NUMBER,

527: -- --
528: -- HISTORY: --
529: -- 06/26/01 Rafael Guerrero Created --
530: ----------------------------------------------------------------------------
531: PROCEDURE jl_br_journals_upd (req_id NUMBER,
532: set_num NUMBER,
533: process_mode VARCHAR2)
534: IS
535:

Line 542: JL_BR_JOURNALS_ALL.application_id%TYPE

538: INDEX BY BINARY_INTEGER;
539: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
540:
541: TYPE application_id_LIST_TYPE IS TABLE OF
542: JL_BR_JOURNALS_ALL.application_id%TYPE
543: INDEX BY BINARY_INTEGER;
544: PRIMARY_KEY1_LIST application_id_LIST_TYPE;
545:
546: TYPE set_of_books_id_LIST_TYPE IS TABLE OF

Line 547: JL_BR_JOURNALS_ALL.set_of_books_id%TYPE

543: INDEX BY BINARY_INTEGER;
544: PRIMARY_KEY1_LIST application_id_LIST_TYPE;
545:
546: TYPE set_of_books_id_LIST_TYPE IS TABLE OF
547: JL_BR_JOURNALS_ALL.set_of_books_id%TYPE
548: INDEX BY BINARY_INTEGER;
549: PRIMARY_KEY2_LIST set_of_books_id_LIST_TYPE;
550:
551: TYPE code_combination_id_LIST_TYPE IS TABLE OF

Line 552: JL_BR_JOURNALS_ALL.code_combination_id%TYPE

548: INDEX BY BINARY_INTEGER;
549: PRIMARY_KEY2_LIST set_of_books_id_LIST_TYPE;
550:
551: TYPE code_combination_id_LIST_TYPE IS TABLE OF
552: JL_BR_JOURNALS_ALL.code_combination_id%TYPE
553: INDEX BY BINARY_INTEGER;
554: PRIMARY_KEY3_LIST code_combination_id_LIST_TYPE;
555:
556: TYPE personnel_id_LIST_TYPE IS TABLE OF

Line 557: JL_BR_JOURNALS_ALL.personnel_id%TYPE

553: INDEX BY BINARY_INTEGER;
554: PRIMARY_KEY3_LIST code_combination_id_LIST_TYPE;
555:
556: TYPE personnel_id_LIST_TYPE IS TABLE OF
557: JL_BR_JOURNALS_ALL.personnel_id%TYPE
558: INDEX BY BINARY_INTEGER;
559: PRIMARY_KEY4_LIST personnel_id_LIST_TYPE;
560: NUM_COL1_ORIG_LIST PERSONNEL_ID_LIST_TYPE;
561: NUM_COL1_NEW_LIST PERSONNEL_ID_LIST_TYPE;

Line 565: JL_BR_JOURNALS_ALL.accounting_date%TYPE

561: NUM_COL1_NEW_LIST PERSONNEL_ID_LIST_TYPE;
562:
563:
564: TYPE accounting_date_LIST_TYPE IS TABLE OF
565: JL_BR_JOURNALS_ALL.accounting_date%TYPE
566: INDEX BY BINARY_INTEGER;
567: PRIMARY_KEY5_LIST accounting_date_LIST_TYPE;
568:
569: TYPE trans_description_LIST_TYPE IS TABLE OF

Line 570: JL_BR_JOURNALS_ALL.trans_description%TYPE

566: INDEX BY BINARY_INTEGER;
567: PRIMARY_KEY5_LIST accounting_date_LIST_TYPE;
568:
569: TYPE trans_description_LIST_TYPE IS TABLE OF
570: JL_BR_JOURNALS_ALL.trans_description%TYPE
571: INDEX BY BINARY_INTEGER;
572: PRIMARY_KEY6_LIST trans_description_LIST_TYPE;
573:
574:

Line 576: JL_BR_JOURNALS_ALL.trans_id%TYPE

572: PRIMARY_KEY6_LIST trans_description_LIST_TYPE;
573:
574:
575: TYPE trans_id_LIST_TYPE IS TABLE OF
576: JL_BR_JOURNALS_ALL.trans_id%TYPE
577: INDEX BY BINARY_INTEGER;
578: PRIMARY_KEY7_LIST trans_id_LIST_TYPE;
579:
580: TYPE installment_LIST_TYPE IS TABLE OF

Line 581: JL_BR_JOURNALS_ALL.installment%TYPE

577: INDEX BY BINARY_INTEGER;
578: PRIMARY_KEY7_LIST trans_id_LIST_TYPE;
579:
580: TYPE installment_LIST_TYPE IS TABLE OF
581: JL_BR_JOURNALS_ALL.installment%TYPE
582: INDEX BY BINARY_INTEGER;
583: PRIMARY_KEY8_LIST installment_LIST_TYPE;
584:
585: TYPE period_set_name_LIST_TYPE IS TABLE OF

Line 586: JL_BR_JOURNALS_ALL.period_set_name%TYPE

582: INDEX BY BINARY_INTEGER;
583: PRIMARY_KEY8_LIST installment_LIST_TYPE;
584:
585: TYPE period_set_name_LIST_TYPE IS TABLE OF
586: JL_BR_JOURNALS_ALL.period_set_name%TYPE
587: INDEX BY BINARY_INTEGER;
588: PRIMARY_KEY9_LIST period_set_name_LIST_TYPE;
589:
590:

Line 592: JL_BR_JOURNALS_ALL.period_name%TYPE

588: PRIMARY_KEY9_LIST period_set_name_LIST_TYPE;
589:
590:
591: TYPE period_name_LIST_TYPE IS TABLE OF
592: JL_BR_JOURNALS_ALL.period_name%TYPE
593: INDEX BY BINARY_INTEGER;
594: PRIMARY_KEY10_LIST period_name_LIST_TYPE;
595:
596: TYPE JOURNAL_BALANCE_FLAG_LIST_TYPE IS TABLE OF

Line 597: JL_BR_JOURNALS_ALL.JOURNAL_BALANCE_FLAG%TYPE

593: INDEX BY BINARY_INTEGER;
594: PRIMARY_KEY10_LIST period_name_LIST_TYPE;
595:
596: TYPE JOURNAL_BALANCE_FLAG_LIST_TYPE IS TABLE OF
597: JL_BR_JOURNALS_ALL.JOURNAL_BALANCE_FLAG%TYPE
598: INDEX BY BINARY_INTEGER;
599: VCHAR_COL1_ORIG_LIST JOURNAL_BALANCE_FLAG_LIST_TYPE;
600: VCHAR_COL1_NEW_LIST JOURNAL_BALANCE_FLAG_LIST_TYPE;
601:

Line 618: FROM JL_BR_JOURNALS_ALL yt, ra_customer_merges m

614: ,period_set_name
615: ,period_name
616: ,personnel_id
617: ,journal_balance_flag
618: FROM JL_BR_JOURNALS_ALL yt, ra_customer_merges m
619: WHERE yt.PERSONNEL_ID = m.duplicate_id
620: AND m.process_flag = 'N'
621: AND m.request_id = req_id
622: AND m.set_number = set_num

Line 628: -- FROM jl_br_journals_all

624:
625: -- replaced by cursor above
626: -- CURSOR c1 IS
627: -- SELECT SET_OF_BOOKS_ID
628: -- FROM jl_br_journals_all
629: -- WHERE (personnel_id) IN (SELECT unique m.duplicate_id
630: -- FROM ra_customer_merges m
631: -- WHERE m.process_flag = 'N'
632: -- AND m.request_id = req_id

Line 643: arp_message.set_line ('JL_CMERGE.JL_BR_JOURNALS_UPD()+');

639: l_count NUMBER;
640:
641: BEGIN
642:
643: arp_message.set_line ('JL_CMERGE.JL_BR_JOURNALS_UPD()+');
644:
645: IF (process_mode = 'LOCK' ) THEN
646: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
647: arp_message.set_token ('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);

Line 647: arp_message.set_token ('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);

643: arp_message.set_line ('JL_CMERGE.JL_BR_JOURNALS_UPD()+');
644:
645: IF (process_mode = 'LOCK' ) THEN
646: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
647: arp_message.set_token ('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);
648:
649: -- open c1;
650: -- close c1;
651:

Line 660: UPDATE jl_br_journals_all j

656:
657:
658: --customer level update--
659: /*
660: UPDATE jl_br_journals_all j
661: SET personnel_id = (SELECT distinct m.customer_id
662: FROM ra_customer_merges m
663: WHERE j.personnel_id = m.duplicate_id
664: AND m.process_flag = 'N'

Line 681: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);

677: g_count := SQL%ROWCOUNT;
678: */
679:
680: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
681: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);
682: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
683: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
684:
685: l_count:=0;

Line 750: 'JL_BR_JOURNALS_ALL',

746: LAST_UPDATE_LOGIN,
747: LAST_UPDATE_DATE,
748: LAST_UPDATED_BY
749: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
750: 'JL_BR_JOURNALS_ALL',
751: MERGE_HEADER_ID_LIST(I),
752: PRIMARY_KEY1_LIST(I),
753: PRIMARY_KEY2_LIST(I),
754: PRIMARY_KEY3_LIST(I),

Line 779: UPDATE JL_BR_JOURNALS_ALL

775: END IF;
776:
777: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
778:
779: UPDATE JL_BR_JOURNALS_ALL
780: SET
781: PERSONNEL_ID=NUM_COL1_NEW_LIST(I)
782: ,JOURNAL_BALANCE_FLAG=VCHAR_COL1_NEW_LIST(I)
783: ,last_update_date = SYSDATE

Line 799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');

795: arp_message.set_name ('AR','AR_ROWS_UPDATED');
796: arp_message.set_token ('NUM_ROWS', to_char(l_count) );
797:
798: END IF ;
799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');
800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');

Line 803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');

799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');
800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');
804: RAISE;
805: END jl_br_journals_upd;
806:
807:

Line 805: END jl_br_journals_upd;

801: EXCEPTION
802: WHEN OTHERS THEN
803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');
804: RAISE;
805: END jl_br_journals_upd;
806:
807:
808: ----------------------------------------------------------------------------
809: -- PROCEDURE --

Line 983: FROM jl_br_journals jb,

979: jb.code_combination_id ccid,
980: jb.personnel_id venid,
981: SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)) bal,
982: jb.org_id org_id
983: FROM jl_br_journals jb,
984: gl_periods gp
985: WHERE application_id=222
986: AND journal_balance_flag='N'
987: AND jb.period_name = gp.period_name

Line 1019: from jl_br_journals_all

1015: r_per c_per%rowtype;
1016:
1017: /* cursor c_org is
1018: Select unique org_id
1019: from jl_br_journals_all
1020: where application_id=222; */
1021: Cursor c_org is -- bug 3563804
1022: Select org_id
1023: from ar_system_parameters_all

Line 1502: UPDATE jl_br_journals

1498: -- meaning that those journals have been acummulated to
1499: -- balaces
1500: -------------------------------------------------------
1501:
1502: UPDATE jl_br_journals
1503: SET journal_balance_flag = 'Y'
1504: WHERE application_id = 222
1505: AND set_of_books_id = r_bmb.sob
1506: AND code_combination_id = r_bmb.ccid

Line 1727: --jl_br_journals_upd (req_id,set_num,process_mode); -- bug 8362076 Commented the call as the journals table is not in use

1723: jl_br_pay_sch_upd (req_id,set_num,process_mode);
1724: jl_zz_tx_cus_cls_upd (req_id,set_num,process_mode);
1725: jl_zz_tx_exc_cus_upd (req_id,set_num,process_mode);
1726: jl_zz_tx_lgl_msg_upd (req_id,set_num,process_mode);
1727: --jl_br_journals_upd (req_id,set_num,process_mode); -- bug 8362076 Commented the call as the journals table is not in use
1728: --jl_br_balances_upd (req_id,set_num,process_mode); -- bug 8362076 Commented the call as the balances table is not in use
1729: arp_message.set_line ('JL_CMERGE.MERGE()-');
1730:
1731: END merge;