DBA Data[Home] [Help]

APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on XDO_TEMPLATES_B

Line 11332: l_template_type_code xdo_templates_b.template_type_code%type := null;

11328: PRAGMA AUTONOMOUS_TRANSACTION;
11329:
11330: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME|| '.lock_pmt_entity';
11331: l_conc_request_id NUMBER;
11332: l_template_type_code xdo_templates_b.template_type_code%type := null;
11333: l_default_output_type xdo_templates_b.default_output_type%type := null;
11334:
11335: BEGIN
11336:

Line 11333: l_default_output_type xdo_templates_b.default_output_type%type := null;

11329:
11330: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME|| '.lock_pmt_entity';
11331: l_conc_request_id NUMBER;
11332: l_template_type_code xdo_templates_b.template_type_code%type := null;
11333: l_default_output_type xdo_templates_b.default_output_type%type := null;
11334:
11335: BEGIN
11336:
11337: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 11409: XDO_TEMPLATES_B temp

11405: INTO l_template_type_code, l_default_output_type
11406: FROM iby_pay_instructions_all ins,
11407: iby_payment_profiles pp,
11408: iby_formats_b format,
11409: XDO_TEMPLATES_B temp
11410: WHERE ins.payment_instruction_id = p_object_id
11411: AND ins.payment_profile_id = pp.payment_profile_id
11412: AND format.FORMAT_CODE = pp.PAYMENT_FORMAT_CODE
11413: AND format.FORMAT_TEMPLATE_CODE = temp.template_code;