The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
PRB.APPLICATION_ID,
PRB.AMB_CONTEXT_CODE,
PRB.PRODUCT_RULE_TYPE_CODE,
PRB.PRODUCT_RULE_CODE
FROM
XLA_PRODUCT_RULES_B PRB
WHERE PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
,'N'
,'Y'
,'') )
AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
,PRB.PRODUCT_RULE_TYPE_CODE)
AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
,'DEFAULT');
SELECT
PRB.APPLICATION_ID,
PRB.AMB_CONTEXT_CODE,
PRB.PRODUCT_RULE_TYPE_CODE,
PRB.PRODUCT_RULE_CODE
FROM
XLA_PRODUCT_RULES_B PRB
WHERE PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
,'N'
,'Y'
,'') )
AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
,PRB.PRODUCT_RULE_TYPE_CODE)
AND PRB.APPLICATION_ID = P_APPLICATION_ID
AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
,'DEFAULT');
SELECT
PRB.APPLICATION_ID,
PRB.AMB_CONTEXT_CODE,
PRB.PRODUCT_RULE_TYPE_CODE,
PRB.PRODUCT_RULE_CODE
FROM
XLA_PRODUCT_RULES_B PRB
WHERE PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
,'N'
,'Y'
,'') )
AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
,PRB.PRODUCT_RULE_TYPE_CODE)
AND PRB.APPLICATION_ID = P_APPLICATION_ID
AND PRB.PRODUCT_RULE_CODE = P_PRODUCT_RULE_CODE
AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
,'DEFAULT');
SELECT
PRB.APPLICATION_ID,
PRB.AMB_CONTEXT_CODE,
PRB.PRODUCT_RULE_TYPE_CODE,
PRB.PRODUCT_RULE_CODE
FROM
XLA_PRODUCT_RULES_B PRB,
XLA_GL_LEDGERS_V LE,
XLA_ACCTG_METHOD_RULES AMR,
XLA_LEDGER_RELATIONSHIPS_V LR
WHERE PRB.PRODUCT_RULE_TYPE_CODE = AMR.PRODUCT_RULE_TYPE_CODE
AND PRB.PRODUCT_RULE_CODE = AMR.PRODUCT_RULE_CODE
AND PRB.APPLICATION_ID = AMR.APPLICATION_ID
AND AMR.ACCOUNTING_METHOD_TYPE_CODE = LE.SLA_ACCOUNTING_METHOD_TYPE
AND AMR.ACCOUNTING_METHOD_CODE = LE.SLA_ACCOUNTING_METHOD_CODE
AND LE.LEDGER_ID = LR.LEDGER_ID
AND LR.PRIMARY_LEDGER_ID = P_LEDGER_ID
AND PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
,'N'
,'Y'
,'') )
AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
,PRB.PRODUCT_RULE_TYPE_CODE)
AND PRB.APPLICATION_ID = NVL(P_APPLICATION_ID
,PRB.APPLICATION_ID)
AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
,'DEFAULT');
SELECT
PRB.APPLICATION_ID,
PRB.AMB_CONTEXT_CODE,
PRB.PRODUCT_RULE_TYPE_CODE,
PRB.PRODUCT_RULE_CODE
FROM
XLA_PRODUCT_RULES_B PRB,
XLA_GL_LEDGERS_V LE,
XLA_ACCTG_METHOD_RULES AMR
WHERE PRB.PRODUCT_RULE_TYPE_CODE = AMR.PRODUCT_RULE_TYPE_CODE
AND PRB.PRODUCT_RULE_CODE = AMR.PRODUCT_RULE_CODE
AND PRB.APPLICATION_ID = AMR.APPLICATION_ID
AND AMR.ACCOUNTING_METHOD_TYPE_CODE = LE.SLA_ACCOUNTING_METHOD_TYPE
AND AMR.ACCOUNTING_METHOD_CODE = LE.SLA_ACCOUNTING_METHOD_CODE
AND LE.LEDGER_ID = P_LEDGER_ID
AND PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
,'N'
,'Y'
,'') )
AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
,PRB.PRODUCT_RULE_TYPE_CODE)
AND PRB.APPLICATION_ID = NVL(P_APPLICATION_ID
,PRB.APPLICATION_ID)
AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
,'DEFAULT');
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = 'R'
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = 'R'
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = 'R'
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = 'R'
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = 'R'
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
UPDATE
XLA_PRODUCT_RULES_B
SET
COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
WHERE APPLICATION_ID = L_APPLICATION_ID
AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
SELECT
LEDGER_CATEGORY_CODE
FROM
XLA_GL_LEDGERS_V
WHERE LEDGER_ID = P_LEDGER_ID;
CP_JLD_SELECT := ' ';
CP_JLD_SELECT := ' UNION
select app.application_name
,lk11.meaning amb_context_dsp
,err.amb_context_code
,err.product_rule_code
,null product_rule_name
,err.product_rule_type_code
,null product_rule_type_dsp
,err.line_definition_owner_code
,lk12.meaning line_definition_owner
,err.line_definition_code
,xld.name line_definition_name
,err.category_sequence_num
,err.message_category_code
,lk2.meaning message_category_dsp
,msg.message_number
,err.message_type_flag
,lk1.meaning message_type_dsp
,ect.event_class_code
,ect.name event_class_name
,ett.event_type_code
,ett.name event_type_name
,err.description_code
,dt.name description_name
,err.description_type_code
,lk5.meaning description_type_dsp
,err.extract_object_name
,err.extract_object_type_code
,null extract_object_type_dsp
,err.source_code
,st.name source_name
,err.source_type_code
,lk9.meaning source_type_dsp
,err.analytical_criterion_code
,act.name analytical_criterion_name
,err.analytical_criterion_type_code
,lk6.meaning analytical_criterion_type_dsp
,err.accounting_line_code
,acb.name accounting_line_name
,err.accounting_line_type_code
,lk7.meaning accounting_line_type_dsp
,err.mapping_set_code
,mst.name mapping_set_name
,err.segment_rule_code
,srt.name segment_rule_name
,err.segment_rule_type_code
,lk8.meaning segment_rule_type_dsp
,err.accounting_source_code
,err.mapping_group_code
,lk10.meaning mapping_group_dsp
,ast1.name accounting_source_name
,err.mpa_accounting_line_code
,malt.name mpa_accounting_line_name
,err.mpa_accounting_line_type_code
,lk13.meaning mpa_accounting_line_type_dsp
,msg.message_text ';
CP_JLD_SELECT := ' ';
CP_JLD_SELECT := ' ';
FUNCTION CP_JLD_SELECT_P RETURN VARCHAR2 IS
BEGIN
RETURN CP_JLD_SELECT;
END CP_JLD_SELECT_P;