DBA Data[Home] [Help]

APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_SYSTEM_PARAMETERS

Line 2154: FROM jmf_gta_system_parameters_all s

2150: x_succ:=TRUE;
2151: BEGIN
2152: SELECT s.auto_batch_numbering_flag
2153: INTO l_batch_numbering_flag
2154: FROM jmf_gta_system_parameters_all s
2155: WHERE s.org_id=P_ORG_ID;
2156: EXCEPTION
2157: WHEN NO_DATA_FOUND THEN
2158: fnd_message.SET_NAME('JMF','JMF_GTA_SYS_CONFIG_MISSING');

Line 3297: l_currency_code JMF_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;

3293: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3294: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3295:
3296: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3297: l_currency_code JMF_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;
3298: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;
3299: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3300: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3301: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;

Line 3590: JMF_GTA_SYSTEM_PARAMETERS_ALL

3586: GT_CURRENCY_CODE
3587: INTO
3588: l_currency_code
3589: FROM
3590: JMF_GTA_SYSTEM_PARAMETERS_ALL
3591: WHERE
3592: org_id = p_org_id;
3593:
3594: EXCEPTION

Line 4290: jmf_gta_system_parameters

4286: inv_item_context_code
4287: ,inv_tax_attribute_column
4288: ,inv_model_attribute_column
4289: FROM
4290: jmf_gta_system_parameters
4291: WHERE
4292: org_id=l_org_id;
4293:
4294: