APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_T_TXN_LINE_DETAILS

Line 1132: PROCEDURE CSI_T_TXN_LINE_DETAILS_MERGE(

1128: END;
1129: END IF;
1130: END CSI_T_PARTY_DETAILS_MERGE;
1131:
1132: PROCEDURE CSI_T_TXN_LINE_DETAILS_MERGE(
1133: p_entity_name IN VARCHAR2,
1134: p_from_id IN NUMBER,
1135: x_to_id OUT NOCOPY NUMBER,
1136: p_from_fk_id IN NUMBER,

Line 1148: from csi_t_txn_line_details

1144: v_install_location_type_code VARCHAR2(30) := 'HZ_PARTY_SITES';
1145:
1146: cursor c1 is
1147: select 1
1148: from csi_t_txn_line_details
1149: where ( location_id = p_from_fk_id and location_type_code = v_location_type_code )
1150: or ( install_location_id = p_from_fk_id and install_location_type_code = v_location_type_code )
1151: for update nowait;
1152:

Line 1154: l_api_name VARCHAR2(30) := 'CSI_T_TXN_LINE_DETAILS_MERGE';

1150: or ( install_location_id = p_from_fk_id and install_location_type_code = v_location_type_code )
1151: for update nowait;
1152:
1153: l_merge_reason_code VARCHAR2(30);
1154: l_api_name VARCHAR2(30) := 'CSI_T_TXN_LINE_DETAILS_MERGE';
1155: l_column_name VARCHAR2(30);
1156: l_count NUMBER(10) := 0;
1157: l_cp_audit_id NUMBER;
1158: v_transaction_type_id NUMBER;

Line 1169: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_LINE_DETAILS_MERGE()+');

1165:
1166: RESOURCE_BUSY EXCEPTION;
1167: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1168: BEGIN
1169: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_LINE_DETAILS_MERGE()+');
1170:
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: select merge_reason_code

Line 1195: arp_message.set_token('TABLE_NAME', 'CSI_T_TXN_LINE_DETAILS', FALSE);

1191:
1192: IF p_from_fk_id <> p_to_fk_id then
1193: BEGIN
1194: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1195: arp_message.set_token('TABLE_NAME', 'CSI_T_TXN_LINE_DETAILS', FALSE);
1196: l_column_name := 'location_id';
1197:
1198: open c1;
1199: close c1;

Line 1201: update csi_t_txn_line_details

1197:
1198: open c1;
1199: close c1;
1200:
1201: update csi_t_txn_line_details
1202: set location_id = decode( location_id, p_from_fk_id, p_to_fk_id, location_id ),
1203: install_location_id = decode( install_location_id, p_from_fk_id, p_to_fk_id, install_location_id ),
1204: last_update_date = SYSDATE,
1205: last_updated_by = G_USER_ID,

Line 1221: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_TXN_LINE_DETAILS for '||l_column_name ||' = '|| p_from_fk_id );

1217: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_internal_party_message);
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: raise;
1220: when resource_busy then
1221: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_TXN_LINE_DETAILS for '||l_column_name ||' = '|| p_from_fk_id );
1222: x_return_status := FND_API.G_RET_STS_ERROR;
1223: raise;
1224: when others then
1225: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1230: END CSI_T_TXN_LINE_DETAILS_MERGE;

1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: raise;
1228: END;
1229: END IF;
1230: END CSI_T_TXN_LINE_DETAILS_MERGE;
1231:
1232: END CSI_PARTY_MERGE_PKG;