APPS.OKE_FUNDSOURCE_PVT dependencies on PA_AGREEMENTS_ALL

Line 239: where table_name = 'PA_AGREEMENTS_ALL'

235: ) is
236: cursor c_length(b_owner varchar2) is
237: select data_length
238: from all_tab_columns
239: where table_name = 'PA_AGREEMENTS_ALL'
240: and owner = b_owner
241: and column_name = 'AGREEMENT_NUM';
242:
243: l_length NUMBER := 0;

Line 260: update pa_agreements_all

256: open c_length(l_table_owner);
257: fetch c_length into l_length;
258: close c_length;
259:
260: update pa_agreements_all
261: set pm_product_code = G_PRODUCT_CODE,
262: -- agreement_num = decode(p_num_update_flag, 'Y', substr(agreement_num, 0, 20-1-length(p_currency_code)) || '-' || p_currency_code,
263: -- 'N', agreement_num, agreement_num),
264: agreement_num = decode(p_num_update_flag, 'Y', substr(agreement_num, 0, l_length-1-length(p_currency_code)) || '-' || p_currency_code,

Line 761: from pa_agreements_all

757: ) is
758:
759: cursor c_agreement_id is
760: select 'x'
761: from pa_agreements_all
762: where agreement_id = p_agreement_id
763: and nvl(pm_product_code, '-99') <> G_PRODUCT_CODE;
764:
765: cursor c_master_project is

Line 889: from pa_agreements_all

885: ) is
886:
887: cursor c_agreement_id is
888: select 'x'
889: from pa_agreements_all
890: where agreement_id = p_agreement_id
891: FOR UPDATE OF agreement_id NOWAIT;
892:
893: l_dummy_value varchar2(1) := '?';

Line 3132: from pa_agreements_all

3128:
3129: cursor c_agreement (p_funding_source_id NUMBER,
3130: length NUMBER) is
3131: select pm_agreement_reference, org_id
3132: from pa_agreements_all
3133: where substr(pm_agreement_reference, (-1 * (length + 1)), length + 1) = '-' || TO_CHAR(p_funding_source_id)
3134: and pm_product_code = G_PRODUCT_CODE;
3135:
3136: l_agreement c_agreement%ROWTYPE;