APPS.JL_BR_AR_LOG_VALIDATION dependencies on AR_SYSTEM_PARAMETERS

Line 59: l_ledger_id ar_system_parameters.set_of_books_id%TYPE;

55: l_validation_level NUMBER;
56: l_msg_count NUMBER;
57: l_msg_data VARCHAR2(2000);
58: l_return_status VARCHAR2(2000);
59: l_ledger_id ar_system_parameters.set_of_books_id%TYPE;
60: l_acct_balancing_segment ar_system_parameters.global_attribute1%TYPE;
61: l_ledger_info xle_businessinfo_grp.le_ledger_rec_type;
62: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
63: l_legal_entity_name xle_entity_profiles.name%TYPE;

Line 60: l_acct_balancing_segment ar_system_parameters.global_attribute1%TYPE;

56: l_msg_count NUMBER;
57: l_msg_data VARCHAR2(2000);
58: l_return_status VARCHAR2(2000);
59: l_ledger_id ar_system_parameters.set_of_books_id%TYPE;
60: l_acct_balancing_segment ar_system_parameters.global_attribute1%TYPE;
61: l_ledger_info xle_businessinfo_grp.le_ledger_rec_type;
62: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
63: l_legal_entity_name xle_entity_profiles.name%TYPE;
64: l_party_id hz_parties.party_id%TYPE;

Line 69: Cursor Comp_JLBRRVFD ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE

65: l_party_type hz_parties.party_type%TYPE;
66:
67:
68: -- Bug#8331293 Replaced SQL query with cursor
69: Cursor Comp_JLBRRVFD ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE
70: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE
71: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE
72: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)
73: IS

Line 70: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE

66:
67:
68: -- Bug#8331293 Replaced SQL query with cursor
69: Cursor Comp_JLBRRVFD ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE
70: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE
71: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE
72: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)
73: IS
74: Select etb.registration_number

Line 101: Cursor Comp_JLBRRCDB ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE

97: And ENTRY_SEQUENTIAL_NUMBER = cp_ent_seq_num
98: AND trunc(SYSDATE) between trunc(nvl(bsv.effective_from, SYSDATE))
99: and trunc(nvl(bsv.effective_to,SYSDATE)); --bug 9239401
100:
101: Cursor Comp_JLBRRCDB ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE
102: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE
103: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE
104: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)
105: IS

Line 102: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE

98: AND trunc(SYSDATE) between trunc(nvl(bsv.effective_from, SYSDATE))
99: and trunc(nvl(bsv.effective_to,SYSDATE)); --bug 9239401
100:
101: Cursor Comp_JLBRRCDB ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE
102: ,cp_lacct_balancing_segment ar_system_parameters.global_attribute1%TYPE
103: ,cp_file_control jl_br_ar_ret_interface_all.file_control%TYPE
104: ,cp_ent_seq_num jl_br_ar_ret_interface_all.ENTRY_SEQUENTIAL_NUMBER%TYPE)
105: IS
106: Select etb.registration_number

Line 423: -- from ar_system_parameters

419: ----------------------------------------------------------------------
420:
421: -----------------------------------------------------------
422: -- Retrieve the set_of_books_id and acct_balancing_segment
423: -- from ar_system_parameters
424: -----------------------------------------------------------
425: SELECT set_of_books_id,
426: global_attribute1
427: INTO l_ledger_id,

Line 429: FROM ar_system_parameters;

425: SELECT set_of_books_id,
426: global_attribute1
427: INTO l_ledger_id,
428: l_acct_balancing_segment
429: FROM ar_system_parameters;
430:
431: fnd_file.put_line(FND_FILE.LOG,'Legder Id : ' || l_ledger_id);
432: fnd_file.put_line(FND_FILE.LOG,'Balancing Segment : ' || l_acct_balancing_segment);
433: