DBA Data[Home] [Help]

APPS.FV_GEN_ARTRX_REIMB_PROC dependencies on FND_FLEX_EXT

Line 815: l_agreement_rev_segments FND_FLEX_EXT.SEGMENTARRAY;

811:
812: l_segment4 VARCHAR2(25);
813: l_segment5 VARCHAR2(25);
814: l_ccid NUMBER;
815: l_agreement_rev_segments FND_FLEX_EXT.SEGMENTARRAY;
816: l_var NUMBER;
817: l_concat_segs VARCHAR2(500);
818: l_module VARCHAR2(100) := g_module_name||' get_ccid';
819: l_rev_nat_acc_sql VARCHAR2(400);

Line 875: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(

871: EXECUTE IMMEDIATE l_rev_nat_acc_sql into l_rev_nat_acc_tt USING p_trx_type_id, g_coa_id;
872:
873: log(C_STATE_LEVEL, l_module, 'l_rev_nat_acc_tt: '||l_rev_nat_acc_tt);
874:
875: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(
876: APPLICATION_SHORT_NAME => 'SQLGL',
877: KEY_FLEX_CODE => 'GL#',
878: STRUCTURE_NUMBER => g_coa_id,
879: COMBINATION_ID => l_agreement_rev_ccid,

Line 892: l_concat_segs:= fnd_flex_ext.concatenate_segments(n_segments =>l_num_segments,

888: ---Assign the natural account segment value of the transaction type Rev acc to
889: -- the ccid for the reimbursable agreement
890: l_agreement_rev_segments(l_nat_acct_seg_num) := l_rev_nat_acc_tt;
891: Begin
892: l_concat_segs:= fnd_flex_ext.concatenate_segments(n_segments =>l_num_segments,
893: segments =>l_agreement_rev_segments,
894: delimiter =>'.');
895:
896:

Line 909: l_ccid:=fnd_flex_ext.get_ccid( APPLICATION_SHORT_NAME => 'SQLGL',

905: log(C_STATE_LEVEL, l_module, 'CCID already existing: ' || l_ccid);
906:
907: EXCEPTION
908: when no_data_found then
909: l_ccid:=fnd_flex_ext.get_ccid( APPLICATION_SHORT_NAME => 'SQLGL',
910: KEY_FLEX_CODE => 'GL#',
911: STRUCTURE_NUMBER => g_coa_id,
912: validation_date => SYSDATE,
913: concatenated_segments =>l_concat_segs);