[Home] [Help]
128:
129: function get_PricingArrangementBase(p_clause_type VARCHAR2) return varchar2 IS
130: l_clause_exists varchar2(1);
131: CURSOR csr_clause_exists(clause_t VARCHAR2) IS
132: SELECT 'Y' FROM dual
133: WHERE EXISTS (SELECT 1 FROM okc_k_articles_b kartb, okc_articles_all art
134: WHERE kartb.sav_sae_id = art.article_id
135: AND article_number = clause_t);
136: begin
671: execute immediate l_sql into clob_addr using p_line_location_id, p_draft_id,l_attr_grp_id ;
672: exception
673: when others then
674: select '' into clob_addr
675: from dual;
676: end;
677: end if;
678: return(clob_addr);
679: end get_shipaddressxml_pvt;
930: Decode(p_old_value,NULL,Decode(p_new_value,NULL,'No Change','New value '''||p_new_value||''' Added'),
931: p_new_value,'No Change',
932: Decode(p_new_value,NULL,'value '''||p_old_value||''' Deleted','Value modified from '''||p_old_value||
933: ''' to '''||p_new_value||'''')) ChangeText
934: FROM dual;
935:
936: l_previous_value VARCHAR2(4000);
937: l_mod_value VARCHAR2(4000);
938: l_change_flag VARCHAR2(50);
1057: AND flv.ID_FLEX_CODE = 'GL#' AND flv.ID_FLEX_NUM = glc.CHART_OF_ACCOUNTS_ID ;
1058:
1059:
1060: CURSOR c_otheramounts IS
1061: select 'Firm Price','Target Price','Funded Amount','Award Fee','Base Price','Celing Price','Estimated Cost','Fixed Fee','Target Cost' AmountType from dual;
1062:
1063: l_previous_value VARCHAR2(4000);
1064: l_mod_value VARCHAR2(4000);
1065: l_change_flag VARCHAR2(50);
2513: into l_attr_grp_id,
2514: l_addr_val_col_name,
2515: l_addr_typ_col_name,
2516: l_contacts_col_name
2517: FROM dual;
2518:
2519: if l_addr_val_col_name is not null AND l_addr_typ_col_name IS NOT NULL then
2520:
2521: CASE p_diff_type
2824:
2825: BEGIN
2826: SELECT 'Y'
2827: INTO v_vendor_change_flag
2828: FROM dual
2829: WHERE EXISTS (SELECT 1 FROM PO_ENTITY_DIFFERENCES
2830: WHERE MOD_DOC_PK1_VAL = DOCUMENTID AND MOD_DOC_PK2_VAL = DRAFTID
2831: AND DIFF_ID IN (SELECT DISTINCT DIFF_CONFIG_ID
2832: FROM po_diff_config