APPS.CSI_T_TXN_PARTIES_PVT dependencies on DBMS_SQL

Line 2238: l_pty_acct_cur_id := dbms_sql.open_cursor;

2234: ' attribute13, attribute14, attribute15, object_version_number '||
2235: 'from csi_t_party_accounts '||
2236: 'where txn_party_detail_id = :party_dtl_id';
2237:
2238: l_pty_acct_cur_id := dbms_sql.open_cursor;
2239:
2240: dbms_sql.parse(l_pty_acct_cur_id, l_select_stmt , dbms_sql.native);
2241:
2242: dbms_sql.bind_variable(l_pty_acct_cur_id, 'party_dtl_id', p_party_dtl_id);

Line 2240: dbms_sql.parse(l_pty_acct_cur_id, l_select_stmt , dbms_sql.native);

2236: 'where txn_party_detail_id = :party_dtl_id';
2237:
2238: l_pty_acct_cur_id := dbms_sql.open_cursor;
2239:
2240: dbms_sql.parse(l_pty_acct_cur_id, l_select_stmt , dbms_sql.native);
2241:
2242: dbms_sql.bind_variable(l_pty_acct_cur_id, 'party_dtl_id', p_party_dtl_id);
2243:
2244: dbms_sql.define_column(l_pty_acct_cur_id,1,

Line 2242: dbms_sql.bind_variable(l_pty_acct_cur_id, 'party_dtl_id', p_party_dtl_id);

2238: l_pty_acct_cur_id := dbms_sql.open_cursor;
2239:
2240: dbms_sql.parse(l_pty_acct_cur_id, l_select_stmt , dbms_sql.native);
2241:
2242: dbms_sql.bind_variable(l_pty_acct_cur_id, 'party_dtl_id', p_party_dtl_id);
2243:
2244: dbms_sql.define_column(l_pty_acct_cur_id,1,
2245: l_pty_acct_rec.txn_account_detail_id);
2246: dbms_sql.define_column(l_pty_acct_cur_id,2,

Line 2244: dbms_sql.define_column(l_pty_acct_cur_id,1,

2240: dbms_sql.parse(l_pty_acct_cur_id, l_select_stmt , dbms_sql.native);
2241:
2242: dbms_sql.bind_variable(l_pty_acct_cur_id, 'party_dtl_id', p_party_dtl_id);
2243:
2244: dbms_sql.define_column(l_pty_acct_cur_id,1,
2245: l_pty_acct_rec.txn_account_detail_id);
2246: dbms_sql.define_column(l_pty_acct_cur_id,2,
2247: l_pty_acct_rec.txn_party_detail_id);
2248: dbms_sql.define_column(l_pty_acct_cur_id,3,

Line 2246: dbms_sql.define_column(l_pty_acct_cur_id,2,

2242: dbms_sql.bind_variable(l_pty_acct_cur_id, 'party_dtl_id', p_party_dtl_id);
2243:
2244: dbms_sql.define_column(l_pty_acct_cur_id,1,
2245: l_pty_acct_rec.txn_account_detail_id);
2246: dbms_sql.define_column(l_pty_acct_cur_id,2,
2247: l_pty_acct_rec.txn_party_detail_id);
2248: dbms_sql.define_column(l_pty_acct_cur_id,3,
2249: l_pty_acct_rec.ip_account_id);
2250: dbms_sql.define_column(l_pty_acct_cur_id,4,

Line 2248: dbms_sql.define_column(l_pty_acct_cur_id,3,

2244: dbms_sql.define_column(l_pty_acct_cur_id,1,
2245: l_pty_acct_rec.txn_account_detail_id);
2246: dbms_sql.define_column(l_pty_acct_cur_id,2,
2247: l_pty_acct_rec.txn_party_detail_id);
2248: dbms_sql.define_column(l_pty_acct_cur_id,3,
2249: l_pty_acct_rec.ip_account_id);
2250: dbms_sql.define_column(l_pty_acct_cur_id,4,
2251: l_pty_acct_rec.account_id);
2252: dbms_sql.define_column(l_pty_acct_cur_id,5,

Line 2250: dbms_sql.define_column(l_pty_acct_cur_id,4,

2246: dbms_sql.define_column(l_pty_acct_cur_id,2,
2247: l_pty_acct_rec.txn_party_detail_id);
2248: dbms_sql.define_column(l_pty_acct_cur_id,3,
2249: l_pty_acct_rec.ip_account_id);
2250: dbms_sql.define_column(l_pty_acct_cur_id,4,
2251: l_pty_acct_rec.account_id);
2252: dbms_sql.define_column(l_pty_acct_cur_id,5,
2253: l_pty_acct_rec.relationship_type_code,30);
2254: dbms_sql.define_column(l_pty_acct_cur_id,6,

Line 2252: dbms_sql.define_column(l_pty_acct_cur_id,5,

2248: dbms_sql.define_column(l_pty_acct_cur_id,3,
2249: l_pty_acct_rec.ip_account_id);
2250: dbms_sql.define_column(l_pty_acct_cur_id,4,
2251: l_pty_acct_rec.account_id);
2252: dbms_sql.define_column(l_pty_acct_cur_id,5,
2253: l_pty_acct_rec.relationship_type_code,30);
2254: dbms_sql.define_column(l_pty_acct_cur_id,6,
2255: l_pty_acct_rec.bill_to_address_id);
2256: dbms_sql.define_column(l_pty_acct_cur_id,7,

Line 2254: dbms_sql.define_column(l_pty_acct_cur_id,6,

2250: dbms_sql.define_column(l_pty_acct_cur_id,4,
2251: l_pty_acct_rec.account_id);
2252: dbms_sql.define_column(l_pty_acct_cur_id,5,
2253: l_pty_acct_rec.relationship_type_code,30);
2254: dbms_sql.define_column(l_pty_acct_cur_id,6,
2255: l_pty_acct_rec.bill_to_address_id);
2256: dbms_sql.define_column(l_pty_acct_cur_id,7,
2257: l_pty_acct_rec.ship_to_address_id);
2258: dbms_sql.define_column(l_pty_acct_cur_id,8,

Line 2256: dbms_sql.define_column(l_pty_acct_cur_id,7,

2252: dbms_sql.define_column(l_pty_acct_cur_id,5,
2253: l_pty_acct_rec.relationship_type_code,30);
2254: dbms_sql.define_column(l_pty_acct_cur_id,6,
2255: l_pty_acct_rec.bill_to_address_id);
2256: dbms_sql.define_column(l_pty_acct_cur_id,7,
2257: l_pty_acct_rec.ship_to_address_id);
2258: dbms_sql.define_column(l_pty_acct_cur_id,8,
2259: l_pty_acct_rec.active_start_date);
2260: dbms_sql.define_column(l_pty_acct_cur_id,9,

Line 2258: dbms_sql.define_column(l_pty_acct_cur_id,8,

2254: dbms_sql.define_column(l_pty_acct_cur_id,6,
2255: l_pty_acct_rec.bill_to_address_id);
2256: dbms_sql.define_column(l_pty_acct_cur_id,7,
2257: l_pty_acct_rec.ship_to_address_id);
2258: dbms_sql.define_column(l_pty_acct_cur_id,8,
2259: l_pty_acct_rec.active_start_date);
2260: dbms_sql.define_column(l_pty_acct_cur_id,9,
2261: l_pty_acct_rec.active_end_date);
2262: dbms_sql.define_column(l_pty_acct_cur_id,10,

Line 2260: dbms_sql.define_column(l_pty_acct_cur_id,9,

2256: dbms_sql.define_column(l_pty_acct_cur_id,7,
2257: l_pty_acct_rec.ship_to_address_id);
2258: dbms_sql.define_column(l_pty_acct_cur_id,8,
2259: l_pty_acct_rec.active_start_date);
2260: dbms_sql.define_column(l_pty_acct_cur_id,9,
2261: l_pty_acct_rec.active_end_date);
2262: dbms_sql.define_column(l_pty_acct_cur_id,10,
2263: l_pty_acct_rec.preserve_detail_flag, 1);
2264: dbms_sql.define_column(l_pty_acct_cur_id,11,

Line 2262: dbms_sql.define_column(l_pty_acct_cur_id,10,

2258: dbms_sql.define_column(l_pty_acct_cur_id,8,
2259: l_pty_acct_rec.active_start_date);
2260: dbms_sql.define_column(l_pty_acct_cur_id,9,
2261: l_pty_acct_rec.active_end_date);
2262: dbms_sql.define_column(l_pty_acct_cur_id,10,
2263: l_pty_acct_rec.preserve_detail_flag, 1);
2264: dbms_sql.define_column(l_pty_acct_cur_id,11,
2265: l_pty_acct_rec.context,30);
2266: dbms_sql.define_column(l_pty_acct_cur_id,12,

Line 2264: dbms_sql.define_column(l_pty_acct_cur_id,11,

2260: dbms_sql.define_column(l_pty_acct_cur_id,9,
2261: l_pty_acct_rec.active_end_date);
2262: dbms_sql.define_column(l_pty_acct_cur_id,10,
2263: l_pty_acct_rec.preserve_detail_flag, 1);
2264: dbms_sql.define_column(l_pty_acct_cur_id,11,
2265: l_pty_acct_rec.context,30);
2266: dbms_sql.define_column(l_pty_acct_cur_id,12,
2267: l_pty_acct_rec.attribute1,150);
2268: dbms_sql.define_column(l_pty_acct_cur_id,13,

Line 2266: dbms_sql.define_column(l_pty_acct_cur_id,12,

2262: dbms_sql.define_column(l_pty_acct_cur_id,10,
2263: l_pty_acct_rec.preserve_detail_flag, 1);
2264: dbms_sql.define_column(l_pty_acct_cur_id,11,
2265: l_pty_acct_rec.context,30);
2266: dbms_sql.define_column(l_pty_acct_cur_id,12,
2267: l_pty_acct_rec.attribute1,150);
2268: dbms_sql.define_column(l_pty_acct_cur_id,13,
2269: l_pty_acct_rec.attribute2,150);
2270: dbms_sql.define_column(l_pty_acct_cur_id,14,

Line 2268: dbms_sql.define_column(l_pty_acct_cur_id,13,

2264: dbms_sql.define_column(l_pty_acct_cur_id,11,
2265: l_pty_acct_rec.context,30);
2266: dbms_sql.define_column(l_pty_acct_cur_id,12,
2267: l_pty_acct_rec.attribute1,150);
2268: dbms_sql.define_column(l_pty_acct_cur_id,13,
2269: l_pty_acct_rec.attribute2,150);
2270: dbms_sql.define_column(l_pty_acct_cur_id,14,
2271: l_pty_acct_rec.attribute3,150);
2272: dbms_sql.define_column(l_pty_acct_cur_id,15,

Line 2270: dbms_sql.define_column(l_pty_acct_cur_id,14,

2266: dbms_sql.define_column(l_pty_acct_cur_id,12,
2267: l_pty_acct_rec.attribute1,150);
2268: dbms_sql.define_column(l_pty_acct_cur_id,13,
2269: l_pty_acct_rec.attribute2,150);
2270: dbms_sql.define_column(l_pty_acct_cur_id,14,
2271: l_pty_acct_rec.attribute3,150);
2272: dbms_sql.define_column(l_pty_acct_cur_id,15,
2273: l_pty_acct_rec.attribute4,150);
2274: dbms_sql.define_column(l_pty_acct_cur_id,16,

Line 2272: dbms_sql.define_column(l_pty_acct_cur_id,15,

2268: dbms_sql.define_column(l_pty_acct_cur_id,13,
2269: l_pty_acct_rec.attribute2,150);
2270: dbms_sql.define_column(l_pty_acct_cur_id,14,
2271: l_pty_acct_rec.attribute3,150);
2272: dbms_sql.define_column(l_pty_acct_cur_id,15,
2273: l_pty_acct_rec.attribute4,150);
2274: dbms_sql.define_column(l_pty_acct_cur_id,16,
2275: l_pty_acct_rec.attribute5,150);
2276: dbms_sql.define_column(l_pty_acct_cur_id,17,

Line 2274: dbms_sql.define_column(l_pty_acct_cur_id,16,

2270: dbms_sql.define_column(l_pty_acct_cur_id,14,
2271: l_pty_acct_rec.attribute3,150);
2272: dbms_sql.define_column(l_pty_acct_cur_id,15,
2273: l_pty_acct_rec.attribute4,150);
2274: dbms_sql.define_column(l_pty_acct_cur_id,16,
2275: l_pty_acct_rec.attribute5,150);
2276: dbms_sql.define_column(l_pty_acct_cur_id,17,
2277: l_pty_acct_rec.attribute6,150);
2278: dbms_sql.define_column(l_pty_acct_cur_id,18,

Line 2276: dbms_sql.define_column(l_pty_acct_cur_id,17,

2272: dbms_sql.define_column(l_pty_acct_cur_id,15,
2273: l_pty_acct_rec.attribute4,150);
2274: dbms_sql.define_column(l_pty_acct_cur_id,16,
2275: l_pty_acct_rec.attribute5,150);
2276: dbms_sql.define_column(l_pty_acct_cur_id,17,
2277: l_pty_acct_rec.attribute6,150);
2278: dbms_sql.define_column(l_pty_acct_cur_id,18,
2279: l_pty_acct_rec.attribute7,150);
2280: dbms_sql.define_column(l_pty_acct_cur_id,19,

Line 2278: dbms_sql.define_column(l_pty_acct_cur_id,18,

2274: dbms_sql.define_column(l_pty_acct_cur_id,16,
2275: l_pty_acct_rec.attribute5,150);
2276: dbms_sql.define_column(l_pty_acct_cur_id,17,
2277: l_pty_acct_rec.attribute6,150);
2278: dbms_sql.define_column(l_pty_acct_cur_id,18,
2279: l_pty_acct_rec.attribute7,150);
2280: dbms_sql.define_column(l_pty_acct_cur_id,19,
2281: l_pty_acct_rec.attribute8,150);
2282: dbms_sql.define_column(l_pty_acct_cur_id,20,

Line 2280: dbms_sql.define_column(l_pty_acct_cur_id,19,

2276: dbms_sql.define_column(l_pty_acct_cur_id,17,
2277: l_pty_acct_rec.attribute6,150);
2278: dbms_sql.define_column(l_pty_acct_cur_id,18,
2279: l_pty_acct_rec.attribute7,150);
2280: dbms_sql.define_column(l_pty_acct_cur_id,19,
2281: l_pty_acct_rec.attribute8,150);
2282: dbms_sql.define_column(l_pty_acct_cur_id,20,
2283: l_pty_acct_rec.attribute9,150);
2284: dbms_sql.define_column(l_pty_acct_cur_id,21,

Line 2282: dbms_sql.define_column(l_pty_acct_cur_id,20,

2278: dbms_sql.define_column(l_pty_acct_cur_id,18,
2279: l_pty_acct_rec.attribute7,150);
2280: dbms_sql.define_column(l_pty_acct_cur_id,19,
2281: l_pty_acct_rec.attribute8,150);
2282: dbms_sql.define_column(l_pty_acct_cur_id,20,
2283: l_pty_acct_rec.attribute9,150);
2284: dbms_sql.define_column(l_pty_acct_cur_id,21,
2285: l_pty_acct_rec.attribute10,150);
2286: dbms_sql.define_column(l_pty_acct_cur_id,22,

Line 2284: dbms_sql.define_column(l_pty_acct_cur_id,21,

2280: dbms_sql.define_column(l_pty_acct_cur_id,19,
2281: l_pty_acct_rec.attribute8,150);
2282: dbms_sql.define_column(l_pty_acct_cur_id,20,
2283: l_pty_acct_rec.attribute9,150);
2284: dbms_sql.define_column(l_pty_acct_cur_id,21,
2285: l_pty_acct_rec.attribute10,150);
2286: dbms_sql.define_column(l_pty_acct_cur_id,22,
2287: l_pty_acct_rec.attribute11,150);
2288: dbms_sql.define_column(l_pty_acct_cur_id,23,

Line 2286: dbms_sql.define_column(l_pty_acct_cur_id,22,

2282: dbms_sql.define_column(l_pty_acct_cur_id,20,
2283: l_pty_acct_rec.attribute9,150);
2284: dbms_sql.define_column(l_pty_acct_cur_id,21,
2285: l_pty_acct_rec.attribute10,150);
2286: dbms_sql.define_column(l_pty_acct_cur_id,22,
2287: l_pty_acct_rec.attribute11,150);
2288: dbms_sql.define_column(l_pty_acct_cur_id,23,
2289: l_pty_acct_rec.attribute12,150);
2290: dbms_sql.define_column(l_pty_acct_cur_id,24,

Line 2288: dbms_sql.define_column(l_pty_acct_cur_id,23,

2284: dbms_sql.define_column(l_pty_acct_cur_id,21,
2285: l_pty_acct_rec.attribute10,150);
2286: dbms_sql.define_column(l_pty_acct_cur_id,22,
2287: l_pty_acct_rec.attribute11,150);
2288: dbms_sql.define_column(l_pty_acct_cur_id,23,
2289: l_pty_acct_rec.attribute12,150);
2290: dbms_sql.define_column(l_pty_acct_cur_id,24,
2291: l_pty_acct_rec.attribute13,150);
2292: dbms_sql.define_column(l_pty_acct_cur_id,25,

Line 2290: dbms_sql.define_column(l_pty_acct_cur_id,24,

2286: dbms_sql.define_column(l_pty_acct_cur_id,22,
2287: l_pty_acct_rec.attribute11,150);
2288: dbms_sql.define_column(l_pty_acct_cur_id,23,
2289: l_pty_acct_rec.attribute12,150);
2290: dbms_sql.define_column(l_pty_acct_cur_id,24,
2291: l_pty_acct_rec.attribute13,150);
2292: dbms_sql.define_column(l_pty_acct_cur_id,25,
2293: l_pty_acct_rec.attribute14,150);
2294: dbms_sql.define_column(l_pty_acct_cur_id,26,

Line 2292: dbms_sql.define_column(l_pty_acct_cur_id,25,

2288: dbms_sql.define_column(l_pty_acct_cur_id,23,
2289: l_pty_acct_rec.attribute12,150);
2290: dbms_sql.define_column(l_pty_acct_cur_id,24,
2291: l_pty_acct_rec.attribute13,150);
2292: dbms_sql.define_column(l_pty_acct_cur_id,25,
2293: l_pty_acct_rec.attribute14,150);
2294: dbms_sql.define_column(l_pty_acct_cur_id,26,
2295: l_pty_acct_rec.attribute15,150);
2296: dbms_sql.define_column(l_pty_acct_cur_id,27,

Line 2294: dbms_sql.define_column(l_pty_acct_cur_id,26,

2290: dbms_sql.define_column(l_pty_acct_cur_id,24,
2291: l_pty_acct_rec.attribute13,150);
2292: dbms_sql.define_column(l_pty_acct_cur_id,25,
2293: l_pty_acct_rec.attribute14,150);
2294: dbms_sql.define_column(l_pty_acct_cur_id,26,
2295: l_pty_acct_rec.attribute15,150);
2296: dbms_sql.define_column(l_pty_acct_cur_id,27,
2297: l_pty_acct_rec.object_version_number);
2298:

Line 2296: dbms_sql.define_column(l_pty_acct_cur_id,27,

2292: dbms_sql.define_column(l_pty_acct_cur_id,25,
2293: l_pty_acct_rec.attribute14,150);
2294: dbms_sql.define_column(l_pty_acct_cur_id,26,
2295: l_pty_acct_rec.attribute15,150);
2296: dbms_sql.define_column(l_pty_acct_cur_id,27,
2297: l_pty_acct_rec.object_version_number);
2298:
2299: l_ind := 0;
2300:

Line 2301: l_processed_rows := dbms_sql.execute(l_pty_acct_cur_id);

2297: l_pty_acct_rec.object_version_number);
2298:
2299: l_ind := 0;
2300:
2301: l_processed_rows := dbms_sql.execute(l_pty_acct_cur_id);
2302: LOOP
2303: exit when dbms_sql.fetch_rows(l_pty_acct_cur_id) = 0;
2304:
2305: l_ind := l_ind + 1;

Line 2303: exit when dbms_sql.fetch_rows(l_pty_acct_cur_id) = 0;

2299: l_ind := 0;
2300:
2301: l_processed_rows := dbms_sql.execute(l_pty_acct_cur_id);
2302: LOOP
2303: exit when dbms_sql.fetch_rows(l_pty_acct_cur_id) = 0;
2304:
2305: l_ind := l_ind + 1;
2306:
2307: dbms_sql.column_value(l_pty_acct_cur_id,1,

Line 2307: dbms_sql.column_value(l_pty_acct_cur_id,1,

2303: exit when dbms_sql.fetch_rows(l_pty_acct_cur_id) = 0;
2304:
2305: l_ind := l_ind + 1;
2306:
2307: dbms_sql.column_value(l_pty_acct_cur_id,1,
2308: x_pty_acct_detail_tbl(l_ind).txn_account_detail_id);
2309: dbms_sql.column_value(l_pty_acct_cur_id,2,
2310: x_pty_acct_detail_tbl(l_ind).txn_party_detail_id);
2311: dbms_sql.column_value(l_pty_acct_cur_id,3,

Line 2309: dbms_sql.column_value(l_pty_acct_cur_id,2,

2305: l_ind := l_ind + 1;
2306:
2307: dbms_sql.column_value(l_pty_acct_cur_id,1,
2308: x_pty_acct_detail_tbl(l_ind).txn_account_detail_id);
2309: dbms_sql.column_value(l_pty_acct_cur_id,2,
2310: x_pty_acct_detail_tbl(l_ind).txn_party_detail_id);
2311: dbms_sql.column_value(l_pty_acct_cur_id,3,
2312: x_pty_acct_detail_tbl(l_ind).ip_account_id);
2313: dbms_sql.column_value(l_pty_acct_cur_id,4,

Line 2311: dbms_sql.column_value(l_pty_acct_cur_id,3,

2307: dbms_sql.column_value(l_pty_acct_cur_id,1,
2308: x_pty_acct_detail_tbl(l_ind).txn_account_detail_id);
2309: dbms_sql.column_value(l_pty_acct_cur_id,2,
2310: x_pty_acct_detail_tbl(l_ind).txn_party_detail_id);
2311: dbms_sql.column_value(l_pty_acct_cur_id,3,
2312: x_pty_acct_detail_tbl(l_ind).ip_account_id);
2313: dbms_sql.column_value(l_pty_acct_cur_id,4,
2314: x_pty_acct_detail_tbl(l_ind).account_id);
2315: dbms_sql.column_value(l_pty_acct_cur_id,5,

Line 2313: dbms_sql.column_value(l_pty_acct_cur_id,4,

2309: dbms_sql.column_value(l_pty_acct_cur_id,2,
2310: x_pty_acct_detail_tbl(l_ind).txn_party_detail_id);
2311: dbms_sql.column_value(l_pty_acct_cur_id,3,
2312: x_pty_acct_detail_tbl(l_ind).ip_account_id);
2313: dbms_sql.column_value(l_pty_acct_cur_id,4,
2314: x_pty_acct_detail_tbl(l_ind).account_id);
2315: dbms_sql.column_value(l_pty_acct_cur_id,5,
2316: x_pty_acct_detail_tbl(l_ind).relationship_type_code);
2317: dbms_sql.column_value(l_pty_acct_cur_id,6,

Line 2315: dbms_sql.column_value(l_pty_acct_cur_id,5,

2311: dbms_sql.column_value(l_pty_acct_cur_id,3,
2312: x_pty_acct_detail_tbl(l_ind).ip_account_id);
2313: dbms_sql.column_value(l_pty_acct_cur_id,4,
2314: x_pty_acct_detail_tbl(l_ind).account_id);
2315: dbms_sql.column_value(l_pty_acct_cur_id,5,
2316: x_pty_acct_detail_tbl(l_ind).relationship_type_code);
2317: dbms_sql.column_value(l_pty_acct_cur_id,6,
2318: x_pty_acct_detail_tbl(l_ind).bill_to_address_id);
2319: dbms_sql.column_value(l_pty_acct_cur_id,7,

Line 2317: dbms_sql.column_value(l_pty_acct_cur_id,6,

2313: dbms_sql.column_value(l_pty_acct_cur_id,4,
2314: x_pty_acct_detail_tbl(l_ind).account_id);
2315: dbms_sql.column_value(l_pty_acct_cur_id,5,
2316: x_pty_acct_detail_tbl(l_ind).relationship_type_code);
2317: dbms_sql.column_value(l_pty_acct_cur_id,6,
2318: x_pty_acct_detail_tbl(l_ind).bill_to_address_id);
2319: dbms_sql.column_value(l_pty_acct_cur_id,7,
2320: x_pty_acct_detail_tbl(l_ind).ship_to_address_id);
2321: dbms_sql.column_value(l_pty_acct_cur_id,8,

Line 2319: dbms_sql.column_value(l_pty_acct_cur_id,7,

2315: dbms_sql.column_value(l_pty_acct_cur_id,5,
2316: x_pty_acct_detail_tbl(l_ind).relationship_type_code);
2317: dbms_sql.column_value(l_pty_acct_cur_id,6,
2318: x_pty_acct_detail_tbl(l_ind).bill_to_address_id);
2319: dbms_sql.column_value(l_pty_acct_cur_id,7,
2320: x_pty_acct_detail_tbl(l_ind).ship_to_address_id);
2321: dbms_sql.column_value(l_pty_acct_cur_id,8,
2322: x_pty_acct_detail_tbl(l_ind).active_start_date);
2323: dbms_sql.column_value(l_pty_acct_cur_id,9,

Line 2321: dbms_sql.column_value(l_pty_acct_cur_id,8,

2317: dbms_sql.column_value(l_pty_acct_cur_id,6,
2318: x_pty_acct_detail_tbl(l_ind).bill_to_address_id);
2319: dbms_sql.column_value(l_pty_acct_cur_id,7,
2320: x_pty_acct_detail_tbl(l_ind).ship_to_address_id);
2321: dbms_sql.column_value(l_pty_acct_cur_id,8,
2322: x_pty_acct_detail_tbl(l_ind).active_start_date);
2323: dbms_sql.column_value(l_pty_acct_cur_id,9,
2324: x_pty_acct_detail_tbl(l_ind).active_end_date);
2325: dbms_sql.column_value(l_pty_acct_cur_id,10,

Line 2323: dbms_sql.column_value(l_pty_acct_cur_id,9,

2319: dbms_sql.column_value(l_pty_acct_cur_id,7,
2320: x_pty_acct_detail_tbl(l_ind).ship_to_address_id);
2321: dbms_sql.column_value(l_pty_acct_cur_id,8,
2322: x_pty_acct_detail_tbl(l_ind).active_start_date);
2323: dbms_sql.column_value(l_pty_acct_cur_id,9,
2324: x_pty_acct_detail_tbl(l_ind).active_end_date);
2325: dbms_sql.column_value(l_pty_acct_cur_id,10,
2326: x_pty_acct_detail_tbl(l_ind).preserve_detail_flag);
2327: dbms_sql.column_value(l_pty_acct_cur_id,11,

Line 2325: dbms_sql.column_value(l_pty_acct_cur_id,10,

2321: dbms_sql.column_value(l_pty_acct_cur_id,8,
2322: x_pty_acct_detail_tbl(l_ind).active_start_date);
2323: dbms_sql.column_value(l_pty_acct_cur_id,9,
2324: x_pty_acct_detail_tbl(l_ind).active_end_date);
2325: dbms_sql.column_value(l_pty_acct_cur_id,10,
2326: x_pty_acct_detail_tbl(l_ind).preserve_detail_flag);
2327: dbms_sql.column_value(l_pty_acct_cur_id,11,
2328: x_pty_acct_detail_tbl(l_ind).context);
2329: dbms_sql.column_value(l_pty_acct_cur_id,12,

Line 2327: dbms_sql.column_value(l_pty_acct_cur_id,11,

2323: dbms_sql.column_value(l_pty_acct_cur_id,9,
2324: x_pty_acct_detail_tbl(l_ind).active_end_date);
2325: dbms_sql.column_value(l_pty_acct_cur_id,10,
2326: x_pty_acct_detail_tbl(l_ind).preserve_detail_flag);
2327: dbms_sql.column_value(l_pty_acct_cur_id,11,
2328: x_pty_acct_detail_tbl(l_ind).context);
2329: dbms_sql.column_value(l_pty_acct_cur_id,12,
2330: x_pty_acct_detail_tbl(l_ind).attribute1);
2331: dbms_sql.column_value(l_pty_acct_cur_id,13,

Line 2329: dbms_sql.column_value(l_pty_acct_cur_id,12,

2325: dbms_sql.column_value(l_pty_acct_cur_id,10,
2326: x_pty_acct_detail_tbl(l_ind).preserve_detail_flag);
2327: dbms_sql.column_value(l_pty_acct_cur_id,11,
2328: x_pty_acct_detail_tbl(l_ind).context);
2329: dbms_sql.column_value(l_pty_acct_cur_id,12,
2330: x_pty_acct_detail_tbl(l_ind).attribute1);
2331: dbms_sql.column_value(l_pty_acct_cur_id,13,
2332: x_pty_acct_detail_tbl(l_ind).attribute2);
2333: dbms_sql.column_value(l_pty_acct_cur_id,14,

Line 2331: dbms_sql.column_value(l_pty_acct_cur_id,13,

2327: dbms_sql.column_value(l_pty_acct_cur_id,11,
2328: x_pty_acct_detail_tbl(l_ind).context);
2329: dbms_sql.column_value(l_pty_acct_cur_id,12,
2330: x_pty_acct_detail_tbl(l_ind).attribute1);
2331: dbms_sql.column_value(l_pty_acct_cur_id,13,
2332: x_pty_acct_detail_tbl(l_ind).attribute2);
2333: dbms_sql.column_value(l_pty_acct_cur_id,14,
2334: x_pty_acct_detail_tbl(l_ind).attribute3);
2335: dbms_sql.column_value(l_pty_acct_cur_id,15,

Line 2333: dbms_sql.column_value(l_pty_acct_cur_id,14,

2329: dbms_sql.column_value(l_pty_acct_cur_id,12,
2330: x_pty_acct_detail_tbl(l_ind).attribute1);
2331: dbms_sql.column_value(l_pty_acct_cur_id,13,
2332: x_pty_acct_detail_tbl(l_ind).attribute2);
2333: dbms_sql.column_value(l_pty_acct_cur_id,14,
2334: x_pty_acct_detail_tbl(l_ind).attribute3);
2335: dbms_sql.column_value(l_pty_acct_cur_id,15,
2336: x_pty_acct_detail_tbl(l_ind).attribute4);
2337: dbms_sql.column_value(l_pty_acct_cur_id,16,

Line 2335: dbms_sql.column_value(l_pty_acct_cur_id,15,

2331: dbms_sql.column_value(l_pty_acct_cur_id,13,
2332: x_pty_acct_detail_tbl(l_ind).attribute2);
2333: dbms_sql.column_value(l_pty_acct_cur_id,14,
2334: x_pty_acct_detail_tbl(l_ind).attribute3);
2335: dbms_sql.column_value(l_pty_acct_cur_id,15,
2336: x_pty_acct_detail_tbl(l_ind).attribute4);
2337: dbms_sql.column_value(l_pty_acct_cur_id,16,
2338: x_pty_acct_detail_tbl(l_ind).attribute5);
2339: dbms_sql.column_value(l_pty_acct_cur_id,17,

Line 2337: dbms_sql.column_value(l_pty_acct_cur_id,16,

2333: dbms_sql.column_value(l_pty_acct_cur_id,14,
2334: x_pty_acct_detail_tbl(l_ind).attribute3);
2335: dbms_sql.column_value(l_pty_acct_cur_id,15,
2336: x_pty_acct_detail_tbl(l_ind).attribute4);
2337: dbms_sql.column_value(l_pty_acct_cur_id,16,
2338: x_pty_acct_detail_tbl(l_ind).attribute5);
2339: dbms_sql.column_value(l_pty_acct_cur_id,17,
2340: x_pty_acct_detail_tbl(l_ind).attribute6);
2341: dbms_sql.column_value(l_pty_acct_cur_id,18,

Line 2339: dbms_sql.column_value(l_pty_acct_cur_id,17,

2335: dbms_sql.column_value(l_pty_acct_cur_id,15,
2336: x_pty_acct_detail_tbl(l_ind).attribute4);
2337: dbms_sql.column_value(l_pty_acct_cur_id,16,
2338: x_pty_acct_detail_tbl(l_ind).attribute5);
2339: dbms_sql.column_value(l_pty_acct_cur_id,17,
2340: x_pty_acct_detail_tbl(l_ind).attribute6);
2341: dbms_sql.column_value(l_pty_acct_cur_id,18,
2342: x_pty_acct_detail_tbl(l_ind).attribute7);
2343: dbms_sql.column_value(l_pty_acct_cur_id,19,

Line 2341: dbms_sql.column_value(l_pty_acct_cur_id,18,

2337: dbms_sql.column_value(l_pty_acct_cur_id,16,
2338: x_pty_acct_detail_tbl(l_ind).attribute5);
2339: dbms_sql.column_value(l_pty_acct_cur_id,17,
2340: x_pty_acct_detail_tbl(l_ind).attribute6);
2341: dbms_sql.column_value(l_pty_acct_cur_id,18,
2342: x_pty_acct_detail_tbl(l_ind).attribute7);
2343: dbms_sql.column_value(l_pty_acct_cur_id,19,
2344: x_pty_acct_detail_tbl(l_ind).attribute8);
2345: dbms_sql.column_value(l_pty_acct_cur_id,20,

Line 2343: dbms_sql.column_value(l_pty_acct_cur_id,19,

2339: dbms_sql.column_value(l_pty_acct_cur_id,17,
2340: x_pty_acct_detail_tbl(l_ind).attribute6);
2341: dbms_sql.column_value(l_pty_acct_cur_id,18,
2342: x_pty_acct_detail_tbl(l_ind).attribute7);
2343: dbms_sql.column_value(l_pty_acct_cur_id,19,
2344: x_pty_acct_detail_tbl(l_ind).attribute8);
2345: dbms_sql.column_value(l_pty_acct_cur_id,20,
2346: x_pty_acct_detail_tbl(l_ind).attribute9);
2347: dbms_sql.column_value(l_pty_acct_cur_id,21,

Line 2345: dbms_sql.column_value(l_pty_acct_cur_id,20,

2341: dbms_sql.column_value(l_pty_acct_cur_id,18,
2342: x_pty_acct_detail_tbl(l_ind).attribute7);
2343: dbms_sql.column_value(l_pty_acct_cur_id,19,
2344: x_pty_acct_detail_tbl(l_ind).attribute8);
2345: dbms_sql.column_value(l_pty_acct_cur_id,20,
2346: x_pty_acct_detail_tbl(l_ind).attribute9);
2347: dbms_sql.column_value(l_pty_acct_cur_id,21,
2348: x_pty_acct_detail_tbl(l_ind).attribute10);
2349: dbms_sql.column_value(l_pty_acct_cur_id,22,

Line 2347: dbms_sql.column_value(l_pty_acct_cur_id,21,

2343: dbms_sql.column_value(l_pty_acct_cur_id,19,
2344: x_pty_acct_detail_tbl(l_ind).attribute8);
2345: dbms_sql.column_value(l_pty_acct_cur_id,20,
2346: x_pty_acct_detail_tbl(l_ind).attribute9);
2347: dbms_sql.column_value(l_pty_acct_cur_id,21,
2348: x_pty_acct_detail_tbl(l_ind).attribute10);
2349: dbms_sql.column_value(l_pty_acct_cur_id,22,
2350: x_pty_acct_detail_tbl(l_ind).attribute11);
2351: dbms_sql.column_value(l_pty_acct_cur_id,23,

Line 2349: dbms_sql.column_value(l_pty_acct_cur_id,22,

2345: dbms_sql.column_value(l_pty_acct_cur_id,20,
2346: x_pty_acct_detail_tbl(l_ind).attribute9);
2347: dbms_sql.column_value(l_pty_acct_cur_id,21,
2348: x_pty_acct_detail_tbl(l_ind).attribute10);
2349: dbms_sql.column_value(l_pty_acct_cur_id,22,
2350: x_pty_acct_detail_tbl(l_ind).attribute11);
2351: dbms_sql.column_value(l_pty_acct_cur_id,23,
2352: x_pty_acct_detail_tbl(l_ind).attribute12);
2353: dbms_sql.column_value(l_pty_acct_cur_id,24,

Line 2351: dbms_sql.column_value(l_pty_acct_cur_id,23,

2347: dbms_sql.column_value(l_pty_acct_cur_id,21,
2348: x_pty_acct_detail_tbl(l_ind).attribute10);
2349: dbms_sql.column_value(l_pty_acct_cur_id,22,
2350: x_pty_acct_detail_tbl(l_ind).attribute11);
2351: dbms_sql.column_value(l_pty_acct_cur_id,23,
2352: x_pty_acct_detail_tbl(l_ind).attribute12);
2353: dbms_sql.column_value(l_pty_acct_cur_id,24,
2354: x_pty_acct_detail_tbl(l_ind).attribute13);
2355: dbms_sql.column_value(l_pty_acct_cur_id,25,

Line 2353: dbms_sql.column_value(l_pty_acct_cur_id,24,

2349: dbms_sql.column_value(l_pty_acct_cur_id,22,
2350: x_pty_acct_detail_tbl(l_ind).attribute11);
2351: dbms_sql.column_value(l_pty_acct_cur_id,23,
2352: x_pty_acct_detail_tbl(l_ind).attribute12);
2353: dbms_sql.column_value(l_pty_acct_cur_id,24,
2354: x_pty_acct_detail_tbl(l_ind).attribute13);
2355: dbms_sql.column_value(l_pty_acct_cur_id,25,
2356: x_pty_acct_detail_tbl(l_ind).attribute14);
2357: dbms_sql.column_value(l_pty_acct_cur_id,26,

Line 2355: dbms_sql.column_value(l_pty_acct_cur_id,25,

2351: dbms_sql.column_value(l_pty_acct_cur_id,23,
2352: x_pty_acct_detail_tbl(l_ind).attribute12);
2353: dbms_sql.column_value(l_pty_acct_cur_id,24,
2354: x_pty_acct_detail_tbl(l_ind).attribute13);
2355: dbms_sql.column_value(l_pty_acct_cur_id,25,
2356: x_pty_acct_detail_tbl(l_ind).attribute14);
2357: dbms_sql.column_value(l_pty_acct_cur_id,26,
2358: x_pty_acct_detail_tbl(l_ind).attribute15);
2359: dbms_sql.column_value(l_pty_acct_cur_id,27,

Line 2357: dbms_sql.column_value(l_pty_acct_cur_id,26,

2353: dbms_sql.column_value(l_pty_acct_cur_id,24,
2354: x_pty_acct_detail_tbl(l_ind).attribute13);
2355: dbms_sql.column_value(l_pty_acct_cur_id,25,
2356: x_pty_acct_detail_tbl(l_ind).attribute14);
2357: dbms_sql.column_value(l_pty_acct_cur_id,26,
2358: x_pty_acct_detail_tbl(l_ind).attribute15);
2359: dbms_sql.column_value(l_pty_acct_cur_id,27,
2360: x_pty_acct_detail_tbl(l_ind).object_version_number);
2361:

Line 2359: dbms_sql.column_value(l_pty_acct_cur_id,27,

2355: dbms_sql.column_value(l_pty_acct_cur_id,25,
2356: x_pty_acct_detail_tbl(l_ind).attribute14);
2357: dbms_sql.column_value(l_pty_acct_cur_id,26,
2358: x_pty_acct_detail_tbl(l_ind).attribute15);
2359: dbms_sql.column_value(l_pty_acct_cur_id,27,
2360: x_pty_acct_detail_tbl(l_ind).object_version_number);
2361:
2362: END LOOP;
2363:

Line 2364: dbms_sql.close_cursor(l_pty_acct_cur_id);

2360: x_pty_acct_detail_tbl(l_ind).object_version_number);
2361:
2362: END LOOP;
2363:
2364: dbms_sql.close_cursor(l_pty_acct_cur_id);
2365:
2366: EXCEPTION
2367: WHEN others THEN
2368:

Line 2369: IF dbms_sql.is_open(l_pty_acct_cur_id) THEN

2365:
2366: EXCEPTION
2367: WHEN others THEN
2368:
2369: IF dbms_sql.is_open(l_pty_acct_cur_id) THEN
2370: dbms_sql.close_cursor(l_pty_acct_cur_id);
2371: END IF;
2372: END get_pty_acct_dtls;
2373:

Line 2370: dbms_sql.close_cursor(l_pty_acct_cur_id);

2366: EXCEPTION
2367: WHEN others THEN
2368:
2369: IF dbms_sql.is_open(l_pty_acct_cur_id) THEN
2370: dbms_sql.close_cursor(l_pty_acct_cur_id);
2371: END IF;
2372: END get_pty_acct_dtls;
2373:
2374: PROCEDURE get_party_dtls(

Line 2403: l_pty_cur_id := dbms_sql.open_cursor;

2399: ' primary_flag, preferred_flag '||
2400: 'from csi_t_party_details '||
2401: 'where txn_line_detail_id = :line_dtl_id';
2402:
2403: l_pty_cur_id := dbms_sql.open_cursor;
2404:
2405: dbms_sql.parse(l_pty_cur_id, l_select_stmt , dbms_sql.native);
2406:
2407: dbms_sql.bind_variable(l_pty_cur_id, 'line_dtl_id', p_line_dtl_id);

Line 2405: dbms_sql.parse(l_pty_cur_id, l_select_stmt , dbms_sql.native);

2401: 'where txn_line_detail_id = :line_dtl_id';
2402:
2403: l_pty_cur_id := dbms_sql.open_cursor;
2404:
2405: dbms_sql.parse(l_pty_cur_id, l_select_stmt , dbms_sql.native);
2406:
2407: dbms_sql.bind_variable(l_pty_cur_id, 'line_dtl_id', p_line_dtl_id);
2408:
2409: dbms_sql.define_column(l_pty_cur_id,1,l_pty_rec.txn_party_detail_id);

Line 2407: dbms_sql.bind_variable(l_pty_cur_id, 'line_dtl_id', p_line_dtl_id);

2403: l_pty_cur_id := dbms_sql.open_cursor;
2404:
2405: dbms_sql.parse(l_pty_cur_id, l_select_stmt , dbms_sql.native);
2406:
2407: dbms_sql.bind_variable(l_pty_cur_id, 'line_dtl_id', p_line_dtl_id);
2408:
2409: dbms_sql.define_column(l_pty_cur_id,1,l_pty_rec.txn_party_detail_id);
2410: dbms_sql.define_column(l_pty_cur_id,2,l_pty_rec.txn_line_detail_id);
2411: dbms_sql.define_column(l_pty_cur_id,3,l_pty_rec.instance_party_id);

Line 2409: dbms_sql.define_column(l_pty_cur_id,1,l_pty_rec.txn_party_detail_id);

2405: dbms_sql.parse(l_pty_cur_id, l_select_stmt , dbms_sql.native);
2406:
2407: dbms_sql.bind_variable(l_pty_cur_id, 'line_dtl_id', p_line_dtl_id);
2408:
2409: dbms_sql.define_column(l_pty_cur_id,1,l_pty_rec.txn_party_detail_id);
2410: dbms_sql.define_column(l_pty_cur_id,2,l_pty_rec.txn_line_detail_id);
2411: dbms_sql.define_column(l_pty_cur_id,3,l_pty_rec.instance_party_id);
2412: dbms_sql.define_column(l_pty_cur_id,4,l_pty_rec.party_source_table,30);
2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);

Line 2410: dbms_sql.define_column(l_pty_cur_id,2,l_pty_rec.txn_line_detail_id);

2406:
2407: dbms_sql.bind_variable(l_pty_cur_id, 'line_dtl_id', p_line_dtl_id);
2408:
2409: dbms_sql.define_column(l_pty_cur_id,1,l_pty_rec.txn_party_detail_id);
2410: dbms_sql.define_column(l_pty_cur_id,2,l_pty_rec.txn_line_detail_id);
2411: dbms_sql.define_column(l_pty_cur_id,3,l_pty_rec.instance_party_id);
2412: dbms_sql.define_column(l_pty_cur_id,4,l_pty_rec.party_source_table,30);
2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);
2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);

Line 2411: dbms_sql.define_column(l_pty_cur_id,3,l_pty_rec.instance_party_id);

2407: dbms_sql.bind_variable(l_pty_cur_id, 'line_dtl_id', p_line_dtl_id);
2408:
2409: dbms_sql.define_column(l_pty_cur_id,1,l_pty_rec.txn_party_detail_id);
2410: dbms_sql.define_column(l_pty_cur_id,2,l_pty_rec.txn_line_detail_id);
2411: dbms_sql.define_column(l_pty_cur_id,3,l_pty_rec.instance_party_id);
2412: dbms_sql.define_column(l_pty_cur_id,4,l_pty_rec.party_source_table,30);
2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);
2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);
2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);

Line 2412: dbms_sql.define_column(l_pty_cur_id,4,l_pty_rec.party_source_table,30);

2408:
2409: dbms_sql.define_column(l_pty_cur_id,1,l_pty_rec.txn_party_detail_id);
2410: dbms_sql.define_column(l_pty_cur_id,2,l_pty_rec.txn_line_detail_id);
2411: dbms_sql.define_column(l_pty_cur_id,3,l_pty_rec.instance_party_id);
2412: dbms_sql.define_column(l_pty_cur_id,4,l_pty_rec.party_source_table,30);
2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);
2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);
2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);
2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);

Line 2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);

2409: dbms_sql.define_column(l_pty_cur_id,1,l_pty_rec.txn_party_detail_id);
2410: dbms_sql.define_column(l_pty_cur_id,2,l_pty_rec.txn_line_detail_id);
2411: dbms_sql.define_column(l_pty_cur_id,3,l_pty_rec.instance_party_id);
2412: dbms_sql.define_column(l_pty_cur_id,4,l_pty_rec.party_source_table,30);
2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);
2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);
2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);
2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);
2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);

Line 2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);

2410: dbms_sql.define_column(l_pty_cur_id,2,l_pty_rec.txn_line_detail_id);
2411: dbms_sql.define_column(l_pty_cur_id,3,l_pty_rec.instance_party_id);
2412: dbms_sql.define_column(l_pty_cur_id,4,l_pty_rec.party_source_table,30);
2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);
2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);
2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);
2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);
2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);
2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);

Line 2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);

2411: dbms_sql.define_column(l_pty_cur_id,3,l_pty_rec.instance_party_id);
2412: dbms_sql.define_column(l_pty_cur_id,4,l_pty_rec.party_source_table,30);
2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);
2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);
2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);
2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);
2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);
2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);
2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);

Line 2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);

2412: dbms_sql.define_column(l_pty_cur_id,4,l_pty_rec.party_source_table,30);
2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);
2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);
2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);
2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);
2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);
2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);
2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);
2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);

Line 2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);

2413: dbms_sql.define_column(l_pty_cur_id,5,l_pty_rec.party_source_id);
2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);
2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);
2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);
2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);
2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);
2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);
2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);
2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);

Line 2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);

2414: dbms_sql.define_column(l_pty_cur_id,6,l_pty_rec.relationship_type_code,30);
2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);
2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);
2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);
2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);
2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);
2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);
2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);
2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);

Line 2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);

2415: dbms_sql.define_column(l_pty_cur_id,7,l_pty_rec.contact_flag,1);
2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);
2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);
2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);
2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);
2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);
2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);
2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);
2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);

Line 2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);

2416: dbms_sql.define_column(l_pty_cur_id,8,l_pty_rec.contact_party_id);
2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);
2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);
2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);
2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);
2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);
2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);
2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);
2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);

Line 2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);

2417: dbms_sql.define_column(l_pty_cur_id,9,l_pty_rec.active_start_date);
2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);
2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);
2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);
2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);
2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);
2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);
2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);
2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);

Line 2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);

2418: dbms_sql.define_column(l_pty_cur_id,10,l_pty_rec.active_end_date);
2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);
2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);
2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);
2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);
2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);
2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);
2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);
2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);

Line 2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);

2419: dbms_sql.define_column(l_pty_cur_id,11,l_pty_rec.preserve_detail_flag,1);
2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);
2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);
2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);
2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);
2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);
2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);
2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);
2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);

Line 2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);

2420: dbms_sql.define_column(l_pty_cur_id,12,l_pty_rec.context,30);
2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);
2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);
2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);
2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);
2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);
2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);
2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);
2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);

Line 2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);

2421: dbms_sql.define_column(l_pty_cur_id,13,l_pty_rec.attribute1,150);
2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);
2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);
2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);
2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);
2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);
2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);
2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);
2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);

Line 2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);

2422: dbms_sql.define_column(l_pty_cur_id,14,l_pty_rec.attribute2,150);
2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);
2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);
2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);
2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);
2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);
2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);
2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);
2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);

Line 2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);

2423: dbms_sql.define_column(l_pty_cur_id,15,l_pty_rec.attribute3,150);
2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);
2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);
2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);
2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);
2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);
2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);
2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);
2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);

Line 2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);

2424: dbms_sql.define_column(l_pty_cur_id,16,l_pty_rec.attribute4,150);
2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);
2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);
2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);
2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);
2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);
2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);
2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);
2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);

Line 2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);

2425: dbms_sql.define_column(l_pty_cur_id,17,l_pty_rec.attribute5,150);
2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);
2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);
2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);
2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);
2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);
2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);
2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);
2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);

Line 2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);

2426: dbms_sql.define_column(l_pty_cur_id,18,l_pty_rec.attribute6,150);
2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);
2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);
2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);
2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);
2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);
2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);
2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);
2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);

Line 2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);

2427: dbms_sql.define_column(l_pty_cur_id,19,l_pty_rec.attribute7,150);
2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);
2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);
2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);
2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);
2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);
2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);
2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);
2435: dbms_sql.define_column(l_pty_cur_id,27,l_pty_rec.attribute15,150);

Line 2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);

2428: dbms_sql.define_column(l_pty_cur_id,20,l_pty_rec.attribute8,150);
2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);
2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);
2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);
2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);
2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);
2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);
2435: dbms_sql.define_column(l_pty_cur_id,27,l_pty_rec.attribute15,150);
2436: dbms_sql.define_column(l_pty_cur_id,28,l_pty_rec.object_version_number);

Line 2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);

2429: dbms_sql.define_column(l_pty_cur_id,21,l_pty_rec.attribute9,150);
2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);
2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);
2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);
2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);
2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);
2435: dbms_sql.define_column(l_pty_cur_id,27,l_pty_rec.attribute15,150);
2436: dbms_sql.define_column(l_pty_cur_id,28,l_pty_rec.object_version_number);
2437: dbms_sql.define_column(l_pty_cur_id,29,l_pty_rec.primary_flag,1);

Line 2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);

2430: dbms_sql.define_column(l_pty_cur_id,22,l_pty_rec.attribute10,150);
2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);
2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);
2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);
2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);
2435: dbms_sql.define_column(l_pty_cur_id,27,l_pty_rec.attribute15,150);
2436: dbms_sql.define_column(l_pty_cur_id,28,l_pty_rec.object_version_number);
2437: dbms_sql.define_column(l_pty_cur_id,29,l_pty_rec.primary_flag,1);
2438: dbms_sql.define_column(l_pty_cur_id,30,l_pty_rec.preferred_flag,1);

Line 2435: dbms_sql.define_column(l_pty_cur_id,27,l_pty_rec.attribute15,150);

2431: dbms_sql.define_column(l_pty_cur_id,23,l_pty_rec.attribute11,150);
2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);
2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);
2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);
2435: dbms_sql.define_column(l_pty_cur_id,27,l_pty_rec.attribute15,150);
2436: dbms_sql.define_column(l_pty_cur_id,28,l_pty_rec.object_version_number);
2437: dbms_sql.define_column(l_pty_cur_id,29,l_pty_rec.primary_flag,1);
2438: dbms_sql.define_column(l_pty_cur_id,30,l_pty_rec.preferred_flag,1);
2439:

Line 2436: dbms_sql.define_column(l_pty_cur_id,28,l_pty_rec.object_version_number);

2432: dbms_sql.define_column(l_pty_cur_id,24,l_pty_rec.attribute12,150);
2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);
2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);
2435: dbms_sql.define_column(l_pty_cur_id,27,l_pty_rec.attribute15,150);
2436: dbms_sql.define_column(l_pty_cur_id,28,l_pty_rec.object_version_number);
2437: dbms_sql.define_column(l_pty_cur_id,29,l_pty_rec.primary_flag,1);
2438: dbms_sql.define_column(l_pty_cur_id,30,l_pty_rec.preferred_flag,1);
2439:
2440: l_ind := 0;

Line 2437: dbms_sql.define_column(l_pty_cur_id,29,l_pty_rec.primary_flag,1);

2433: dbms_sql.define_column(l_pty_cur_id,25,l_pty_rec.attribute13,150);
2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);
2435: dbms_sql.define_column(l_pty_cur_id,27,l_pty_rec.attribute15,150);
2436: dbms_sql.define_column(l_pty_cur_id,28,l_pty_rec.object_version_number);
2437: dbms_sql.define_column(l_pty_cur_id,29,l_pty_rec.primary_flag,1);
2438: dbms_sql.define_column(l_pty_cur_id,30,l_pty_rec.preferred_flag,1);
2439:
2440: l_ind := 0;
2441:

Line 2438: dbms_sql.define_column(l_pty_cur_id,30,l_pty_rec.preferred_flag,1);

2434: dbms_sql.define_column(l_pty_cur_id,26,l_pty_rec.attribute14,150);
2435: dbms_sql.define_column(l_pty_cur_id,27,l_pty_rec.attribute15,150);
2436: dbms_sql.define_column(l_pty_cur_id,28,l_pty_rec.object_version_number);
2437: dbms_sql.define_column(l_pty_cur_id,29,l_pty_rec.primary_flag,1);
2438: dbms_sql.define_column(l_pty_cur_id,30,l_pty_rec.preferred_flag,1);
2439:
2440: l_ind := 0;
2441:
2442: l_processed_rows := dbms_sql.execute(l_pty_cur_id);

Line 2442: l_processed_rows := dbms_sql.execute(l_pty_cur_id);

2438: dbms_sql.define_column(l_pty_cur_id,30,l_pty_rec.preferred_flag,1);
2439:
2440: l_ind := 0;
2441:
2442: l_processed_rows := dbms_sql.execute(l_pty_cur_id);
2443: LOOP
2444: exit when dbms_sql.fetch_rows(l_pty_cur_id) = 0;
2445:
2446: l_ind := l_ind + 1;

Line 2444: exit when dbms_sql.fetch_rows(l_pty_cur_id) = 0;

2440: l_ind := 0;
2441:
2442: l_processed_rows := dbms_sql.execute(l_pty_cur_id);
2443: LOOP
2444: exit when dbms_sql.fetch_rows(l_pty_cur_id) = 0;
2445:
2446: l_ind := l_ind + 1;
2447:
2448: dbms_sql.column_value(l_pty_cur_id,1, x_party_detail_tbl(l_ind).txn_party_detail_id);

Line 2448: dbms_sql.column_value(l_pty_cur_id,1, x_party_detail_tbl(l_ind).txn_party_detail_id);

2444: exit when dbms_sql.fetch_rows(l_pty_cur_id) = 0;
2445:
2446: l_ind := l_ind + 1;
2447:
2448: dbms_sql.column_value(l_pty_cur_id,1, x_party_detail_tbl(l_ind).txn_party_detail_id);
2449: dbms_sql.column_value(l_pty_cur_id,2, x_party_detail_tbl(l_ind).txn_line_detail_id);
2450: dbms_sql.column_value(l_pty_cur_id,3, x_party_detail_tbl(l_ind).instance_party_id);
2451: dbms_sql.column_value(l_pty_cur_id,4, x_party_detail_tbl(l_ind).party_source_table);
2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);

Line 2449: dbms_sql.column_value(l_pty_cur_id,2, x_party_detail_tbl(l_ind).txn_line_detail_id);

2445:
2446: l_ind := l_ind + 1;
2447:
2448: dbms_sql.column_value(l_pty_cur_id,1, x_party_detail_tbl(l_ind).txn_party_detail_id);
2449: dbms_sql.column_value(l_pty_cur_id,2, x_party_detail_tbl(l_ind).txn_line_detail_id);
2450: dbms_sql.column_value(l_pty_cur_id,3, x_party_detail_tbl(l_ind).instance_party_id);
2451: dbms_sql.column_value(l_pty_cur_id,4, x_party_detail_tbl(l_ind).party_source_table);
2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);
2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);

Line 2450: dbms_sql.column_value(l_pty_cur_id,3, x_party_detail_tbl(l_ind).instance_party_id);

2446: l_ind := l_ind + 1;
2447:
2448: dbms_sql.column_value(l_pty_cur_id,1, x_party_detail_tbl(l_ind).txn_party_detail_id);
2449: dbms_sql.column_value(l_pty_cur_id,2, x_party_detail_tbl(l_ind).txn_line_detail_id);
2450: dbms_sql.column_value(l_pty_cur_id,3, x_party_detail_tbl(l_ind).instance_party_id);
2451: dbms_sql.column_value(l_pty_cur_id,4, x_party_detail_tbl(l_ind).party_source_table);
2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);
2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);
2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);

Line 2451: dbms_sql.column_value(l_pty_cur_id,4, x_party_detail_tbl(l_ind).party_source_table);

2447:
2448: dbms_sql.column_value(l_pty_cur_id,1, x_party_detail_tbl(l_ind).txn_party_detail_id);
2449: dbms_sql.column_value(l_pty_cur_id,2, x_party_detail_tbl(l_ind).txn_line_detail_id);
2450: dbms_sql.column_value(l_pty_cur_id,3, x_party_detail_tbl(l_ind).instance_party_id);
2451: dbms_sql.column_value(l_pty_cur_id,4, x_party_detail_tbl(l_ind).party_source_table);
2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);
2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);
2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);
2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);

Line 2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);

2448: dbms_sql.column_value(l_pty_cur_id,1, x_party_detail_tbl(l_ind).txn_party_detail_id);
2449: dbms_sql.column_value(l_pty_cur_id,2, x_party_detail_tbl(l_ind).txn_line_detail_id);
2450: dbms_sql.column_value(l_pty_cur_id,3, x_party_detail_tbl(l_ind).instance_party_id);
2451: dbms_sql.column_value(l_pty_cur_id,4, x_party_detail_tbl(l_ind).party_source_table);
2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);
2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);
2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);
2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);
2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);

Line 2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);

2449: dbms_sql.column_value(l_pty_cur_id,2, x_party_detail_tbl(l_ind).txn_line_detail_id);
2450: dbms_sql.column_value(l_pty_cur_id,3, x_party_detail_tbl(l_ind).instance_party_id);
2451: dbms_sql.column_value(l_pty_cur_id,4, x_party_detail_tbl(l_ind).party_source_table);
2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);
2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);
2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);
2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);
2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);
2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);

Line 2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);

2450: dbms_sql.column_value(l_pty_cur_id,3, x_party_detail_tbl(l_ind).instance_party_id);
2451: dbms_sql.column_value(l_pty_cur_id,4, x_party_detail_tbl(l_ind).party_source_table);
2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);
2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);
2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);
2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);
2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);
2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);
2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);

Line 2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);

2451: dbms_sql.column_value(l_pty_cur_id,4, x_party_detail_tbl(l_ind).party_source_table);
2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);
2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);
2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);
2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);
2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);
2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);
2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);
2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);

Line 2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);

2452: dbms_sql.column_value(l_pty_cur_id,5, x_party_detail_tbl(l_ind).party_source_id);
2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);
2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);
2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);
2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);
2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);
2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);
2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);
2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);

Line 2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);

2453: dbms_sql.column_value(l_pty_cur_id,6, x_party_detail_tbl(l_ind).relationship_type_code);
2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);
2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);
2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);
2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);
2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);
2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);
2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);
2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);

Line 2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);

2454: dbms_sql.column_value(l_pty_cur_id,7, x_party_detail_tbl(l_ind).contact_flag);
2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);
2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);
2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);
2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);
2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);
2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);
2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);
2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);

Line 2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);

2455: dbms_sql.column_value(l_pty_cur_id,8, x_party_detail_tbl(l_ind).contact_party_id);
2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);
2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);
2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);
2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);
2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);
2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);
2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);
2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);

Line 2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);

2456: dbms_sql.column_value(l_pty_cur_id,9, x_party_detail_tbl(l_ind).active_start_date);
2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);
2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);
2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);
2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);
2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);
2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);
2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);
2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);

Line 2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);

2457: dbms_sql.column_value(l_pty_cur_id,10, x_party_detail_tbl(l_ind).active_end_date);
2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);
2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);
2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);
2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);
2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);
2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);
2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);
2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);

Line 2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);

2458: dbms_sql.column_value(l_pty_cur_id,11, x_party_detail_tbl(l_ind).preserve_detail_flag);
2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);
2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);
2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);
2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);
2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);
2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);
2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);
2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);

Line 2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);

2459: dbms_sql.column_value(l_pty_cur_id,12, x_party_detail_tbl(l_ind).context);
2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);
2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);
2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);
2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);
2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);
2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);
2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);
2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);

Line 2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);

2460: dbms_sql.column_value(l_pty_cur_id,13, x_party_detail_tbl(l_ind).attribute1);
2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);
2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);
2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);
2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);
2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);
2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);
2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);
2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);

Line 2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);

2461: dbms_sql.column_value(l_pty_cur_id,14, x_party_detail_tbl(l_ind).attribute2);
2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);
2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);
2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);
2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);
2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);
2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);
2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);
2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);

Line 2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);

2462: dbms_sql.column_value(l_pty_cur_id,15, x_party_detail_tbl(l_ind).attribute3);
2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);
2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);
2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);
2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);
2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);
2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);
2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);
2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);

Line 2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);

2463: dbms_sql.column_value(l_pty_cur_id,16, x_party_detail_tbl(l_ind).attribute4);
2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);
2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);
2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);
2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);
2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);
2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);
2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);
2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);

Line 2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);

2464: dbms_sql.column_value(l_pty_cur_id,17, x_party_detail_tbl(l_ind).attribute5);
2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);
2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);
2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);
2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);
2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);
2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);
2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);
2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);

Line 2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);

2465: dbms_sql.column_value(l_pty_cur_id,18, x_party_detail_tbl(l_ind).attribute6);
2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);
2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);
2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);
2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);
2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);
2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);
2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);
2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);

Line 2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);

2466: dbms_sql.column_value(l_pty_cur_id,19, x_party_detail_tbl(l_ind).attribute7);
2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);
2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);
2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);
2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);
2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);
2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);
2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);
2474: dbms_sql.column_value(l_pty_cur_id,27, x_party_detail_tbl(l_ind).attribute15);

Line 2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);

2467: dbms_sql.column_value(l_pty_cur_id,20, x_party_detail_tbl(l_ind).attribute8);
2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);
2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);
2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);
2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);
2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);
2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);
2474: dbms_sql.column_value(l_pty_cur_id,27, x_party_detail_tbl(l_ind).attribute15);
2475: dbms_sql.column_value(l_pty_cur_id,28, x_party_detail_tbl(l_ind).object_version_number);

Line 2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);

2468: dbms_sql.column_value(l_pty_cur_id,21, x_party_detail_tbl(l_ind).attribute9);
2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);
2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);
2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);
2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);
2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);
2474: dbms_sql.column_value(l_pty_cur_id,27, x_party_detail_tbl(l_ind).attribute15);
2475: dbms_sql.column_value(l_pty_cur_id,28, x_party_detail_tbl(l_ind).object_version_number);
2476: dbms_sql.column_value(l_pty_cur_id,29, x_party_detail_tbl(l_ind).primary_flag);

Line 2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);

2469: dbms_sql.column_value(l_pty_cur_id,22, x_party_detail_tbl(l_ind).attribute10);
2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);
2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);
2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);
2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);
2474: dbms_sql.column_value(l_pty_cur_id,27, x_party_detail_tbl(l_ind).attribute15);
2475: dbms_sql.column_value(l_pty_cur_id,28, x_party_detail_tbl(l_ind).object_version_number);
2476: dbms_sql.column_value(l_pty_cur_id,29, x_party_detail_tbl(l_ind).primary_flag);
2477: dbms_sql.column_value(l_pty_cur_id,30, x_party_detail_tbl(l_ind).preferred_flag);

Line 2474: dbms_sql.column_value(l_pty_cur_id,27, x_party_detail_tbl(l_ind).attribute15);

2470: dbms_sql.column_value(l_pty_cur_id,23, x_party_detail_tbl(l_ind).attribute11);
2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);
2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);
2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);
2474: dbms_sql.column_value(l_pty_cur_id,27, x_party_detail_tbl(l_ind).attribute15);
2475: dbms_sql.column_value(l_pty_cur_id,28, x_party_detail_tbl(l_ind).object_version_number);
2476: dbms_sql.column_value(l_pty_cur_id,29, x_party_detail_tbl(l_ind).primary_flag);
2477: dbms_sql.column_value(l_pty_cur_id,30, x_party_detail_tbl(l_ind).preferred_flag);
2478:

Line 2475: dbms_sql.column_value(l_pty_cur_id,28, x_party_detail_tbl(l_ind).object_version_number);

2471: dbms_sql.column_value(l_pty_cur_id,24, x_party_detail_tbl(l_ind).attribute12);
2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);
2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);
2474: dbms_sql.column_value(l_pty_cur_id,27, x_party_detail_tbl(l_ind).attribute15);
2475: dbms_sql.column_value(l_pty_cur_id,28, x_party_detail_tbl(l_ind).object_version_number);
2476: dbms_sql.column_value(l_pty_cur_id,29, x_party_detail_tbl(l_ind).primary_flag);
2477: dbms_sql.column_value(l_pty_cur_id,30, x_party_detail_tbl(l_ind).preferred_flag);
2478:
2479: END LOOP;

Line 2476: dbms_sql.column_value(l_pty_cur_id,29, x_party_detail_tbl(l_ind).primary_flag);

2472: dbms_sql.column_value(l_pty_cur_id,25, x_party_detail_tbl(l_ind).attribute13);
2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);
2474: dbms_sql.column_value(l_pty_cur_id,27, x_party_detail_tbl(l_ind).attribute15);
2475: dbms_sql.column_value(l_pty_cur_id,28, x_party_detail_tbl(l_ind).object_version_number);
2476: dbms_sql.column_value(l_pty_cur_id,29, x_party_detail_tbl(l_ind).primary_flag);
2477: dbms_sql.column_value(l_pty_cur_id,30, x_party_detail_tbl(l_ind).preferred_flag);
2478:
2479: END LOOP;
2480:

Line 2477: dbms_sql.column_value(l_pty_cur_id,30, x_party_detail_tbl(l_ind).preferred_flag);

2473: dbms_sql.column_value(l_pty_cur_id,26, x_party_detail_tbl(l_ind).attribute14);
2474: dbms_sql.column_value(l_pty_cur_id,27, x_party_detail_tbl(l_ind).attribute15);
2475: dbms_sql.column_value(l_pty_cur_id,28, x_party_detail_tbl(l_ind).object_version_number);
2476: dbms_sql.column_value(l_pty_cur_id,29, x_party_detail_tbl(l_ind).primary_flag);
2477: dbms_sql.column_value(l_pty_cur_id,30, x_party_detail_tbl(l_ind).preferred_flag);
2478:
2479: END LOOP;
2480:
2481: dbms_sql.close_cursor(l_pty_cur_id);

Line 2481: dbms_sql.close_cursor(l_pty_cur_id);

2477: dbms_sql.column_value(l_pty_cur_id,30, x_party_detail_tbl(l_ind).preferred_flag);
2478:
2479: END LOOP;
2480:
2481: dbms_sql.close_cursor(l_pty_cur_id);
2482:
2483: EXCEPTION
2484: WHEN fnd_api.g_exc_error THEN
2485: x_return_status := fnd_api.g_ret_sts_error;

Line 2486: IF dbms_sql.is_open(l_pty_cur_id) THEN

2482:
2483: EXCEPTION
2484: WHEN fnd_api.g_exc_error THEN
2485: x_return_status := fnd_api.g_ret_sts_error;
2486: IF dbms_sql.is_open(l_pty_cur_id) THEN
2487: dbms_sql.close_cursor(l_pty_cur_id);
2488: END IF;
2489: WHEN others THEN
2490: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2487: dbms_sql.close_cursor(l_pty_cur_id);

2483: EXCEPTION
2484: WHEN fnd_api.g_exc_error THEN
2485: x_return_status := fnd_api.g_ret_sts_error;
2486: IF dbms_sql.is_open(l_pty_cur_id) THEN
2487: dbms_sql.close_cursor(l_pty_cur_id);
2488: END IF;
2489: WHEN others THEN
2490: x_return_status := fnd_api.g_ret_sts_unexp_error;
2491:

Line 2496: IF dbms_sql.is_open(l_pty_cur_id) THEN

2492: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2493: fnd_message.set_token('MESSAGE',substr(sqlerrm, 1, 255));
2494: fnd_msg_pub.add;
2495:
2496: IF dbms_sql.is_open(l_pty_cur_id) THEN
2497: dbms_sql.close_cursor(l_pty_cur_id);
2498: END IF;
2499: END get_party_dtls;
2500:

Line 2497: dbms_sql.close_cursor(l_pty_cur_id);

2493: fnd_message.set_token('MESSAGE',substr(sqlerrm, 1, 255));
2494: fnd_msg_pub.add;
2495:
2496: IF dbms_sql.is_open(l_pty_cur_id) THEN
2497: dbms_sql.close_cursor(l_pty_cur_id);
2498: END IF;
2499: END get_party_dtls;
2500:
2501: PROCEDURE get_all_party_dtls(