APPS.AR_INVOICE_UTILS dependencies on FND_PROFILE_OPTION_VALUES

Line 930: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;

926: SELECT *
927: FROM ar_trx_header_gt gt
928: WHERE gt.doc_sequence_value IS NOT NULL;
929:
930: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;
931:
932: l_doc_seq_ret_stat NUMBER;
933: l_doc_sequence_id NUMBER;
934: l_doc_sequence_name VARCHAR2(50);

Line 5118: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;

5114: l_seq_err boolean := FALSE;
5115: l_trx_str VARCHAR2(2000);
5116: l_org_str VARCHAR2(30);
5117: l_trx_number ra_customer_trx.trx_number%type;
5118: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;
5119: BEGIN
5120: IF pg_debug = 'Y'
5121: THEN
5122: debug ('AR_INVOICE_UTILS.populate_doc_sequence (+)' );

Line 5424: l_so_id_flex_code fnd_profile_option_values.profile_option_value%type;

5420: PROCEDURE validate_item_kflex (
5421: x_errmsg OUT NOCOPY VARCHAR2,
5422: x_return_status OUT NOCOPY VARCHAR2) IS
5423:
5424: l_so_id_flex_code fnd_profile_option_values.profile_option_value%type;
5425: l_so_org_id fnd_profile_option_values.profile_option_value%type;
5426:
5427: CURSOR cItemFlex IS
5428: SELECT trx_header_id, trx_line_id,inventory_item_id, org_id

Line 5425: l_so_org_id fnd_profile_option_values.profile_option_value%type;

5421: x_errmsg OUT NOCOPY VARCHAR2,
5422: x_return_status OUT NOCOPY VARCHAR2) IS
5423:
5424: l_so_id_flex_code fnd_profile_option_values.profile_option_value%type;
5425: l_so_org_id fnd_profile_option_values.profile_option_value%type;
5426:
5427: CURSOR cItemFlex IS
5428: SELECT trx_header_id, trx_line_id,inventory_item_id, org_id
5429: FROM ar_trx_lines_gt