DBA Data[Home] [Help]

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 38: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,

34: p_bookkeeping_type VARCHAR2,
35: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
36: p_accounting_segment_type VARCHAR2,
37: p_coa_mapping_id VARCHAR2,
38: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
39: p_agglutination_code_source VARCHAR2,
40: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,
41: p_journal_for_rtf NUMBER,
42: p_hash_code VARCHAR2, -- auxillary book

Line 40: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,

36: p_accounting_segment_type VARCHAR2,
37: p_coa_mapping_id VARCHAR2,
38: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
39: p_agglutination_code_source VARCHAR2,
40: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,
41: p_journal_for_rtf NUMBER,
42: p_hash_code VARCHAR2, -- auxillary book
43: p_acct_stmt_ident VARCHAR2,
44: p_acct_stmt_header VARCHAR2,

Line 223: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,

219: p_bookkeeping_type VARCHAR2,
220: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
221: p_accounting_segment_type VARCHAR2,
222: p_coa_mapping_id VARCHAR2,
223: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
224: p_agglutination_code_source VARCHAR2,
225: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,
226: p_journal_for_rtf NUMBER,
227: p_hash_code VARCHAR2, -- auxillary book

Line 225: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,

221: p_accounting_segment_type VARCHAR2,
222: p_coa_mapping_id VARCHAR2,
223: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
224: p_agglutination_code_source VARCHAR2,
225: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,
226: p_journal_for_rtf NUMBER,
227: p_hash_code VARCHAR2, -- auxillary book
228: p_acct_stmt_ident VARCHAR2,
229: p_acct_stmt_header VARCHAR2,

Line 794: FROM fnd_concurrent_requests

790: IF p_balance_statement_request_id is not null THEN
791:
792: SELECT argument7 -- balancesheet report_id
793: INTO g_balance_statement_report_id
794: FROM fnd_concurrent_requests
795: WHERE request_id = p_balance_statement_request_id;
796: END IF;
797:
798: EXCEPTION

Line 812: FROM fnd_concurrent_requests

808: BEGIN
809: IF p_income_statement_request_id IS NOT NULL THEN
810: SELECT argument7 --Income Statement report_id
811: INTO g_income_statement_report_id
812: FROM fnd_concurrent_requests
813: WHERE request_id = p_income_statement_request_id;
814: END IF;
815:
816: EXCEPTION

Line 858: FROM fnd_concurrent_requests req,

854: BEGIN
855: SELECT amount_type
856: INTO l_fsg_output_check
857: FROM (SELECT r2.*
858: FROM fnd_concurrent_requests req,
859: rg_reports r1,
860: rg_report_axes_v r2
861: WHERE req.request_id = g_balance_statement_request_id
862: AND r1.report_id = req.argument7 --arguement7 in fnd_concurrent_requests holds the report id

Line 862: AND r1.report_id = req.argument7 --arguement7 in fnd_concurrent_requests holds the report id

858: FROM fnd_concurrent_requests req,
859: rg_reports r1,
860: rg_report_axes_v r2
861: WHERE req.request_id = g_balance_statement_request_id
862: AND r1.report_id = req.argument7 --arguement7 in fnd_concurrent_requests holds the report id
863: AND r1.column_set_id = r2.axis_set_id
864: ORDER BY r2.sequence)
865: WHERE ROWNUM = 1;
866:

Line 892: FROM fnd_concurrent_requests req,

888:
889: SELECT amount_type
890: INTO l_fsg_output_check
891: FROM (SELECT r2.*
892: FROM fnd_concurrent_requests req,
893: rg_reports r1,
894: rg_report_axes_v r2
895: WHERE req.request_id = g_income_statement_request_id
896: AND r1.report_id = req.argument7 --arguement7 in fnd_concurrent_requests holds the report id

Line 896: AND r1.report_id = req.argument7 --arguement7 in fnd_concurrent_requests holds the report id

892: FROM fnd_concurrent_requests req,
893: rg_reports r1,
894: rg_report_axes_v r2
895: WHERE req.request_id = g_income_statement_request_id
896: AND r1.report_id = req.argument7 --arguement7 in fnd_concurrent_requests holds the report id
897: AND r1.column_set_id = r2.axis_set_id
898: ORDER BY r2.sequence)
899: WHERE ROWNUM = 1;
900:

Line 8525: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,

8521: p_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
8522: p_participant_type_dummy JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
8523: p_accounting_segment_type VARCHAR2,
8524: p_coa_mapping_id VARCHAR2,
8525: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
8526: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,
8527: p_agglutination_code_source VARCHAR2,
8528: p_journal_for_rtf NUMBER,
8529: p_acct_stmt_ident VARCHAR2,

Line 8526: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,

8522: p_participant_type_dummy JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE,
8523: p_accounting_segment_type VARCHAR2,
8524: p_coa_mapping_id VARCHAR2,
8525: p_balance_statement_request_id fnd_concurrent_requests.request_id%TYPE,
8526: p_income_statement_request_id fnd_concurrent_requests.request_id%TYPE,
8527: p_agglutination_code_source VARCHAR2,
8528: p_journal_for_rtf NUMBER,
8529: p_acct_stmt_ident VARCHAR2,
8530: p_acct_stmt_ident_dummy VARCHAR2,