APPS.OKE_FUNDSOURCE_PVT dependencies on PA_AGREEMENTS_ALL

Line 242: where syn.synonym_name = 'PA_AGREEMENTS_ALL'

238: cursor c_length(b_owner varchar2) is
239: select col.data_length
240: from user_synonyms syn,
241: all_tab_columns col
242: where syn.synonym_name = 'PA_AGREEMENTS_ALL'
243: and col.owner = b_owner
244: and col.table_name = syn.table_name
245: AND col.column_name = 'AGREEMENT_NUM';
246:

Line 253: where table_name = 'PA_AGREEMENTS_ALL'

249: /* commnented out for bugfix 15926104
250: cursor c_length(b_owner varchar2) is
251: select data_length
252: from all_tab_columns
253: where table_name = 'PA_AGREEMENTS_ALL'
254: and owner = b_owner
255: and column_name = 'AGREEMENT_NUM';*/
256:
257: l_length NUMBER := 0;

Line 274: update pa_agreements_all

270: open c_length(l_table_owner);
271: fetch c_length into l_length;
272: close c_length;
273:
274: update pa_agreements_all
275: set pm_product_code = G_PRODUCT_CODE,
276: -- agreement_num = decode(p_num_update_flag, 'Y', substr(agreement_num, 0, 20-1-length(p_currency_code)) || '-' || p_currency_code,
277: -- 'N', agreement_num, agreement_num),
278: agreement_num = decode(p_num_update_flag, 'Y', substr(agreement_num, 0, l_length-1-length(p_currency_code)) || '-' || p_currency_code,

Line 775: from pa_agreements_all

771: ) is
772:
773: cursor c_agreement_id is
774: select 'x'
775: from pa_agreements_all
776: where agreement_id = p_agreement_id
777: and nvl(pm_product_code, '-99') <> G_PRODUCT_CODE;
778:
779: cursor c_master_project is

Line 903: from pa_agreements_all

899: ) is
900:
901: cursor c_agreement_id is
902: select 'x'
903: from pa_agreements_all
904: where agreement_id = p_agreement_id
905: FOR UPDATE OF agreement_id NOWAIT;
906:
907: l_dummy_value varchar2(1) := '?';

Line 3296: from pa_agreements_all

3292:
3293: cursor c_agreement (p_funding_source_id NUMBER,
3294: length NUMBER) is
3295: select pm_agreement_reference, org_id
3296: from pa_agreements_all
3297: where substr(pm_agreement_reference, (-1 * (length + 1)), length + 1) = '-' || TO_CHAR(p_funding_source_id)
3298: and pm_product_code = G_PRODUCT_CODE;
3299:
3300: l_agreement c_agreement%ROWTYPE;