51: null,
52: null,
53: null,
54: null,
55: nvl(fnd_global.user_id,-1),
56: sysdate,
57: nvl(fnd_global.user_id,-1),
58: sysdate,
59: nvl(fnd_global.user_id,-1));
53: null,
54: null,
55: nvl(fnd_global.user_id,-1),
56: sysdate,
57: nvl(fnd_global.user_id,-1),
58: sysdate,
59: nvl(fnd_global.user_id,-1));
60: End if;
61: END;
55: nvl(fnd_global.user_id,-1),
56: sysdate,
57: nvl(fnd_global.user_id,-1),
58: sysdate,
59: nvl(fnd_global.user_id,-1));
60: End if;
61: END;
62:
63: /****************************************************************/
120: p_party_product_type,
121: p_party_pricing_model,
122: p_party_fund_limit,
123: p_party_invest_limit,
124: nvl(fnd_global.user_id,-1),
125: sysdate,
126: nvl(fnd_global.user_id,-1),
127: sysdate,
128: nvl(fnd_global.user_id,-1));
122: p_party_fund_limit,
123: p_party_invest_limit,
124: nvl(fnd_global.user_id,-1),
125: sysdate,
126: nvl(fnd_global.user_id,-1),
127: sysdate,
128: nvl(fnd_global.user_id,-1));
129: End if;
130:
124: nvl(fnd_global.user_id,-1),
125: sysdate,
126: nvl(fnd_global.user_id,-1),
127: sysdate,
128: nvl(fnd_global.user_id,-1));
129: End if;
130:
131: END;
132:
176: PARTY_PRODUCT_TYPE = p_party_product_type,
177: PARTY_PRICING_MODEL = p_party_pricing_model,
178: PARTY_FUND_LIMIT_CODE = p_party_fund_limit,
179: PARTY_INVEST_LIMIT_CODE = p_party_invest_limit,
180: LAST_UPDATED_BY = nvl(fnd_global.user_id,-1),
181: LAST_UPDATE_DATE = sysdate,
182: LAST_UPDATE_LOGIN = nvl(fnd_global.user_id,-1)
183: Where cashpool_id = p_cashpool_id
184: and party_code = p_party_code
178: PARTY_FUND_LIMIT_CODE = p_party_fund_limit,
179: PARTY_INVEST_LIMIT_CODE = p_party_invest_limit,
180: LAST_UPDATED_BY = nvl(fnd_global.user_id,-1),
181: LAST_UPDATE_DATE = sysdate,
182: LAST_UPDATE_LOGIN = nvl(fnd_global.user_id,-1)
183: Where cashpool_id = p_cashpool_id
184: and party_code = p_party_code
185: and iac_portfolio is NULL;
186: END;
206: PARTY_PRODUCT_TYPE = p_party_product_type,
207: PARTY_PRICING_MODEL = p_party_pricing_model,
208: PARTY_FUND_LIMIT_CODE = p_party_fund_limit,
209: PARTY_INVEST_LIMIT_CODE = p_party_invest_limit,
210: LAST_UPDATED_BY = nvl(fnd_global.user_id,-1),
211: LAST_UPDATE_DATE = sysdate,
212: LAST_UPDATE_LOGIN = nvl(fnd_global.user_id,-1)
213: Where cashpool_id = p_cashpool_id
214: and party_code = p_party_code;
208: PARTY_FUND_LIMIT_CODE = p_party_fund_limit,
209: PARTY_INVEST_LIMIT_CODE = p_party_invest_limit,
210: LAST_UPDATED_BY = nvl(fnd_global.user_id,-1),
211: LAST_UPDATE_DATE = sysdate,
212: LAST_UPDATE_LOGIN = nvl(fnd_global.user_id,-1)
213: Where cashpool_id = p_cashpool_id
214: and party_code = p_party_code;
215: END;
216: