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_BALANCES_ALL

Line 814: -- JL_BR_BALANCES_ALL that refers to cust_account_id column of --

810: -- JL_BR_BALANCES_UPD --
811: -- --
812: -- DESCRIPTION --
813: -- Merge duplicate customer_id stored in column of --
814: -- JL_BR_BALANCES_ALL that refers to cust_account_id column of --
815: -- HZ_CUST_ACCOUNTS --
816: -- --
817: -- PURPOSE: --
818: -- Oracle Applications Rel 11.5 --

Line 837: FROM jl_br_balances_all

833:
834: /*
835: CURSOR c1 IS
836: SELECT SET_OF_BOOKS_ID
837: FROM jl_br_balances_all
838: WHERE (personnel_id) IN (SELECT unique m.duplicate_id
839: FROM ra_customer_merges m
840: WHERE m.process_flag = 'N'
841: AND m.request_id = req_id

Line 853: JL_BR_BALANCES_ALL.application_id%TYPE

849: INDEX BY BINARY_INTEGER;
850: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
851:
852: TYPE application_id_LIST_TYPE IS TABLE OF
853: JL_BR_BALANCES_ALL.application_id%TYPE
854: INDEX BY BINARY_INTEGER;
855: PRIMARY_KEY1_LIST application_id_LIST_TYPE;
856:
857: TYPE set_of_books_id_LIST_TYPE IS TABLE OF

Line 858: JL_BR_BALANCES_ALL.set_of_books_id%TYPE

854: INDEX BY BINARY_INTEGER;
855: PRIMARY_KEY1_LIST application_id_LIST_TYPE;
856:
857: TYPE set_of_books_id_LIST_TYPE IS TABLE OF
858: JL_BR_BALANCES_ALL.set_of_books_id%TYPE
859: INDEX BY BINARY_INTEGER;
860: PRIMARY_KEY2_LIST set_of_books_id_LIST_TYPE;
861:
862: TYPE period_set_name_LIST_TYPE IS TABLE OF

Line 863: JL_BR_BALANCES_ALL.period_set_name%TYPE

859: INDEX BY BINARY_INTEGER;
860: PRIMARY_KEY2_LIST set_of_books_id_LIST_TYPE;
861:
862: TYPE period_set_name_LIST_TYPE IS TABLE OF
863: JL_BR_BALANCES_ALL.period_set_name%TYPE
864: INDEX BY BINARY_INTEGER;
865: PRIMARY_KEY3_LIST period_set_name_LIST_TYPE;
866:
867: TYPE period_name_LIST_TYPE IS TABLE OF

Line 868: JL_BR_BALANCES_ALL.period_name%TYPE

864: INDEX BY BINARY_INTEGER;
865: PRIMARY_KEY3_LIST period_set_name_LIST_TYPE;
866:
867: TYPE period_name_LIST_TYPE IS TABLE OF
868: JL_BR_BALANCES_ALL.period_name%TYPE
869: INDEX BY BINARY_INTEGER;
870: PRIMARY_KEY4_LIST period_name_LIST_TYPE;
871:
872: TYPE code_combination_id_LIST_TYPE IS TABLE OF

Line 873: JL_BR_BALANCES_ALL.code_combination_id%TYPE

869: INDEX BY BINARY_INTEGER;
870: PRIMARY_KEY4_LIST period_name_LIST_TYPE;
871:
872: TYPE code_combination_id_LIST_TYPE IS TABLE OF
873: JL_BR_BALANCES_ALL.code_combination_id%TYPE
874: INDEX BY BINARY_INTEGER;
875: PRIMARY_KEY5_LIST code_combination_id_LIST_TYPE;
876:
877: TYPE personnel_id_LIST_TYPE IS TABLE OF

Line 878: JL_BR_BALANCES_ALL.personnel_id%TYPE

874: INDEX BY BINARY_INTEGER;
875: PRIMARY_KEY5_LIST code_combination_id_LIST_TYPE;
876:
877: TYPE personnel_id_LIST_TYPE IS TABLE OF
878: JL_BR_BALANCES_ALL.personnel_id%TYPE
879: INDEX BY BINARY_INTEGER;
880: PRIMARY_KEY6_LIST personnel_id_LIST_TYPE;
881:
882: NUM_COL1_ORIG_LIST personnel_id_LIST_TYPE;

Line 886: JL_BR_BALANCES_ALL.ending_balance%TYPE

882: NUM_COL1_ORIG_LIST personnel_id_LIST_TYPE;
883: NUM_COL1_NEW_LIST personnel_id_LIST_TYPE;
884:
885: TYPE ending_balance_LIST_TYPE IS TABLE OF
886: JL_BR_BALANCES_ALL.ending_balance%TYPE
887: INDEX BY BINARY_INTEGER;
888: NUM_COL2_ORIG_LIST ending_balance_LIST_TYPE;
889: NUM_COL2_NEW_LIST ending_balance_LIST_TYPE;
890:

Line 892: JL_BR_BALANCES_ALL.org_id%TYPE

888: NUM_COL2_ORIG_LIST ending_balance_LIST_TYPE;
889: NUM_COL2_NEW_LIST ending_balance_LIST_TYPE;
890:
891: TYPE org_id_LIST_TYPE IS TABLE OF
892: JL_BR_BALANCES_ALL.org_id%TYPE
893: INDEX BY BINARY_INTEGER;
894: NUM_COL3_ORIG_LIST org_id_LIST_TYPE;
895: NUM_COL3_NEW_LIST org_id_LIST_TYPE;
896:

Line 898: JL_BR_BALANCES_ALL.ending_balance_sign%TYPE

894: NUM_COL3_ORIG_LIST org_id_LIST_TYPE;
895: NUM_COL3_NEW_LIST org_id_LIST_TYPE;
896:
897: TYPE ending_balance_sign_LIST_TYPE IS TABLE OF
898: JL_BR_BALANCES_ALL.ending_balance_sign%TYPE
899: INDEX BY BINARY_INTEGER;
900: NUM_COL4_ORIG_LIST ending_balance_sign_LIST_TYPE;
901: NUM_COL4_NEW_LIST ending_balance_sign_LIST_TYPE;
902:

Line 904: JL_BR_BALANCES_ALL.period_year%TYPE

900: NUM_COL4_ORIG_LIST ending_balance_sign_LIST_TYPE;
901: NUM_COL4_NEW_LIST ending_balance_sign_LIST_TYPE;
902:
903: TYPE period_year_LIST_TYPE IS TABLE OF
904: JL_BR_BALANCES_ALL.period_year%TYPE
905: INDEX BY BINARY_INTEGER;
906: NUM_COL5_ORIG_LIST period_year_LIST_TYPE;
907: NUM_COL5_NEW_LIST period_year_LIST_TYPE;
908:

Line 910: JL_BR_BALANCES_ALL.period_num%TYPE

906: NUM_COL5_ORIG_LIST period_year_LIST_TYPE;
907: NUM_COL5_NEW_LIST period_year_LIST_TYPE;
908:
909: TYPE period_num_LIST_TYPE IS TABLE OF
910: JL_BR_BALANCES_ALL.period_num%TYPE
911: INDEX BY BINARY_INTEGER;
912: NUM_COL6_ORIG_LIST period_num_LIST_TYPE;
913: NUM_COL6_NEW_LIST period_num_LIST_TYPE;
914:

Line 932: FROM JL_BR_BALANCES_ALL yt,

928: ,yt.org_id
929: ,yt.ending_balance_sign
930: ,yt.period_year
931: ,yt.period_num
932: FROM JL_BR_BALANCES_ALL yt,
933: ra_customer_merges m
934: WHERE (yt.personnel_id = m.duplicate_id)
935: AND m.process_flag = 'N'
936: AND m.request_id = req_id

Line 1047: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);

1043:
1044: x_profile_org:=fnd_profile.value ('ORG_ID');
1045:
1046: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1047: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1049:
1050: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1051:

Line 1532: arp_message.set_token ('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);

1528: arp_message.set_line ('JL_CMERGE.JL_BR_BALANCES_UPD()+');
1529:
1530: IF (process_mode = 'LOCK' ) THEN
1531: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
1532: arp_message.set_token ('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1533:
1534: open merged_records;
1535: close merged_records;
1536:

Line 1541: delete jl_br_balances_all

1537: ELSE
1538: --customer level update--
1539:
1540: /*
1541: delete jl_br_balances_all
1542: where (personnel_id) IN (SELECT unique m.duplicate_id
1543: FROM ra_customer_merges m
1544: WHERE m.process_flag = 'N'
1545: AND m.request_id = req_id

Line 1555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);

1551: */
1552: -- Replaced with new logic that will generate log file.
1553:
1554: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1556: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1557: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1558:
1559: l_count:=0;

Line 1625: 'JL_BR_BALANCES_ALL',

1621: LAST_UPDATE_DATE,
1622: LAST_UPDATED_BY
1623: ) VALUES (
1624: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1625: 'JL_BR_BALANCES_ALL',
1626: MERGE_HEADER_ID_LIST(I),
1627: PRIMARY_KEY1_LIST(I),
1628: PRIMARY_KEY2_LIST(I),
1629: PRIMARY_KEY3_LIST(I),

Line 1656: DELETE JL_BR_BALANCES_ALL

1652:
1653: END IF;
1654:
1655: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1656: DELETE JL_BR_BALANCES_ALL
1657: WHERE application_id=PRIMARY_KEY1_LIST(I)
1658: AND set_of_books_id=PRIMARY_KEY2_LIST(I)
1659: AND period_set_name=PRIMARY_KEY3_LIST(I)
1660: AND period_name=PRIMARY_KEY4_LIST(I)