APPS.AR_INVOICE_UTILS dependencies on FND_PROFILE

Line 11: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');

7:
8: /*Bug 5122918/4709987/3752043*/
9: pg_so_org_id NUMBER := to_number(oe_profile.value('SO_ORGANIZATION_ID'));
10:
11: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
12:
13:
14: PROCEDURE debug (
15: p_message IN VARCHAR2,

Line 923: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;

919: SELECT *
920: FROM ar_trx_header_gt gt
921: WHERE gt.doc_sequence_value IS NOT NULL;
922:
923: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;
924:
925: l_doc_seq_ret_stat NUMBER;
926: l_doc_sequence_id NUMBER;
927: l_doc_sequence_name VARCHAR2(50);

Line 4991: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;

4987: l_seq_err boolean := FALSE;
4988: l_trx_str VARCHAR2(2000);
4989: l_org_str VARCHAR2(30);
4990: l_trx_number ra_customer_trx.trx_number%type;
4991: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;
4992: BEGIN
4993: IF pg_debug = 'Y'
4994: THEN
4995: debug ('AR_INVOICE_UTILS.populate_doc_sequence (+)' );

Line 5296: l_so_id_flex_code fnd_profile_option_values.profile_option_value%type;

5292: PROCEDURE validate_item_kflex (
5293: x_errmsg OUT NOCOPY VARCHAR2,
5294: x_return_status OUT NOCOPY VARCHAR2) IS
5295:
5296: l_so_id_flex_code fnd_profile_option_values.profile_option_value%type;
5297: l_so_org_id fnd_profile_option_values.profile_option_value%type;
5298:
5299: CURSOR cItemFlex IS
5300: SELECT trx_header_id, trx_line_id,inventory_item_id, org_id

Line 5297: l_so_org_id fnd_profile_option_values.profile_option_value%type;

5293: x_errmsg OUT NOCOPY VARCHAR2,
5294: x_return_status OUT NOCOPY VARCHAR2) IS
5295:
5296: l_so_id_flex_code fnd_profile_option_values.profile_option_value%type;
5297: l_so_org_id fnd_profile_option_values.profile_option_value%type;
5298:
5299: CURSOR cItemFlex IS
5300: SELECT trx_header_id, trx_line_id,inventory_item_id, org_id
5301: FROM ar_trx_lines_gt