DBA Data[Home] [Help]

APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on FND_PROFILE

Line 1281: := fnd_profile.VALUE ('HXT_BATCH_SIZE');

1277: l_object_version_number NUMBER (9);
1278: l_batch_id NUMBER (15);
1279: l_count_timecards NUMBER (9);
1280: l_max_batches NUMBER
1281: := fnd_profile.VALUE ('HXT_BATCH_SIZE');
1282: -- l_max_batches NUMBER := fnd_profile.Value('OTC_BATCH_SIZE');
1283: l_batch_ref VARCHAR2 (30);
1284: l_batch_name VARCHAR2 (30);
1285: l_non_retro_batch_id NUMBER (15);

Line 1282: -- l_max_batches NUMBER := fnd_profile.Value('OTC_BATCH_SIZE');

1278: l_batch_id NUMBER (15);
1279: l_count_timecards NUMBER (9);
1280: l_max_batches NUMBER
1281: := fnd_profile.VALUE ('HXT_BATCH_SIZE');
1282: -- l_max_batches NUMBER := fnd_profile.Value('OTC_BATCH_SIZE');
1283: l_batch_ref VARCHAR2 (30);
1284: l_batch_name VARCHAR2 (30);
1285: l_non_retro_batch_id NUMBER (15);
1286: l_count_batch_lines NUMBER (9);

Line 3658: AND (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'BOTH')

3654: END IF;
3655:
3656: --
3657: IF ( (SQLERRM LIKE '%HXC%')
3658: AND (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'BOTH')
3659: )
3660: THEN
3661: hxc_generic_retrieval_utils.set_parent_statuses;
3662: hxc_generic_retrieval_pkg.update_transaction_status

Line 3675: ELSIF (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'OTLR')

3671: fnd_message.raise_error;
3672: ELSE
3673: p_no_otm := 'Y';
3674: END IF;
3675: ELSIF (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'OTLR')
3676: THEN
3677: hxc_generic_retrieval_utils.set_parent_statuses;
3678: --
3679: hxc_generic_retrieval_pkg.update_transaction_status